Is there a LIKE operator in odata filter?

Question

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

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

But it seems doesn´t work, so I wonder if is there an operator like or something that i can use for achieve this.

Look a tutorial Odata: http://docs.oasis-open.org/odata/odata/v4.0/errata03/os/complete/part2-url-conventions/odata-v4.0-errata03-os-part2-url-conventions-complete.html#_Toc444868693 — KingRider, Aug 07 '17 at 14:15

score 50 · Answer 1 · edited Oct 16 '20 at 08:39

50

Consider contains: $filter=contains(CompanyName,'Alfreds')

edited Oct 16 '20 at 08:39

Knelis

6,782
2
34
54

answered Apr 21 '17 at 12:49

John Little

778
6
14

1

I think contains is supported only from Odata 3 or 4. It's not available in version 2, AFAIK. – mydoghasworms Mar 25 '20 at 04:34

score 23 · Answer 2 · answered Oct 06 '17 at 09:49

23

$filter=substringof('Alfreds', CompanyName)

for more details see: http://www.odata.org/documentation/odata-version-3-0/url-conventions/ --> 5.1.2.4. Canonical Functions

answered Oct 06 '17 at 09:49

David Lopes

520
3
10

scher · Answer 3 · 2017-10-25T06:31:47.840

10

For me worked $filter=indexof(CompanyName, 'Alfreds') gt -1. This is case sensitive.

edited Oct 25 '17 at 06:31

answered Jul 11 '17 at 12:59

scher

1,813
2
18
39

score 7 · Answer 4 · answered Aug 20 '17 at 06:42

7

Use

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

This includes first index and above.

answered Aug 20 '17 at 06:42

Mostafa Khodakarami

760
8
14

score 4 · Answer 5 · answered Jan 05 '20 at 10:33

For oData v2, you can try:

$filter=substringof('sites/my folder/subfolder', FileRef) eq true

Samples using public oData Service:

https://services.odata.org/Northwind/Northwind.svc/Customers?$filter=substringof('Futterkiste',CompanyName) eq true

https://services.odata.org/Northwind/Northwind.svc/Customers?$filter=substringof('London',City) eq true

https://services.odata.org/Northwind/Northwind.svc/Customers?$filter=substringof('w',ContactName) eq true and substringof('London',City) eq true

Ref: enter link description here

Is there a LIKE operator in odata filter?

5 Answers5