Announcement

Collapse
No announcement yet.

Search value

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Search value

    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?


  • #2
    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.

    Comment

    Working...
    X