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 Tim
Certified Lead Developer
over 9 years ago

A more common approach, and much more efficient would be to do this on the database side to normalise the search fields. Speak to your DBA about using views or function based columns if your RDBMS supports them.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Tim
Certified Lead Developer
over 9 years ago

A more common approach, and much more efficient would be to do this on the database side to normalise the search fields. Speak to your DBA about using views or function based columns if your RDBMS supports them.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data