Questions tagged [filter]

A filter in SharePoint usually refers to a mechanism that limits the items displayed by the criteria provided.

Filter by
Sorted by
Tagged with
38
votes
6answers
93k views

How to make a filtered lookup field

I have a list of departments. This list will change over time adding new departments and "deactivating" others (because of structural changes). I would like to use this list as a look-up for other ...
7
votes
5answers
18k views

Checked null with dateTime in REST API SharePoint

I want to get all article pages which Article Date is not null. so I have try to do by this way. var ArticlePageContentTypeID = "...
14
votes
3answers
13k views

Paging and sorting with BCS

I going to use the new exciting External Content Type feature to display a list of data from an external LOB system. The list is potentially long, so paging with filtering at the LOB system side is ...
3
votes
3answers
7k views

How to get value of List Filter web part in Javascript?

I use the SharePoint List Filter web part on a page to control several Data View Web Parts. How do I read the current value of the List Filter in Javascript?
17
votes
7answers
80k views

REST with $filter for List Items in Sharepoint 2013

Sharepoint 2013, REST API, native C++ application: I want to get all Folder items from the list. Try /_api/Web/Lists(guid'GUID')/Items?$filter=FileSystemObjectType+eq+1 and get HTTP 400 Bed request. ...
5
votes
5answers
53k views

Filter a list view using URL parameters

I would like to dynamically construct a couple of URLs for our SharePoint users to filter down a rather large list view we have. Rather than create a bunch of different custom views, I was wondering ...
5
votes
3answers
11k views

Textual resolution of [Current User] and [Me]

In a list-view filter, I think I want to use either [Me] or [Current User]. I can't find a list of possible filter variables with their possible resolutions anywhere (Sharepoint Server 2010). What ...
4
votes
1answer
7k views

“Show filter choices” link instead of actual values in a list column filter

I have created an standard list with a few simple text columns. Why can I not see the normal filter values of all columns? Instead it shows a new "Show Filter choices" link (pic 1) which when ...
6
votes
2answers
11k views

Filter People and Group column using [Me]

Our list has a people and group column (called Users) which we want to filter using [Me]. It works when the field only contains individual users, but when the field contains a group (either SP group ...
12
votes
2answers
34k views

Querying a simple list with a 'User' column, using CAML

I'm having some trouble getting a CAML Query working against a very simple list. My custom list has the fields: Person : User Date : Date Amount : Lookup My query looks like this: <Query> &...
2
votes
1answer
2k views

How do I use REST $filter with a “Hyperlink or Picture” type column?

The $filter method works perfectly on regular text columns, but I can't figure out how to use it with a "Hyperlink or Picture" type column. For example: /_api/web/lists/getbytitle('Sponsors')/items?$...
8
votes
4answers
11k views

Filter view by current year

I have a Year column and I already know that it's not possible to filter a view using Year equals =YEAR([TODAY]) and use [TODAY] in calculated columns does not work as expected. Does there exist a ...
2
votes
2answers
2k views

How to filter a list by hour

I am on SharePoint 2013 and do not have access to Designer, as a preface. I am trying to create a list view that filters items by whether or not they were added in the last hour. I had done this ...
4
votes
3answers
4k views

How can create a view to filter the a list based on the current login user

How to create a view based on the current user is in a Person or Group field , this Person or Group field can contain multiple user but not SharePoint Group ,I try to use the contains to filter the ...
3
votes
3answers
18k views

Filter one list depending on selection in another list

let's say I have one list with my company's departments and one list with all employees. My list of employees has a lookup field to select the department. Now I want to have one page with a list of ...
2
votes
2answers
56 views

How do I create View/Filter to allow Teachers to see all Student assignments in a library, but the students to only be able to see their own?

So I use SharePoint in school for students turn in assignments and for teachers to grade them via Office 365. I have a SharePoint user group (Teachers) who need to see all the documents uploaded to ...
1
vote
3answers
4k views

The field 'Author' of type 'User' cannot be used in the query filter expression

I was making a rest api call with Odata filter author/id. I want to get survey responses of a particular user. _api/Web/Lists(guid'id')/items?$select=Id,Author/ID&$expand=Author/ID&$filter=(...
13
votes
3answers
17k views

Getting document name using REST (not title) while filtering document library

I am trying to filter through a list and return metadata of the documents in that filter. How do I return the name of a document from a document library using REST while being able to filter the ...
5
votes
3answers
10k views

Page a list via A-Z

So I am trying to create an a to z directory from a list of items which should be an easy task and it is really, however, I am trying to find the most efficient way of doing it. So I was thinking use ...
1
vote
1answer
463 views

Filtering for recurring events happening [Today]

Is this possible? Ryan Wheeler says its not here. Tim says it is if your view is of type "Standard View, with expanded recurring events" here. I haven't been able to get Tim's suggestion to work. (...
8
votes
2answers
51k views

How can I filter a SharePoint list based on a date column?

I have a column with "start date". I also have a column called "expire date". How can I make a filtered list so that it only shows items where the "start date" is equal or greater and equal or ...
4
votes
1answer
37k views

View filter settings: how to implement [TODAY] - 6 months

I am building a SharePoint 2013 portal. I have a custom list. On this list I try to modify the default view. I would like to change the filter settings. I would like to show only the items between ...
4
votes
4answers
16k views

REST service $filter Date column

Using the REST services, I'm trying to filter by the Created column, which is a Date data type. When trying to $filter on that column, I passed in the same date format that comes back in the JSON ...
4
votes
2answers
2k views

filtering rest api call by calculated column

I am not getting any results when I try to filter by a calculated column/field. The calculated field returns yes/no and it displays YESes and NOs in the view on browser. But when filtered for Yes or ...
4
votes
1answer
3k views

Dynamically setting Default Value in ParameterBinding through Javascript

To make a long story short (too late), we have a dropdownlist that is populated through a list of items. We want to use this dropdownlist to filter the list in a data view web part. This works ...
3
votes
1answer
1k views

What is this URL list filter parameter?

I have a I am trying to build but I need to know what to populate in one of the parameters... For Example... AllItems.aspx?FilterField1=Client_x0020_Name&FilterValue1=44&FilterOp1=In&...
3
votes
3answers
23k views

Filter current month in list

I have single text for Month. I want to create View with filter with Month. Example :Month is equal to the current month formula is =MONTH([Today]) But it is not working.
2
votes
3answers
11k views

Filter list view with url parameter. Strange behavior in Internet Explorer (SharePoint 2013)

I have a link opening the listview AllItems.aspx with specific filter parameter in the url which works fine. But if the user tries to change the filter of the prefiltered column, e.g. by selecting "...
1
vote
1answer
7k views

SharePoint List View Filter display 1 week

Our list has a view threshold of 20,000 items, which we usually reach every 12-15 days. Right now it's at 17,456 items and the oldest items are from December 7. So I want to create a filter to display ...
1
vote
2answers
649 views

How to write a caml query that filters by .pdf or folders?

How can I write a CAML query (for javascript ecma) that filters by only pdf documents or folders in sharepoint 2010? (this is for document libraries) Thanks.
1
vote
1answer
8k views

Filtering data programmatically on SPView

I would like to know how can I filter information in SharePoint list (Library of documents) programmatically. I have tried 2 ways but they don't solve my problem: Using the string lsWebPart....
1
vote
2answers
987 views

Filtered lookup column

i have two lists, list A creates events, list B creates reports based on events on list A. I currently have a lookup field (in list B) that pulls the event name from List A, that way they can select ...
1
vote
1answer
15k views

Filter by column WebPart in SharePoint 2013

I'm in need of a column filter web part in SharePoint 2013, more specifically said i need the web part to bring content of a list, library or calender based on a column in this list, library or ...
5
votes
3answers
13k views

Filter a Multiple Selection List Box in Sharepoint

I have what I thought a simple problem, but can't seem to find any solutions that work or exist in SharePoint 2013. I have a multiple selection list box in an InfoPath 2010 form. This box defines the ...
5
votes
3answers
2k views

Remember filter value using jquery and cookies

I am looking for a solution for the following problem: I have a large list that is related to a second list. The two list web parts are on one page, when you select an item in the first list, the ...
4
votes
1answer
3k views

Filter file types from list to NOT show certain file types

I have a document library list. Lots files, and a handful of file types. I know how to force a filter via the URL. Saw docx file. But right now, I have a need to show all files except docx, pptx, xlsx....
4
votes
1answer
616 views

Is Possible to make filter on calculated column??

I have Date column in list on based it i have create two calculated column month and year. Now i am trying to get data for particular month and year so I have give filter in REST query but it give ...
3
votes
1answer
1k views

What are All Possible Variables for a List View Filter?

In List Settings for a list you have the option to filter the list; there are variables such as [Me] and [Today]. Are there any others? What are they? (I've searched the world over for such a ...
3
votes
2answers
3k views

Disabled Users in SharePoint 2013 - Best practices

What is the best practice for managing disabled users? Should these be imported in SharePoint? And if not, how to filter these records? SharePoint 2013, Synchronization option in User Profile Service
2
votes
0answers
1k views

SP2010: Strange Content Query Web Part Behavior - Inconsistent results between users

I'm experiencing some very strange behavior with a content query web part. The web part uses no customised XSL, and is a simple query of "All sites in this site collection, from a Document Library, ...
2
votes
2answers
2k views

Seemingly random (non-alphabetical) ordering showing up in List column filter options?

I am using SharePoint 2007 (MOSS) and I have stumbled across a rather odd issue. I have a list that has a Lookup column to another list, which works fine. However, when viewing the list and trying to ...
2
votes
0answers
840 views

Filtering a XsltListViewWebPart that has "Send Row of Data To“ connection doesn’t work?

Filtering of a XsltListViewWebPart is absolutely no problem when you change the webPart.XmlDefinition property like this: var xml = new XmlDocument(); xml.LoadXml(...
2
votes
1answer
1k views

Pass list item metadata to filter for document library

looking for a way to filter a document library based on metadata from an item in a different library. For example I would have two web parts on a page , selecting on in item in library one would ...
2
votes
1answer
6k views

Filter SharePoint List based on value from another list

Scenario: I have two lists. One tracking all the points an individual has amassed, another showing all the prizes that this person can win. I would like to display on one page, the total number of ...
2
votes
0answers
522 views

Filter.aspx and GetDistinctValues

We found an issue, that filters on columns are stop working. Error message is: Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the ...
1
vote
1answer
261 views

CQWP filter greater than a number on a calculated field does not work

I have a calculated column that produces values from 0 to 20. While filtering the query for items greater or equal to 16 I still get all the values. The result of the Calculated column is a number (...
1
vote
1answer
55 views

Problem with date range filter

I have implemented date range filter on my SharePoint 2016 list using date filter web part. The complete procedure you can find here But after this implementation my list search box vanished. Even ...
1
vote
3answers
3k views

Need to filter a list with 10+ criteria

Need to create a list filter with over 10 criteria. Research tells me that it can be done with a Data View web part but I have not found any instructions on how this is done.
1
vote
1answer
44 views

SharePoint Filters and Custom Views Total Calculations

I have a Date column where users can enter any date they want, I also have separate column that shows the month of that same date column. I am trying to create a filter that will count how many ...
1
vote
0answers
116 views

Combine JSLink of UserContextFilterWebPart and a XsltListViewWebPart

I have a WebPartPage which includes a XsltListViewWebPart and a UserContextFilterWebPart. In order to filter the results by the user office and 'connect' the two webparts, I added the parameter <...