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
189 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 ...
0
votes
1answer
60 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
488 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 ...
1
vote
1answer
238 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 ...
0
votes
0answers
55 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
61 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 ...
1
vote
2answers
218 views

Document Library Filter

This may seem like a simple question, but I have spent hours trying to get this function to work properly. I have two data columns in a document library with a view titled "today". The idea is as ...
0
votes
0answers
35 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?
2
votes
1answer
75 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
47 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
69 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
53 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 ...
1
vote
1answer
116 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
56 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
45 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
283 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 ...
0
votes
1answer
323 views

Unable to create valid SPDataSource Select Command

I am to use SharePoint Designer, no custom c# code. 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 dynamic ...
0
votes
1answer
630 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
55 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
81 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
50 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
49 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
77 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
263 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)) ...
0
votes
0answers
47 views

Using CQWP to fetch workflow tasks from all sites

I am using CQWP to fetch workflow tasks from all sites in a site collection. I am trying to apply a filter where "Assigned To" is equal to "Approvers" but it is not working because "Approvers" is a ...
0
votes
1answer
321 views

Filter not working when I create custom view (screenshots attached)

I have a list named "Test". On this list I enabled approval workflow named "Test". If you take a look at screenshot below which shows "All Items" view you will see 3 items, 2 approved and 1 ...
1
vote
1answer
126 views

SPGridView Filtering for taxonomy columns

I am displaying some sharepoint 2013 list data in SPGridView and I am using SPDataSource for binding list data with grid. The problem is with managed metadata columns filtering. In filter of managed ...
0
votes
0answers
29 views

SharePoint 2010 and InfoPath 2010 Query Tool

I'm attempting to build a tool that will utilize InfoPath 2010 to query a SharePoint 2010 List. The data is a State Information tool. The information per state is different per site (2 sites with an ...
0
votes
1answer
55 views

List filter error after migration from SharePoint 2007 to 2010

I have this problem after the migration from SharePoint 2007 to 2010 : When i try to filter a list from any site there's an Internet Explorer Javascript Error "_layouts/filter.aspx" permission denied ...
0
votes
0answers
79 views

Filter SharePoint documents based on a Tag filter using the Client Object Model

I am successfully fetching SharePoint documents using a CAML query via the Client Object Model. I would now like to add list of tags as a filter to this query, so that only documents tagged with ...
0
votes
1answer
1k views

Filter by column WebPart in SharePoint 2013

I'm in need of a column filter web part in SharePoint 2013, more specifically said i need the web part to bring content of a list, library or calender based on a column in this list, library or ...
1
vote
2answers
99 views

How to connect two lists and produce customized reports

I have two lists. The first list, 'Suppliers', is a list of suppliers with the various contact information. The second is 'Ratings' this contains a lookup of the supplier name and various number ...
3
votes
0answers
86 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 ...
0
votes
1answer
52 views

Filter Lookup from another lookup

I have a list of projects. Inside the project list you can select a Client. I have a list of Clients. I have another list, a list of Contacts, they have a lookup column called Client to specify from ...
0
votes
2answers
480 views

Filter one column with multiple value

Is it possible to filter one column with multiple values? It works in the Datasheet View but it doesen't work in the standard view. To add a new view with filtered values isn't an option.
0
votes
0answers
98 views

Unable to filter a list in a Datasheet view using URL

After doing some reaserch about the issue (mostly by reading Q/A here and over the net). I'm still having hard time filtering my Inventory list using URL. My goal is to get just one row from the ...
2
votes
1answer
296 views

Textual resolution of [Current User] and [Me]

In a list-view filter, I think I want to use either [Me] or [Current User]. I can't find a list of possible filter variables with their possible resolutions anywhere (Sharepoint Server 2010). What ...
0
votes
0answers
133 views

List filter “Show Filter Choices” causes unexpected request timed out exception

According to this article: http://sharepoint.nauplius.net/2010/09/sharepoint-list-filter-problems-or-show-filter-choices/ When a list has more than 500 items, the filters automatically switch to ...
0
votes
1answer
204 views

Filter large SharePoint 2010 list by lookup column

I have a list with 10,000 items. The list view threshold is 5,000. The list has an indexed lookup column. There is a view that should return about 400 items: My Column (indexed) is not equal to ...
1
vote
0answers
39 views

How I create a View for more lists?

It is my first question and I a noob in Sharepoint but I get a task to set a view for a list. I explain the idea. Our company has a teamsite where we can see who have task and who do this task. Now ...
0
votes
0answers
97 views

Programmatically updated SPList view filter is showing <!#Render Error--> in the view Moss 2007

Am appending a filter condition to a particular view alertview.Query = viewQuery.ToString(); alertview.ParentList.ParentWeb.AllowUnsafeUpdates = true; alertview.Update(); ...
0
votes
1answer
66 views

Store Query String for Filter WebPart in Session or like

With String accountName = this.Context.Request.QueryString["accountname"].ToString(); im getting the needed value for the filter webpart on my ListWebPart. If im paging my List, the url changes and i ...
0
votes
0answers
30 views

Picture library and metadata navigation error

I am using a picture library with several columns of type managed metadata. I have turned on the metadata navigation for one of the columns. it is generally working fine with one expection: if I use ...
1
vote
1answer
115 views

Multiple filters with query string

Imagine this situation: a SharePoint 2010 teamsite 2 lists 1 query string filter webpart to connected to the first list the 1st list is connected to the 2nd to filter the 2nd When I click an item ...
0
votes
0answers
30 views

Custom Filter option

How to add a custom filter option to a column in sharepoint 2010 document library. i have a document library and it has a column named status(like:pending,review), when we filter it by review option ...
0
votes
0answers
72 views

Filter list with a date range and display a page with charts

By following this tutorial I was able to filter a list Web Part based on the selected dates, the problem is that the chart I linked to the filtered list Web Part remains white and does not show any ...
0
votes
0answers
10 views

I have wiki site, with wiki items in the home page in a list, but cannot filter on this list

iam using sp2013 and using wiki. I have a list with all wiki pages. But I cannot filter on this list. How can I filter?
3
votes
0answers
172 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) ...
0
votes
0answers
22 views

MySites User context

I'm searching for a way to get the currently displayed user context in mysites. I have a list with a filter which is filtering for the currently displayed mysites profile. This works because i get ...
3
votes
2answers
364 views

Sharepoint Designer 2013, XSLT List View Options ribbon option is not showing

So I'm wondering if this is a bug or not. I have an ordinary Wiki Page, also tried making an Article Page. Once this page is made, I add an XsltListViewWebPart that points to a list, which is fine, ...