Hot answers tagged filter
Try this https://mysite.com/site/_api/web/lists/GetByTitle('Posts')/items?$filter=Alert eq 1
Is your server's date correct? Maybe it's taking Yesterday's date as Today! If you have multiple server environment, check all the servers.
This is the solution: ContentType="Project portal" and SRExperienceRecord="True"
The string 'Bus'does not contain the string 'Sub', so the filter for substringof should not return this in the result. If you need to return items that contains all the characters in any place in the title, you should split the query text (like 'sub') to characters ('s', 'u' and 'b') and filter the items by logical ORing the substringof expressions in the ...
drop the (1) in the url. You are querying just item number 1. If you want to limit to 1 item use top. url: "https://gumdropsgc.sharepoint.com/sites/Training/_api/web/lists/getbytitle('Modules')/items?$filter=File_x0020_Name Eq 'FDAAgents'&$top=1" Watch your results though. returning 1 item comes back differently than returning a set of items ...
The formula computation in your case will be - Rule 1 || (Rule 2 && Rule 3 && Rule 4) The conditions in operators are grouped such that the higher precedence is given to 'and' operator, followed by 'or'. You can also check in the CAML Designer how the query is formed to validate your desired result before creating a view filter.
Only top voted, non community-wiki answers of a minimum length are eligible