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
0answers
68 views

Losing Filter When Paging Back From Second Page

I have a list view of a task list with filters creating subsets of tasks (Archived, Constructing, Defect, Stabilizing, etc.). The default view has a limit that will return 100 items at a time when ...
0
votes
3answers
831 views

SharePoint 2007: Filter for current year

I have a list view web part and a field named [Year] set as a number. I am trying to filter to show this current year's items, given today's date. I tried the following filter but get Filter value is ...
1
vote
0answers
133 views

Multiple filter value webpart connection problem

We currently try to connect a custom webpart with a list view webpart. The aim is to send multiple filter values to the list view. The problem we have is that the list view does only use the FIRST ...
1
vote
0answers
21 views

Create Connection beetween TextFilter and List

I have created a text filter webpart on my page and a list webpart app on the same page. If I edit the filter webpart it says that the filter is not connected and I should open the webpart editing ...
0
votes
1answer
83 views

Display list content in editable form, filter on [Current User]

I have been trying to develop a set of pages that each has a form on the page where the user can type a response to questions on each page, and the form is saved when they submit it. If the user ...
1
vote
2answers
833 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
1answer
67 views

Filter file types from list to NOT show certain file types

I have a document library list. Lots files, and a handful of file types. I know how to force a filter via the URL. Saw docx file. But right now, I have a need to show all files except docx, pptx, ...
0
votes
0answers
73 views

reload objectdatasource for paging spgridview

I'm developing a search result in an spgridview loaded with objectdatasource. The issue is the Location object authorize's only 250 ItemsPerPage in this property. My spgridview is set to allow paging ...
0
votes
1answer
96 views

Autocomplete Text Filter Webpart

So I have to setup a text filter that is connected to a big list of names. Is it possible to configure some kind of autocomplete on this text filter to help users?
0
votes
0answers
17 views

Dynamically filter items in calendar [duplicate]

I've got a list used to hold items for appointments. It looks like this: The column I'm mainly interested in is the location. It doesn't have a fixed set of possible values. When showing the same ...
0
votes
0answers
39 views

Chart WP does not follow List WP when using Text Filter WP; X & Y field choices

Two questions if anyone can help. I searched and tried everything. SP2010 (1) I cannot get a Chart WP to reflect a List WP that is filtered by a Text or Choice Filter WP. The Chart WP DOES change ...
0
votes
1answer
139 views

How do I filter a Document Library based on the value of a column in a related List

I'm using SharePoint 2013 (Office 365). I have created a List to store details of our Projects. The Project list has a column which stores the current status of the project. This is a drop-down field ...
3
votes
0answers
102 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 ...
4
votes
1answer
985 views

List Filter Webpart not loading default value from custom filter provider

I have a request from a client to filter the data in a list view webpart based off of some user controlled custom settings for our sharepoint applilcation. These user settings are stored in a ...
1
vote
2answers
2k 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 ...
0
votes
2answers
36 views

How to change the text shown above filterwebparts in sharepoint?

I have some filter webparts in my site page. How to change or remove the text shown above the data filter webparts ? I have tried several ways, but its still showing the "FilterName" !! Any idea about ...
1
vote
2answers
851 views

Custom Search Page Filter Results

I have created a custom search page with a core search web part. It builds a query string in URL to populate the search results. k=[keyword] is the first, then to narrow the search to specific ...
1
vote
0answers
114 views

how do I create search in sharepoint list edit form using infopath

I have a list called Tasks in sharepoint 2013 that has a number of lookup fields. It was initially created by exporting data,tables and relationships from Access 2013. The client wants to be able to ...
0
votes
1answer
130 views

SharePoint 2010 Data View Joined Subview Filter Empty Rows

I've got two lists. I've created a dataview webpart and have created a joined subview. The data that is presented is correct. In the below example, there would be a match for all items with the ...
0
votes
0answers
25 views

Column header filter works when logged in, but not on public site

I've created a public site. It includes a document library (of conference white papers). I've added lookup columns from custom lists for the conferences the paper was presented at and the categories ...
0
votes
1answer
70 views

How can I get filter values from a COLUMN rather than a ROW?

I have two list web parts on my page. The first list has two columns: user name and ROLE. A user can be listed more than once if they have multiple roles. The view used returns only the roles for ...
2
votes
1answer
98 views

“Save List as Template” losing Filter web parts but leaving false connections?

My InfoPath form web part remembers some false connections from the past, and cannot take any new connections after Save List as Template. What I did is this: Customize Form in browser (SP2013) ...
1
vote
0answers
36 views

Send filter from Scorecard to Analytic Grid

The figure has an Analytic Grid at the bottom. It has a measure called [Application Count]. And it has a dimension named [Day Bucket]. At the top is scorecard. It has several calculated measures. ...
3
votes
0answers
184 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) ...
1
vote
0answers
198 views

SharePoint 2010 Data view web part filter values show all items when page loads

I prepared the data form web part with data source as SQL table on the page. On the same page, I created another list view webpart which contains items as parameters to filter SQL data through ...
1
vote
1answer
275 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 ?
0
votes
1answer
97 views

Filtered Lookup Field for more then one element

