Clever Geek Handbook

Is there a LIKE operator in the odata filter?

I'm trying to filter my data through OData where the FileRef field contains , lets say "/The root path/folder/subfolder"

I tried with the substringof

following:

$filter=substringof("sites/my folder/subfolder", FileRef)

But it doesn't seem to work, so I'm wondering if the operator has like or something I can use to achieve this.

Many thanks.

+3


source to share


4 answers 


$filter=substringof('Alfreds', CompanyName)


for more details: http://www.odata.org/documentation/odata-version-3-0/url-conventions/ → 5.1.2.4. Canonical functions

+3


source


It worked for me $filter=indexof(CompanyName, 'Alfreds') gt -1

. It is case sensitive.



+1


source


Using

$filter=indexof(CompanyName, 'Alfreds') gt -1

This includes the first index and above.

+1


source


Consider $ = Filter contains (CompanyName, 'Alfreds')

0


source






More articles:


All Articles