Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [filter]

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

308 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
2k 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
555 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
553 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
743 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
110 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
842 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
104 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
42 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
175 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
192 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
962 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
41 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
133 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
279 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
185 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
329 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
59 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
156 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
176 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
519 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
679 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
75 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
70 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
402 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
89 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
127 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
420 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
544 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
0answers
413 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
774 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
452 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
543 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
207 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
247 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
844 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
322 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
1answer
31 views

Disable Filter on Individual Column Headers of Custom List

I'm working with SharePoint 2013 and my Company don't allow the use of SharePoint Designer. I have created a custom list and am looking to disable the column header filter from a number of the ...
1
vote
0answers
15 views

Page filter doesn't work in edit mode

In my library I have the document id service turned on. So each new document gets an unchanging id. That is working. I then have some other documents which are related to a given page. I've created a ...
1
vote
1answer
110 views

How can I filter the Highlighted content web part to only show things that the user flagged as “Save for later”?

Seems like it should be pretty straight forward however I am not seeing it. There is already a baked in feature where people can tag a page or document "Save for later" at the bottom of most pages ...
1
vote
0answers
93 views

How to filter on a Edm.Double type using rest api?

I'm currently working on a small project where I need to query the Access Request list of a site, while this list is sort of hidden the REST api works perfectly (Mind you the title might be different ...
1
vote
0answers
19 views

Want Filter fetch data from SharePoint lIst on the below code of autocomplete JS

where DocumentOwner(People Group Type Column) = Me (Current Logged in User) Here i save current logged in user in a variable named as OwnerTitle and RequestStatus(Choice Type Filed) is equals to ...
1
vote
1answer
185 views

Get field value from form and pass to web part list view filter

In SharePoint 2016, I have created an edit form with a web part in the footer area that displays list data. I would like to grab the value from the field named Start Day and then use that value to ...
1
vote
0answers
69 views

Me Filter on Multiple Selection Lookup Column

I have found plenty of information about filtering lookup columns (title: Employee)during searches but I haven't located something that said using [Me] filter. I created a lookup column that has ...
1
vote
0answers
63 views

How configure List Filter Webpart?

I have two list : Users: Fields: username (AD users), region and city. Cities: Fields: regions and cities I would like to filter Cities list by current user's region. I created List filter ...
1
vote
0answers
29 views

Metadata Menue checkbox alternative

I've got a situation where I'm building a document library, with large number of values for each field in metadata and check boxes as a filter do not make sense there, since the list will be extremely ...