[SOLVED] Quick Search Issue - Not able to search non database field (Custom Fields)

I have a grid where there are many fileds from mysql database. Few Fields are Non database fields which are created in the grid through “New Field” option. This field relates to data from another table.

Now the issue is when i search for a data present in field which is a non database field (New Field) than the result is empty. Please help to resolve this issue.

The searches are applied on database field, because the system uses SQL and non-database fields are triggered on every row, after the search is complete afaik. Therefore you need to find a way to create a query where you embed the additional fields so that they become database fields. Another common way to achieve this is by using a database view.

1 Like

Hi, thanks. i have found the way out & created a view which is used in gridview. problem solved.