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 Christine Shen
A Score Level 1
over 9 years ago

You could use the proper() function to change the case of user input strings if all the results are the same case. forum.appian.com/.../Text_Functions.html
Or you can use a custom picker with the expression rules detailed in the link below, which ignores case. forum.appian.com/.../SAIL_Recipes.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Christine Shen
A Score Level 1
over 9 years ago

You could use the proper() function to change the case of user input strings if all the results are the same case. forum.appian.com/.../Text_Functions.html
Or you can use a custom picker with the expression rules detailed in the link below, which ignores case. forum.appian.com/.../SAIL_Recipes.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data