Filter condition in rest api query in sharepoint not working

Vanaraj n

The below mentioned i used to get the data from lists using filter but it doesnot retrieve the values.kindly help me out.

query.RestQuery = "getbytitle('RFA')/Items?$select=ESI_ProjectSeqNoLookupId&$filter=ESI_ProjectSeqNoLookup eq '136616'";

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Siva Krishna Kumar10y ago
Please try the following query.
"getbytitle('RFA')/Items?$expand=ESI_ProjectSeqNoLookup&$select=ESI_ProjectSeqNoLookup/Id,ESI_ProjectSeqNoLookup/Title&$filter=ESI_ProjectSeqNoLookup/Title eq '136616'";
I believe you are trying to filter using a Lookup column -ESI_ProjectSeqNoLookup
$expand - while working with Lookup columnsit be better if weexpand those.
$select - specify which value you want to retrieve like the Lookup column /Titleor /Id
$filter - specify through which you are filtering Lookup column Title or Id
Manpreet Singh10y ago
Kindly let us know what is the value you are receiving in $select?
Ibrahim Ersoy10y ago
You must use a field with filter.make sure you defined correctly. Also, you can try Caml Designer 2013 to solve this.
Ibrahim Ersoy10y ago
Whats query object? How does it find The path of The rest api? Does it work in another list/library?