34
votes
Accepted
Rest API - $filter multiple values
As far as I know, you can not use &. You have to use and or or inside the filter.
So try using something like that:
/_api/web/lists/getbytitle('Students')/items?$select=Title,ZIP&$filter=((...
- 3,173
14
votes
Getting document name using REST (not title) while filtering document library
FileLeafRef:
/_api/web/lists/getByTitle('list')/items?$select=FileLeafRef
File Name:
/_api/web/lists/getByTitle('<list title>')/items?$select=File/Name&$expand=File
Also, for querying a ...
- 631
9
votes
Accepted
Filter view by current year
In the Filter settings of a View you can only use [Today] as is, you can do simple +- calculations but you can not use Functions.
Remember: Do not add spaces in your View Filter calculations: [Today]-...
- 21.2k
8
votes
Accepted
SharePoint Online - Filter Category missing when adding web parts
You need to activate SharePoint Server Enterprise Site collection features(the one at Site collection level).
Go to site settings > Site collection features and activate it.
- 30.8k
8
votes
Accepted
Filter Created in SP REST API
SharePoint REST API endpoints take ISO formatted date string for filtering.
Try using below query for filtering on Date Field:
To check greater than 2018/10/05:
https://[tentat]/sites/[site]/...
- 42.8k
7
votes
How does SharePoint handle AND / OR view filtering?
Actually, at least on SharePoint 2007, when you're using the GUI, your filters are going to be applied and grouped in the order they were entered, ignoring the "AND before OR" rule.
So, in your case:
...
- 221
7
votes
Checked null with dateTime in REST API SharePoint
You can filter out list items with null columns in SharePoint 2016 (definitely after feature pack 1) using REST.
This filter syntax works:
$filter=DateField eq null
- 71
6
votes
Filter current month in list
You need to add two calculated columns that will work out the start and the end of the month. (This example uses [Due Date] but you can use any date/time column)
"Start of Month" =DATE(YEAR([Due ...
- 1,030
6
votes
SharePoint 2013 REST API - Is it possible to filter list by rich text column?
Apologies for previously erroneous and misleading answer
This is known issue. You cant filter data on rich text fields using $filter. It is present on 2013 On Premise and SharePoint online as well.
...
- 30.8k
6
votes
SharePoint REST filter items with multiselect field as null
I guess the REST filter does not support Null filtering.
The current implementation of REST does not support null values for
filtering on list item queries. But as this is a desirable feature,
...
- 8,481
5
votes
Accepted
What are All Possible Variables for a List View Filter?
There are no other options as such. but you can use calculated columns as an alternate solution which will have most of the excel based features.
- 2,166
5
votes
Accepted
SharePoint List View Filter display 1 week
You should modify your filter to be [Today]-7 , see the details below:
This should work for you.
- 2,622
5
votes
Accepted
How to create a view thats filter a group or person type field
You have to use person/group field is equal to [Me], not contains. Even if the person/group field contains multiple users, it will still filter correctly when using is equal to [Me].
- 43.3k
5
votes
Accepted
SharePoint Rest API URL to filter records from list
Something along the lines of this:
/_api/Web/Lists/getbytitle('Users')/items?$filter=Age ge 50 and Age le 100
- 43.3k
5
votes
Filter Hyperlink field url using SharePoint REST API
This is the limitation of REST API Filter that it cannot filter the Hyperlink fields.
So whats the workaround?
You can use CAML with REST to achieve what you want.
The CAML query will be like:
<...
- 8,481
4
votes
Filter list without using SPD
Note:
in June 2017, Microsoft disabled the use of JavaScript in a Calculated Column
That means given answers may not apply for newer SharePoint versions
For long explanation and work arounds see:
...
- 21.2k
4
votes
REST with $filter for List Items in Sharepoint 2013
this is what worked for me:
_api/web/lists/getbytitle('LISTNAME')/Items?$orderby=Created desc&$filter=FSObjType+eq+1
FileSystemObjectType seems not to work
- 41
4
votes
Accepted
Disabled Users in SharePoint 2013 - Best practices
If the users have already disabled from Active directory and you need to exclude them in SharePoint , you should do the following
Centeral Administration > Application Management > Mange Service ...
- 45.4k
4
votes
Accepted
Multi line text field in REST API filter url
Try it as below:
_spPageContextInfo.webAbsoluteUrl + "/_api/web/lists/GetByTitle('Site')/items?$select=Title,Keywords&$filter=substringof('test',Keywords)
If that doesnt work, you need to create ...
- 30.8k
4
votes
Accepted
Show only the most Recent Item Created
Create a view.
Set the Sort to Modified and descending.
Expand Item Limit and set it to 1, and select "Limit the total number of items returned to the specified amount"
- 6,807
4
votes
Show only the most Recent Item Created
You can do this following the below steps:
navigate to List Settings under views section - click Create view
enter the view name and select the desired columns
under Sort tab , select the ID column ...
- 1,647
3
votes
REST API OData Filter on Boolean not Working
Booleans are still broken when using SharePoint Online and the REST API. As of this writing, using 1/0 and true/false do not function as expected. When I tested, it actually returned the FULL dataset ...
- 53
3
votes
SharePoint 2013 list using multiple drop down list as filters
One way to deal with the issue is by utilizing the content by search and filters/refiners. You can also create a result source which retrieves the indexed results from the specified list. If your ...
- 4,189
3
votes
Accepted
Filter Rest API AssignedToId
This will sound crazy, but change it to filter on "AssignedTo" but keep "AssignedToId" in the select:
http://myserver/_api/web/lists/getbytitle%28'Tickets'%29/items?$select=AssignedToId&$filter=...
- 76
3
votes
Accepted
Multiple columns $filter in SP designer 2013 http web service call
Use the AND operator to join the filters
https://mydomain.sharepoint.com/mysite/_api/web/lists/GetByTitle('MyList')/items?$filter=Column1 eq 1 AND Column2 eq 2 AND Column3 eq 3
- 12.2k
3
votes
View List with 2 filtering
Yes you can.
Just go to modify view page, and add the filters like this:
closing date is greater than or equal to [Today]
publish date is less than or equal to [Today]
- 947
3
votes
Accepted
Filter a view to show only entries from a specific month
You can do it this way:
The problem is that you have to specify the year as well.
My example filters the items that are created between 1st and 31st of May, 2016
- 1,227
3
votes
Accepted
Filter library by current user using url
Using JSOM you can find the current user login and create the View URL dynamically.
var clientContext = new SP.ClientContext.get_current();
var oWeb = clientContext.get_web();
var currentUser = oWeb....
- 28.3k
Only top scored, non community-wiki answers of a minimum length are eligible