Query for search string inside field [Solution]

[oleg-demkovych]

Here is some solution to search inside field. I.e. we have:

"text": "some TEST here"

We want to get search by text TEST.

new $odata.Func('startswith','Text', 'TEST') will return empty, because test inside string (not on the start). Solution:

1. Set our search field to lowercase:
   var lowerFilter = new $odata.Func('tolower', 'Text');

2. Create new function to get index of out search text:
   var filterDataIndex = new $odata.Func('indexof', lowerFilter, 'TEST'.toLowerCase());

3. Create new predicate, with filter param (ge 0):
   var resultFilter = new $odata.Predicate(filterDataIndex, '>=', 0);

4. Create combination with predicates:
   var combination = $odata.Predicate.or([resultFilter]);

5. Send query and get data:
   service.filter(combination).query(success)

[devnixs]

Thanks! That may help.