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 get a list of all the text strings then use apply(fn!lower, pv!strings). Then also use lower on the user's input. Use wherecontains() to get the index of the matching string.
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 get a list of all the text strings then use apply(fn!lower, pv!strings). Then also use lower on the user's input. Use wherecontains() to get the index of the matching string.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data