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