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

learn more… | top users | synonyms

1
vote
1answer
535 views

Display connection information within a ITransformableFilterValues web part

I created a filter web part by extending the ITransformableFilterValues interface, similar to this page: http://msdn.microsoft.com/en-us/library/ms499375(v=office.12).aspx. I want to mimic the ...
0
votes
1answer
706 views

Unable to create valid SPDataSource Select Command

I am to use SharePoint Designer, no custom c# code. I am currently using a SharePoint:SPDataSource on a DVWP to show a list. When the SelectCommand is blank, it works fine but I will need to create ...
0
votes
0answers
18 views

Filter view by hyperlink column

I'm using SharePoint 2013 and I have a library in which one column is of the type hyperlink. Now I have a view in which one of the columns to be displayed is the hyperlink, this one has the url and ...
1
vote
0answers
14 views

Linked webparts filter

I have a page with 2 linked webparts, actually 2 list views. (One view is simply sending a parameter to the other view). My problem is that when I use the list filter (by clicking on the view column) ...
3
votes
1answer
3k views

Filters on a large list exceeding throttle limit

On a SharePoint 2010 Server installation, I have a list with more than 5000 items. I created an indexed column and a view based on this column which is returning 100 items only, so far less than the ...
0
votes
1answer
35 views

Dynamic filtering an XsltListViewWebPart

I want an XsltListViewWebPart filtered based on some custom metadata derived from the current user. Following Claudio Brotto’s article ...
1
vote
2answers
19 views

Save Choice Filter Selection

I have four lists on a web page that I want to be controlled by a choice filter web part. The four lists have a common column between them, so I want users to be able to select an item in the choice ...
1
vote
1answer
18 views

Need to show oldest 3 items in one webpart and the remaining items in another webpart

I have a scenario where I want to divide a list's items into 2 webpart views - one that shows only the x oldest items (people that should be seen next) and another list on the same page showing the ...
1
vote
1answer
23 views

Conditional List Filters

I'm having trouble figuring out a way to create a filter that I need for a list I've made. I need to filter a certain column based on the current user. For example, if the current user is "John ...
0
votes
1answer
30 views

Sharepoint 2013 - Search files into File Share (content source) with filtering by folders

I crawled content that is on stored on file server (File Share - content source in SharePoint Server) and i get the results in SharePoint search. Everything is fine but i need to have some kind of ...
0
votes
1answer
16 views

How to Connect a list from another Sharepoint Web Application

How Could I connect a SharePoint another list which is situated in another web application? A mast get another list from another web application, and give a filter to show only this elements, which ...
1
vote
1answer
34 views

Jquery datatable [duplicate]

I have a custom list with Employee Name, Approval Status, Created Date columns in it.I am using SharePoint 2010 version. I want to display the list items depending on one of the column "Approval ...
0
votes
1answer
17 views

Open in explorer view to show a filtered view of the list or library

I am looking at a filtered view of my library on my site so I am only seeing certain items. When I click open in explorer, I see everything in the library and my filter is no longer applied. Is it ...
1
vote
0answers
30 views

Unable to filter Excel web access web part

I have an excel web app with a pivot table that's data comes from a powerpivot SQL data source. I am trying to filter this data via basic 'choice web part'. when applying the filter i get an error ...
1
vote
0answers
37 views

Filter [Me] doesn't work correct

We have a task list with a filtered view for the users. The filter is "assigned to = [me]". Normally it works fine, but now there is one users who doesn't see all of his tasks. So i checked the ...
0
votes
1answer
26 views

REST API get by author differences by platform

I find that when I want to retrieve custom list items by author (in this case, by the current user) I need to use a different query whether using SP2013 on premise or O365. I tried creating the same ...
0
votes
0answers
25 views

Show Filter Choices shows empty options in SharePoint 2010 List

We have SharePoint 2010 and there is a list that has 4600 items. When users try to filer a column, they get Show Filter Choices from the drop down menu: When they select Show Filter Choices They ...
2
votes
1answer
901 views

BDC List column picker filter - search/filter not working and exact entry says not found?

I'm working with MOSS 2007. Rephrasing the question. I have a BDC column to an external datasource in a custom list. Today searching and filtering is not in place and actually exact matches are not ...
0
votes
2answers
25 views

Refine search get aspx pages only based on tags

I have to search all the aspx pages in my site-collection based on tags. For example - Tag "finance" has been added to finReport.aspx and denialsReport.aspx. So when user search finanace, it should ...
0
votes
2answers
38 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.
0
votes
1answer
606 views

Current User Filter Web Part - Wildcard Filter from Multiple Names

I have a list view webpart which contains a field which is a list of users, semicolon delimited. The field is a single line text field. I then have a current user filter web part which filters list ...
1
vote
1answer
4k views

How to add a custom filter for a chart?

I have a list which contains multiple columns. I have inserted the chart web part and it's showing the graph based on the column list. Now I want to add a custom drop down filter which contains column ...
0
votes
1answer
21 views

Filtering SharePoint List columns using a textbox (like filters in MS Excel)

I want to enable search on every column of a SharePoint List. It should work like filtering in Excel. User can type in the textbox and filter that column.
0
votes
0answers
26 views

