Saturday, 15 May 2010

SharePoint 2013 REST How to select a look up field and also filter based on look up field? -



SharePoint 2013 REST How to select a look up field and also filter based on look up field? -

i can't select field in sharepoint 2013 list. can't filter base of operations on field.

for illustration have list name test , list has fields: title, company, province company , province fields want filter based on province field using rest query gives error:

my query:

https://testserver/sites/aib/obc/_api/web/lists/getbytitle('test')/items?$select=province/title&$expand=province&$filter=province/title eq 'abc'

it gives error when set url in browser testing gives blow error:

<m:message xml:lang="en-us">the field or property 'province' not exist.</m:message>

how filter based on field in sharepoint 2013 rest ?

use $expand blow code:

/_api/web/lists/getbytitle('test')/items?$select=province/title&$expand=province&$filter=province/title eq 'xyz'

rest sharepoint odata sharepoint-2013

No comments:

Post a Comment