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.
Release: APILMP99000-5.0-Live API Creator Microservices-Partner Component:
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: