Questions tagged [filter]

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

329 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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 ...
5
votes
2answers
3k views

How to create SPQuery by filtering date interval

I have a custom aspx form where I retrieve list items by filtering two values EventDate and EndDate. I have a realization but it returns nothing: DateTime eventDate = Convert.ToDateTime(properties....
4
votes
0answers
662 views

select multiple key filter values in metadata navigation

I just discovered metadata navigation while setting up an Asset Library to store my company's media. It's really handy, given that I had previously just been applying filters directly from the columns....
4
votes
0answers
559 views

How to filter a paged and sorted external list

I have succesfully implented an external content type with a read list method, which can sort and page through the external data. The external content type has 4 filters (two limit and two wildcard) ...
4
votes
1answer
4k views

Filter list in a WebPart by Contains not Equals (adding a wildcard)

If I need to "search" list data using a wildcard, I have to modify the XSL code. A step-by-step instruction for doing it in SP2007 has been provided at Can I Filter a List/Data View using Contains ...
4
votes
0answers
760 views

Query string filter on an InfoPath lookup field

I am trying to use a query string filter to filter data on an InfoPath form using this guide. The column that I'm trying to filter is a lookup field and it is not available in the list of Consumer ...
3
votes
0answers
124 views

Construct CAML Query from ListView Filter URL-Params in SP2013

Im trying to construct a CAML query from the current Listview filter settings. I dont know in prior how many filters the user may set. My goal is to create a CAML query which has the exact same ...
3
votes
1answer
1k views

Filter sharepoint list using multi line text field

I'm trying to filter a sharepoint list using ajax api. So one of the filtered field is Multi line text field (FieldType.Note) , after performing request it throws an error telleing that the field ...
3
votes
1answer
129 views

List view filter

Can I filter my view to show only 5000 recent added/updated out of 6000 items? My list has more than 5000 items and I want to show only 5000 recent items.
3
votes
0answers
44 views

no items returned in a view with a filter on a calculated column

I'm having a strange issue and Google isn't helping me much in figuring out why. I have a custom list with 3 fields: Title Year calculated column =left([title], 4) single line of text Month ...
3
votes
2answers
1k views

Why doesn't FilterOp work with Inplview?

I am trying to pass a URL into a SharePoint listview with parameters for filtering. The FilterOp paramter doesn't work with inplview for me. If I pass the parameters in normal query string format (?...
3
votes
0answers
177 views

Meta data navigation filter on custom page?

I have a public facing website were i want our customers to be able to browse all our support documents using the Meta data navigation filter, but i dont want them to access the real document page. Is ...
3
votes
0answers
193 views

Ribbon is disabled when I Filter an external list in SharePoint 2010

I created an external list in sharepoint 2010 (SP1) using SPD. The backend is sql server. The I added a wildcard filter on a column called Source_System (and a limit filter). The out of the box ...
3
votes
0answers
1k views

Modify XsltListViewWebPart XmlDefinition property not works as expected, filtering

I have got list with subfolders. I would like filter list items in current subfolder using additional caml query. I would like to add filtering functionality by modifing caml query. I try to update ...
2
votes
1answer
1k views

Exclude items from view using a filter (“does not contain”)

I know there are several other threads on this topic, but haven't seen anything that would assist with my issue. Unfortunately I cannot rely on my users to regularly update meta-data (even something ...
2
votes
0answers
2k views

Multiple $filter in OData query

Here is my OData query: https://XXX.sharepoint.com/sites/pwa/_api/ProjectServer/Projects?$filter=Id eq guid'xxxx'&$select=Id,Name,StartDate&$expand=Tasks&$select=Tasks/Id,Tasks/Name I ...
2
votes
1answer
68 views

Sharepoint large list filtering

Currently in Sharepiont 2010. I have a list that just went over 5000 items. I have columns indexed and all views are filtered with these indexed columns. One of the columns is a "Date and Time" type ...
2
votes
0answers
331 views

Filtering a Grouped By view by current year in SharePoint Online

I am aware of this and have done this multiple times before and it used to work fine. However, currently I am facing unexpected behavior and it's different in Modern and Classic views. I have a list ...
2
votes
2answers
715 views

Content Search Web Part filter by user properties on Multi-Choices field

I'm trying to filter a content search web part by using the current user's office value {User.Office} imported from AD. I followed Ben N.'s example here: https://en.share-gate.com/blog/filtering-...
2
votes
0answers
201 views

Filtered lookup based on lookup

My situation is this: I'm trying to set up a review site for the publishing house I'm working for. Basically, the editors should be able to pick reviewers for new books based on certain categories. ...
2
votes
1answer
364 views

Add filters/refiners to CQWP webpart

I am on SharePoint Online environment, As a high level summary, we currently have pages that use a PageQueryString as a filter for a CQWP. However, from the results that are displayed within the web ...
2
votes
0answers
87 views

Filtering a Web Part list using the current month viewed on a Calendar page

We have an Advertising Calendar which shows when our confirmed marketing events will happen. At the bottom of each month’s page, my boss would like a separate list web part that filters to show only ...
2
votes
0answers
202 views

Issue while filtering multiple columns if one of the fields is Indexed

I have a list in SharePoint 2016 with over 35k items and around 15 custom Fields. I have a view that displays only around 300 - 400 items. When users filter the view using the column filters, the ...
2
votes
0answers
237 views

Not Showing Any Results in List App Part When Using Text Filter Web Part

I'm a site collection administrator in our SharePoint 2013 on premise instance. I want to use a text filter box to filter the contents of a list view app part based on a "Keywords" column. However, ...
2
votes
0answers
668 views

Filtering & Sorting of the list not working, after applying JSLink with custom render

Following the anwser from this post: JSLink: Is it possible keep the default list view header with column headers for filtering? I managed to sucessfully register new template for rendering list ...
2
votes
0answers
745 views

how to show filter choices by default on lists

my list has 501 records and I was expecting that "Show filter choices" will be available on each drop down columns but it this didn't happen. when i try typing ?Filter=1 at the end of the URL, I see ...
2
votes
0answers
76 views

Filter web part list from URL parameter

I want to have a site template, that has a central web part list on it (I managed to make this, using SharePoint Designer. Added a Data-View) which is filtered by some data from the URL, or from a ...
2
votes
0answers
75 views

SharePoint 2010, filter Document Set in URL

I'm trying to filter a document set in SharePoint 2010. For example, the URL to the main document library is #1) http://uat/sites/dps/doc/Forms/folders.aspx I would access a document set like this ...
2
votes
0answers
415 views

How can I filter a List View in a Web Part page using AJAX so the entire page doesn't reload/refresh?

I have a Web Part page with a list view. I know how to use filter webparts that connect to the list view to filter the list. But those all reload/refresh the entire page. I was wondering if there is ...
2
votes
0answers
94 views

How to create multiple operator options in one filter, and how to add “contain” filter in external content type?

I'm creating external content type from SQL server to business data list. I would like to create a read list operator based on search stored procedure. I noticed in creating filter table, there's no "...
2
votes
0answers
140 views

Select Default Filter in BDCM File

When working with Business Connectivity Services (BCS) and Business Data Connectivity Model (BDCM) files, does anyone know in the code where to set the "default" Filter and hide the option? Right ...
2
votes
2answers
472 views

Use a workflow to filter a list

I have a spreadsheet that contains numerous products, each one with a unique PN, desc and price. There is similarity between products, contained in additional columns with simple YES or NO values ...
2
votes
0answers
613 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 ...
2
votes
1answer
1k views

Passing employee id from AD to a SharePoint list

I have a property named EmployeeId in AD. UPS is configured and is getting all users EmployeeID from AD. I have made an external list. I want to pass logged in user's EmployeeID to that list so it ...
2
votes
0answers
1k views

People column cannot be filtered by empty value

I have a list in which there is a people column. I used to be able to filter the list by empty values in the column, but that has abruptly stopped working. That is, normally, I should be able to ...
2
votes
0answers
440 views

Filter a connected list- How to show all by default?

I have two lists embedded as individual webparts on my SP2010 page. The two lists are connected so that the first list can act as a filter for the second one- there is a column which is common between ...
2
votes
0answers
801 views

Filter a CQWP on a Lookup Column

I'm creating a custom page layout that contains a CQWP that I'd like to display documents related to the page. The document library has a lookup column that relates to the page title in the Pages ...
2
votes
0answers
459 views

Filtering LookupMulti by FilterMultiValue SP2010

I can't filter LookupMulti's column using FilterMultiValue. My Url contain this fragment FilterName=Tags&FilterMultiValue=Flower;Sword Three is nothing, apart correlation ID. I found in ...
2
votes
0answers
551 views

Custom filter provider web part and multiple values

I'm trying to build a custom filter provider that can detect the user language (the language selected in SharePoint by the user) and provide it as a filter. As a language can be represented in many ...
2
votes
1answer
210 views

Filter current user by two values

Is there any way to set the filter for a web part to be seen by two people? for example, in my infopath form, i have a traveler from the active directory, and the creator of the form, who are not ...
2
votes
0answers
248 views

DVWP ASP.NET Filter for all pages

I have created a drop down along with DVWP as described in http://social.technet.microsoft.com/Forums/en-US/sharepointcustomization/thread/949d4443-58a4-464b-9603-e4c280740650. However I see one ...
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
0answers
853 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
0answers
345 views

Filtering one List Part, by another Web Part, where the Second web part has a filtered View

I have one list, called "Company Reports" and another list "Companies" The Companies list has a field called Include(yes/no), and I have created a View which filters it to only show active companies. ...
2
votes
0answers
273 views

Business Data Connector List Column not working BDC XML Definition

I have a BDC connected to a SQL Table with 2500 Rows. I'm able to add a Business Data List WP to a page and point it to the BDC source and it looks fine except for limited number of Rows. However, if ...
1
vote
0answers
14 views

Get recently added / updated users from Azure Active Directory

I want to fetch all the users from Azure Active Directory who are recently modified/added using Azure Active Directory Graph SDK. I tried to use the LastDirSyncTime property but for all the users the ...
1
vote
2answers
30 views

Filtering items in SharePoint list view

I've got a SharePoint list with the following columns: City: eg. London, New York, Milan Visit Type: Business, Leisure Date: date visited There could be multiple city visits of the same type, but ...
1
vote
0answers
102 views

SharePoint 2019: filter users and groups in People Picker with ActiveDirectoryCustomFilter

We are currently trying to filter the People Picker in SharePoint 2019 for users and groups, but we have a little bit of trouble. Currently, we have the following filter: (&(objectCategory=person)(...
1
vote
3answers
192 views

Dynamic filtering using lists, hide information until selected

New to this forum, tried searching without any luck. I wish to hide information from a list until a selection has occurred. I'm using dynamic filtering. Example I got two lists (List1, List2) List 1: ...
1
vote
1answer
193 views

Sharepoint online — managed metadata term set filter not working

Novice user here. We have created a list of products on sharepoint online. Products are tagged using a managed metadata term set. We would like to use this to either A) filter the list and save views ...

1
2 3 4 5
7