Skip to main content
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

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
8 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. $filter=DateField ne null
Poriotis'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.9k
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
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.9k
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

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

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.9k
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

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

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

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
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,237
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
3 votes
Accepted

Can we pass null in $filterby in REST query SharePoint?

It seems that ODATA for SharePoint REST does not support the filtering based on null. https://social.msdn.microsoft.com/Forums/office/en-US/4690e596-aeae-49e7-9057-f31352d92e07/how-to-filter-on-empty-...
D.Kliemt's user avatar
  • 308
3 votes

Is Possible to make filter on calculated column??

$filter does not work with calculated columns. In that case you have to write a CAML query and make a POST request. Request End-Point /_api/Web/Lists/getbytitle('List Name')/GetItems CAML var ...
Atish Kumar Dipongkor's user avatar
3 votes

SharePoint Rest API URL to filter records from list

The appropriate url will be {site url}/_api/Web/Lists/getbytitle('Users')/items?$filter=Age ge 50 and Age le 100 But if you only want specific columns from it, go for {site url}/_api/Web/Lists/...
Mayank Srivastava's user avatar
3 votes
Accepted

filter in document library [me] does not work?

Try translating [Me] to your language. If I'm right this is Swedish language, so try with: [Jag]
Damjan Tomic's user avatar
  • 3,656
3 votes
Accepted

Filter by URL - not parameter

There will not be any pretty solutions with the constraints that we have here. With OOB, we will need to do ugly hacks like: Change navigation mode to manual and add url with querystring parameter as ...
Alok Kumar Gupta's user avatar
3 votes

Limit and filter List

To return unlimited results, just drop the $limit=1000 from the query. EDIT: Indeed SharePoint by default returns 100 items of the list. The correct way to return a bigger subset of items would be to ...
moe's user avatar
  • 5,267
3 votes

Item Level Permissions and Lookup Columns

As OOTB solution, I suggest doing the following: Create a view for each Garage (Filtered by Garage ID/Name) Create a Promoted Links list. Garage Name, Graghe View URL In Promoted Links list, add a ...
Mohamed El-Qassas MVP's user avatar
3 votes

Only show users filled in values in a Choice field

if you want to view the data like it is in a standard view of SharePoint, you have unfortunately no other possibility as to filter every single value with "not equal". Be aware that you are only able ...
HappySPUser's user avatar

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