Filter on Views don't work after update 2956175 is applied on SP2013 env

We have applied Filter on a task list view on the Assigned To column. This was working fine. Last friday we installed the Security patches available from Microsoft published on 3/10/15. Immediately ...
1
vote
3answers
80 views

Retrieving files from a document library using REST with a filter on a field

I have a standard document library with one added field StudyId (string). I can't figure out how to retrieve files using a filter on that field. I retrieve files as following: ...
0
votes
1answer
2k 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 ...
0
votes
1answer
33 views

Sharepoint 2013 CQWP - Filter by Approval Status

I'm kind of stuck in a Content by Query Webpart. (Yes, i'm aware i'm on 2013, and yes, i could use Content by Search WebPart, but this is a standard edition, so no, finally i can't use CSWP) I would ...
0
votes
1answer
521 views

Grabbing a filter value via CEWP code behind

I have employed a Query String Filter to parse a value and send it to a chart web part. now I would like to use this value in a CEWP to provide an explaination/clarification for the chart, but the ...
0
votes
1answer
2k views

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

This question isn't new here, but after reviewing existing posts I still need your advice. If I need to "search" list data using a wildcard, I have to modify the XSL code. A step-by-step instruction ...
0
votes
1answer
27 views

How to filter item based on StartDate and ExpireDate?

I have an announcement list with StartDate (datetime with time) and EndDate (datetime with time). I am adding 15 future annoucements and i would like to automatically display item or items when start ...
2
votes
3answers
2k 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 = ...
0
votes
2answers
40 views

Filter by login user department on SharePoint

I need to create a new view on a custom list that filter only the items that are added (created) by the users department, so any user can view all other items that are added by the other members of ...
0
votes
0answers
22 views

Remove filter from Html Form Web part

I've created a HTML form web part and connected it to a document library web part. It filters fine and as expected, but the only way I found to remove the filter is to reload the entire page. As I ...
1
vote
1answer
708 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 ...
1
vote
0answers
13 views

Recreating Extenal Item Picker for Internal Lists

SharePoint Online E3 License. SharePoint 2013 comes with a number of BCS Web Parts, one of which is a Filter WebPart. This can be connected to other BDC web parts on a page, or lists with an ...
1
vote
3answers
2k 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 ...
0
votes
2answers
51 views

SharePoint 2010 Rest API filter statement not working

I am trying to filter a rest query but can't seem to get it to work. During my testing, the following statement works (no filter, a alternate way to get the item I wanted): // sort the list desc and ...
0
votes
3answers
7k views

How to apply 2 different conditions in the filter of list?

I have two different conditions based on which I need to apply filter on the list data. The conditions are based on the user role and status column. I have applied the filter condition as : ...
0
votes
0answers
20 views

How to avoid large list error when modifying URL filtered view

I have run into a problem with SharePoint that is frustrating my users to no end. I have a large list (>5000 rows) that users can arrive at by clicking links formatted like this ...
1
vote
1answer
17 views

Order of choices in filter drop-down

In a list, at the filter drop-down section, choices are in ascending order: Is it possible to display the choices in descending order? (It would be more comfortable because users usually choose the ...
0
votes
0answers
31 views

Filter list by Organisation Data

I have an approval process set up on SharePoint online for leave tracking which links into a list which has every employee and there leave balances. It all works nicely however I want line managers to ...
0
votes
0answers
60 views

Filter BCS Data by Users AD Group

I'd like to know if it is possible (and if so, how) to filter the BCS data results by the AD group a user belongs to. For example. User A belongs to AD group 'group1'. In the external data that ...
0
votes
0answers
33 views

Dynamic filter in list view -> Changing the operator

Very simple question, the list view dynamic filter (The one you see when you click on a column header), uses the OR operator for a multi-value field. However, I want to use the AND operator instead. ...
5
votes
1answer
5k views

Can I Filter a List/Data View using Contains instead of equals in SP2010?

I have a page where I am using a Text Filter to filter a long (15K) list of clients in a Business Data List web part. The filter works fine for All and for an entered name, so long as the full name is ...
1
vote
0answers
16 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 ...
0
votes
0answers
17 views

Filter entries of Data View Web Part using Sharepoint Designer 2010

I am trying to set up a list of current birthdays on our Sharepoint Website which runs with Sharepoint Foundation 2010. So farI got: A list containing name, birthday(Date/Time) and two calculated ...
0
votes
3answers
100 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 ...
0
votes
3answers
54 views

Document Library Not Filtering Columns

There is a document library which has over 5000 items, it has passed its item view threshold. The view was reduced to show items that met certain requirements. This view now shows less than 1000 ...
1
vote
1answer
54 views

web api query with $filter return HRESULT : 0x80131904

I try to filter items using SP2013 web api such this request : _api/web/lists/getbytitle('Activity')/items?$filter=Mylookupfield eq 'SomeValue'. All works fine in my DEV machine but in the customer ...
1
vote
1answer
29 views

Filter contact list by current month

I have a list of employees with a birthday date/time field in the format of mm/dd/yyyy. I want to create a filter that will show me employees that are having a birthday in the current month. How ...