Okay I’m sure you’ve seen a bajillian copy pasted examples on the interwebs demonstrating you how to get filtered columns on a single column using the REST based API and $filter operator.
Hell it’s a shame that even MSDN has only the simplistic examples.
For instance, if your data looks like this –>
|COLUMN1 ||COLUMN2 ||COLUMN3 ||COLUMN4|
|VALUE11 ||VALUE12 ||VALUE13 ||VALUE14|
|VALUE21 ||VALUE22 ||VALUE23 ||VALUE24|
|VALUE31 ||VALUE32 ||VALUE33 ||VALUE34|
you can easily do this ..
/_vti_bin/ListData.svc/ListName?$filter=COLUMN1 eq 'VALUE11’
And yes that’ll work . .FOR one column. But what if I wanted to include more than one column in such a filtering condition? Do you do?
/_vti_bin/ListData.svc/ListName?$filter=COLUMN1 eq 'VALUE11’&$filter=COLUMN1 eq 'VALUE21’
No, that won’t work!! You can only specify one operator at one time. In order to achieve such multi column filtering you would use a URL like as shown below -
Hope someone found this useful!