Hot answers tagged

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=((...
Patrick's user avatar
  • 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 ...
Amay Kulkarni's user avatar
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]-...
Danny '365CSI' Engelman's user avatar
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.
Gautam Sheth's user avatar
  • 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]/...
Ganesh Sanap - MVP's user avatar
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: ...
FireSBurnsmuP's user avatar
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
Poriotis's user avatar
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 ...
MAllen22842's user avatar
  • 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. ...
Gautam Sheth's user avatar
  • 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, ...
Aakash Maurya's user avatar
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.
kesava's user avatar
  • 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.
Mohamed Derhalli's user avatar
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].
Eric Alexander's user avatar
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
Eric Alexander's user avatar
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: <...
Aakash Maurya's user avatar
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: ...
Danny '365CSI' Engelman's user avatar
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
gome's user avatar
  • 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 ...
Mohamed El-Qassas MVP's user avatar
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 ...
Gautam Sheth's user avatar
  • 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"
Mike Smith - MCT's user avatar
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 ...
A.Saéed's user avatar
  • 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 ...
Jiffy's user avatar
  • 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 ...
Aveenav's user avatar
  • 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=...
Shel's user avatar
  • 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
Mike's user avatar
  • 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]
Nisarg Shah's user avatar
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
Gintas K's user avatar
  • 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....
Amal Hashim's user avatar
  • 28.3k

Only top scored, non community-wiki answers of a minimum length are eligible