How could I do filtered lookup field for more then one element? I make for one Element by this link: http://howididit-sharepoint.blogspot.com/2012/04/filtering-lookup-columns.html But how could I ...
2
votes
2answers
3k views

How can I filter a SharePoint list based on a date column?

I have a column with "start date". I also have a column called "expire date". How can I make a filtered list so that it only shows items where the "start date" is equal or greater and equal or ...
0
votes
0answers
115 views

Ways of implementing data range filtering on event list

I have to implement filtering of my event list on several columns like EventType, Organisator and so on. All the columns filtering work well using OOB filtering by pressing on the header of the ...
0
votes
0answers
74 views

Wrong date representation on Russian site while filtering by date range using Date Filter Web Part (?)

I want to create date range filtering on my event list. For that I use the following article: List filtering by date range. I was able to follow all the article and connected Date Filter Web Part with ...
0
votes
0answers
41 views

External Content Type grab last rows of SQL table instead of first

I'm working with a limit filter on an external content type that grabs the first 1000 rows of my table. Is it possible to instead grab the LAST 1000 rows?
1
vote
4answers
15k views

Filter a list view using URL parameters

I would like to dynamically construct a couple of URLs for our SharePoint users to filter down a rather large list view we have. Rather than create a bunch of different custom views, I was wondering ...
2
votes
1answer
112 views

[Today]-15 filter not working on external list

I have an external list which is getting data from SQL Server. The table structure is as follows: Name InsertDate Where InsertDate is the date when record was inserted. I am trying to show only ...
0
votes
0answers
49 views

datasheet view showing duplicates only one time

Is there a way to show sort/filter a column, e.g. Assigned to to only show one time? For example John Doe John Doe Mark Miller James Bond Now I want to filter the datasheet view to only show: ...
1
vote
1answer
117 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 ...
1
vote
1answer
61 views

How to get value of multiple list filter webparts

Related to the previous post about accessing a List Filter Web Part value How to get value of List Filter web part in Javascript? How do I get access to the value of multiple list filter web part ...
2
votes
3answers
2k views

How to get value of List Filter web part in Javascript?

I use the SharePoint List Filter web part on a page to control several Data View Web Parts. How do I read the current value of the List Filter in Javascript?
1
vote
1answer
271 views

Filter Sharepoint 2010 List with Duplicate Items

I have a list that is being used for document control. The list contains multiple items with the same Title as well as other columns. It also contains a manual revision column I would like to display ...
1
vote
0answers
86 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 ...
0
votes
0answers
66 views

Filtering a SQL table with Business Data Connectivity Service

I have a rather large table (over 2000 rows) that I need to pull into a SharePoint list. Business Data Connectivity Service has a pretty easy method to accomplish this yet their filtering is so ...
1
vote
0answers
400 views

PerformancePoint Filters do not work (Sharepoint List as data source)

Tabular data source filter problem in PerformancePoint Dashboard Designer Dear all, Your suggestion on the following problem resolution will be highly appreciated. SharePoint 2013, Analysis ...
3
votes
1answer
1k views

Use one filter for multiple sharepoint lists

Can I define one list filter, and connect it to two lists on one web part page? I have two seperate lists on a page, both containing the 'author' column. Now, I want to add a filter to de page, so you ...
0
votes
1answer
838 views

Pass value via URL based on list filters

I have a list called "Stage", which has an Task list with a filter in the Displayform: If the user wants to add a new task to this specific item the newform for the Task appears. To be sure, the ...
0
votes
0answers
68 views

List Filter - Show “(Empty)” value, not working

So i have a List Filter web part connected to a list in a web part page. Show "(Empty)" value is checked, but when I select it in the filter it sometimes doesn't work, and the list stays filtered. ...
0
votes
1answer
106 views

Excluding specific files from Content Query

I have a content query web part that displays all the latest documents added to a site collection but there are one or two occasions where a file will be uploaded that the user doesn't want advertised ...
0
votes
2answers
51 views

Looking up a list 2007 Sharepoint

I am trying to devlop a search function on a list. It is a parts list that has the following headings:- Stock Number, Name, Colloquial How can i search in any of the fields by partial parts of a ...
0
votes
0answers
51 views

Multiple Filters - one filter based on textbox ID(working), and another filter for when entering the site(how?)

I have a site with a calendar and a normal document web part. Ive set a filter with a "control" parameter with a texbox id on both of them. So when I write something in the textbox, the web parts will ...
0
votes
1answer
2k views

Filtering sharepoint external list (BCS) from infopath

My requirement is to pull external data to InfoPath form based on a filter (e.g. Name filter) to Acheive this I did below things (I am working on InfoPath 2010, SP 2010) I have created a BCS to pull ...
0
votes
1answer
108 views

Filter calendar based on userinput

Im very new to sharepoint and trying to learn, just so you know :)..Im using Foundation, so please try to give answers that applies to Foundation Alright so I made a calendar webpart. I can apply som ...
1
vote
1answer
410 views

Multiple filters on view not working

I have a list on which I am applying the following filter (on a view) but it is not working. if((workflow == 16 && status == published) || (workflow == 2 && status == expired)) ...