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
2
votes
2answers
11k views

Trying to open a SharePoint List item in Modal Dialog in Sharepoint 2013 Office 365 (online)

Sorry for the long post. This has been killing me. I had this script working perfectly fine in SharePoint 2010 (online) and basically i have a source custom list (list A) with a hyperlink column and a ...
2
votes
1answer
2k views

Filtering datasheet view in Sharepoint 2010

I want to create a filter on Multiline Text Column inside a Datasheet View by means of out of the box features. Is it possible to provision such a feature so that when I click on the dropdown on such ...
2
votes
1answer
3k views

Custom List Filter - update list view only on second button click

What I try to do is making a simple list filter tool for SharePoint 2010 lists. What I have so far: I made a VisualWebPart (VWP) named "ListFilter", which should update the view of the list (see code ...
2
votes
2answers
431 views

Single Quote Issue While Filtering Records In SpGridview

In SpGridview single quote is breaking the filter expression as we are having filter format as "{1} like '{0}'",any idea how we can handle this situation.
2
votes
1answer
5k views

User Profile Synchronization - Filter by AD OU or DN attributes

I am attempting to filter out a subset of users in Active Directory from being pulled into the User Profile Service. The users need to be filtered by the Organizational Unit property (ou), which is ...
2
votes
2answers
3k views

Turn filter on by default on a sharepoint view

I would like to filter a column defaultly on my SharePoint view, is it possible to do so ?
2
votes
2answers
4k views

Disable filtering option on the list after the webpart page has loaded loaded completly

I am filtering a list by passing query string to a custom list http://TestSite/TestSubsite/Lists/TestList/allitems.aspx?FilterField1=FirstName &FilterValue1=Apelles This does the job of ...
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
3answers
503 views

Creating a view filter

I have a litle issue to create a view. Let me summarize the case. There is a list with all the daily tasks, assigned to someone. I would like to create a view that shows one the assigned task to "you",...
2
votes
1answer
2k views

How to retrieve User Information List data

I would like to filter a list based upon a user group that the user may belong to and a specific value found in the User Information List for that user. I tried doing this with CAML in SharePoint ...
2
votes
1answer
394 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
1answer
846 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
59 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
281 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
579 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
198 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
359 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
75 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
191 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
212 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
642 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
725 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
414 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
91 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
137 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
448 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
587 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
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
433 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
797 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
458 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
547 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
209 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
2answers
2k views

Filter an External List on a datetime Field

So I have an external list in SharePoint 2010 that connects to a SQL database and pulls the data successfully. I also have 2 filters defined along with a limiting (TOP) filter. The first filter is ...
2
votes
0answers
851 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 ...
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 ...
1
vote
3answers
3k views

Show only the most Recent Item Created

I'm currently looking to create a view that only shows the most recent item created. I have a list that calculates weekly reports and i want to allow the user to have direct access to editing the ...
1
vote
3answers
4k views

Create a web part to display filtered list item

I've got a Contact list with info about departments in our organization. The list is at the department level, not person level. It has the following columns: Department Title ["Contact Helpdesk:", "...
1
vote
2answers
5k views

Filtering List using CAML query and Binding it to dropdown in C#

I have the following code which retrieves all items from list "Employee Info" and bind it to Dropdown list EmployeeDD. if (!Page.IsPostBack) { DataSet ds = new DataSet();...
1
vote
1answer
3k views

SharePoint 2010 - Add filter to a list with PowerShell

How it is possible to add a filter to a list with PowerShell? (I want to add a filter to multiple lists) Is there any tutorial, articel or example?
1
vote
2answers
463 views

Item Level Permissions and Lookup Columns

I'm trying to build a simple Garage Management System to see what spot someone is assigned. So I have the following lists: Garages Levels Spots Spots has a lookup column to Levels, Levels has a ...
1
vote
1answer
2k views

How to create a display for last major version only

We are using a SP2013 site with some workflows and we need to display documents withe their last version only. Let's say we have 5 docs with minor versions (1.2, 2.6, 2.2, etc...) and we want to ...
1
vote
5answers
10k views

Filtering REST call with lookup field

We have a column defined on a custom list that allows for multiple select of values from another custom list. The column on the list is call Panels. When I do a REST call against this list, I can ...
1
vote
2answers
750 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 2 3
4
5
17