How do I do a case insensitive search using a!queryFilter? For example, the valu

muthukumars over 9 years ago

How do I do a case insensitive search using a!queryFilter? For example, the value in the database table could be aPPiAN and the user could try to search using the keyword - appian. How can I do bring back the results irrespective of the case entered?

Discussion posts and replies are publicly visible

Parents

0 muthukumars over 9 years ago

Thank you both for the inputs.
@christines I can control the case of the user input with proper() but I don't know in what case the values are stored in the database. Also, I have to search with keywords from an excel sheet that the user has uploaded. So picker option wouldn't work.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 muthukumars over 9 years ago

Thank you both for the inputs.
@christines I can control the case of the user input with proper() but I don't know in what case the values are stored in the database. Also, I have to search with keywords from an excel sheet that the user has uploaded. So picker option wouldn't work.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data