Sysfilter on Table Resources

Document ID : KB000114144
Last Modified Date : 07/11/2018
Show Technical Document Details
Issue:
We have a table resource where we use sysfilters to filter out data. We use structured filters 'like'/'like_uc'/'like_lc' for an autocomplete in our application where we compare the searched text with the column.

This filter does not work for some below combinations for example:
1. ea
2. aa
3. ap

If we search with only 'a' then we get records string with 'aa' also with 'aaa' but when searching directly 'aa', we get blank results.
Resolution:
Sysfilters are case sensitive. For example, if you want to filter on the word 'Aardvark', you would have to specify 'Aa'. Specifying 'aa' will not bring back this result. 'like_uc' and 'like_lc' are not valid parameters. To cover case sensitivity, you will need to use the like_or parameter in your sysfilter:

EXAMPLE: .../Zoo?sysfilter=like_or(animal:'%Aa%',animal: '%aa%')
Additional Information:
For more information about sysfilters, see Structured Filters.