Search value

steventrs · May 7, 2020, 8:11pm

Hi,

My display value to user in a field, example: Shoes. But in the database, I stored the value as ‘3’ instead which is the foreign key.

Now, when user type ‘shoes’ in quick search/advanced search, there is no result. The user must type 3 instead which the user wont know.

May I know how should I change in the search criteria to search the value as displayed?

steventrs · May 7, 2020, 9:05pm

Hi,

Can anyone kindly help on this?

I have a number of fields are stored in numeric value in the database and user hardly can use the search function since they wont know the foreign key value.

Thanks.