Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [filter]

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

4
votes
0answers
494 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
548 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
0answers
723 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
97 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
0answers
39 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
0answers
174 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
190 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
951 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
0answers
83 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
0answers
161 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
0answers
53 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
136 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
132 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
452 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
645 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
71 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
67 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
397 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
119 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
0answers
511 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
401 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
752 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
446 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
541 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
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
838 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
308 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
272 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
25 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
68 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
17 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
0answers
53 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
43 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
18 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 ...
1
vote
0answers
38 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
0answers
32 views

I need to dynamically filter Sharepoint 2016 calendar. Is it possible?

I am using sharepoint calendar, but I am stuck at one scenario. I have Team column in my sharepoint list, I need to dynamically filter calendar view based on selection of values in Team dropdown list. ...
1
vote
0answers
22 views

SharePoint 2016: filter on managed metadata column with AND operator

We are using SharePoint 2016 and have a document library with a multiple managed metadata column. In this document library we try sometimes to filter on this column. We can select 1 or more terms in ...
1
vote
0answers
78 views

Modern page: Show FILTER PANE in Library webpart. Possible?

I am using this modern "filter pane" in my library, but when I use a Document Library Webpart to show this library as part of a page, the filter pane is not present. How can I show the Filter Pane ...
1
vote
0answers
65 views

Filtering SharePoint List by Another SharePoint List

I've been searching the forums and doing research online with no luck- apologies if this has been answered before. I have a list with several thousand items in it. I often receive bulk update ...
1
vote
0answers
20 views

How to Get User-Generated Columns from Ajax

Is it possible to determine which columns in a SP List or document library were custom generated by the user? I'm essentially trying to recreate SharePoint's front end in my app, and I want to add ...
1
vote
0answers
13 views

Linking to a webpage with a search function and auto filtering that function

In my company, there is a SharePoint site with a page with a search box on it. Underneath this box are two separate web parts, showing two separate lists. The user is asked to enter a value into the ...
1
vote
0answers
15 views

Sharepoint 2013 wiki template with web parts

We're on SP2013 site collection. I'd like to create a template for the 200 different profiles we have. Each profile consists of: 1. wiki for tables and unstructured data, 2. wiki columns (display on ...
1
vote
0answers
75 views

How can I change down arrow color in a filter header of a list

Hello, Above is the image of the header of a list that is filterable. List is a webpart in a sharepoint page. However the color scheme makes the down arrow barely visible. I cannot change the all ...
1
vote
0answers
58 views

Get filtered projects list by applying filters on its fields SharePoint Online CSOM

How to get filtered projects list by applying filters on its fields SharePoint Online CSOM.(by using OData or something?) can it be possible using OData?
1
vote
0answers
209 views

Sharepoint Calendar View Filter - Show items in current year

I have events on my calendar that have Start Time dates in 2016, 2017, and 2018. I have a calculated formula on my Calendar list named Year Calculated Event - Current. The formula is =YEAR([Start ...
1
vote
0answers
31 views

Create a Key Filter from an External Data column

I'm currently creating a Document management system in On-prem SP 2013 to store documents with specific meta data terms so the document library is easily searchable/filtered. We have an external DB ...
1
vote
0answers
232 views

Custom predecessors column in custom list

I have a list of tasks, custom list template not task list, where I have lookup column on another list Projects, so my tasks are grouped by that lookup column, by Projects. I added predecessors ...
1
vote
0answers
218 views

Avoid threshold limit with view using “Or condition” on person columns

Here is my issue: I have a sharepoint 2013 list with more than 5 000 items inside. In order to avoid threshold limit I indexed several columns and created views using these columns. Most of the views ...