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

learn more… | top users | synonyms

0
votes
2answers
511 views

Filter a List with server-side value comparision(onLoad or dynamically), SP 2010

How can we filter a list (while loading) by comparing it with a filter value that exists on the server side in Sharepoint 2010. i.e for example ...
0
votes
2answers
1k views

Using jQuery variable in DVWP

I am running SharePoint Foundation on Windows Server on a hosted site. I am able to retrieve a value with jQuery from the User Information List. Using Sharepoint Designer 2010, I have added a DVWP ...
0
votes
0answers
22 views

suggestions for list search alternatives using filters?

I have a very large list (a supplier directory) that I want to make "searchable" by keyword within the same page. My company has locked down/removed all of the search web parts so that users cannot ...
0
votes
0answers
21 views

Show related items (separate list) on display form?

I would like to conditionally filter a list with items which are relevant to one another. ListA has a few items, and ListB has records of things which pertained to those items. What sort of web part ...
0
votes
0answers
25 views

“Get Filter Values from” always returning blank?

I have a web part which shows a list view on a Display form. I'm trying to filter that web part where ColumnA value = ColumnA value and ColumnB value = Column B value on my display form. It filters ...
0
votes
0answers
12 views

Change size of filter button in ActionFilter WebPart

Is it possible to change size of ActionFilter Webpart button? Is it possible OOTB?
0
votes
1answer
19 views

Filter using url QueryString parameter 'a=…' does not always work for all fields

On a SharePoint SearchResults page the core results webpart can be refined or filtered using the QueryString paramters 'r=' or 'a=' in the url. I am attempting to use the 'a=' parameter which works ...
0
votes
2answers
49 views

The field 'Author' of type 'User' cannot be used in the query filter expression

I was making a rest api call with Odata filter author/id. I want to get survey responses of a particular user. ...
0
votes
1answer
22 views

Default filter from scorecard to another scorecard

I am using SharePoint Server 2013 and PerformancePoint Dashboard Designer 2013. I have two scorecards, primary and secondary as shown in the following figure. Fig: Primary and secondary ...
0
votes
0answers
50 views

How to create a filtered list on Lookup columns

I have created a couple of custom lists, one called Partners, the other named Countries. The Countries list is populated with a list of the world's countries. The Partners list is a list of our ...
0
votes
0answers
7 views

Grouping filter conditions in SharePoint 2007

For a document library I would like to create a view that will get everything greater than a certain date AND has either one field="test" OR second field = "test". If under view filters I do: ...
0
votes
1answer
24 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 ...
0
votes
0answers
22 views

Modifying CAML to filter by passed parameter

I have a list which contains a column called "Actual Start Date". I want to filter this list at the users command to only select the date they have selected. I have created a parameter called "Start" ...
0
votes
0answers
12 views

Filter based on User and another attribute of User

I have an Infoshare library in which I collect: Project name, Site, Status, Owner. I have multiple users from different sites that will have access to this database and I would like to show them ...
0
votes
1answer
13 views

Connection Formula - Current and Previous Member

I am using SharePoint 2013 and PerformancePoint Dashboard Designer 2013. I have a Filter and a Chart in a Dashboard Page. When I select a member in a Filter, I want the Chart to display data for ...
0
votes
0answers
41 views

Filtering on managed metadata columns in the insert link from SharePoint view throws invalid viewstate error

I've seen this error before in SharePoint 2010 and now in SharePoint 2013 (w/SP1), and it should be pretty straightforward to reproduce using the following steps: Create a document library Add one ...
0
votes
0answers
27 views

Export to Excel ignoring filters

I understand that when we use the Export to Excel button in the ribbon bar, what we get is an IQY file containing a query for OWSSVR. I am trying to filter the data returned by OWSSVR. When I go to ...
0
votes
0answers
14 views

Target filtered list results at individuals (not groups)

I am using several Content Query WebParts to filter rows in a list by various criteria. I wanted to use Audience Targeting with the respective CQWP's to display them certain individual users (but not ...
0
votes
1answer
40 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 ...
0
votes
1answer
39 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
45 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
47 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
15 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
20 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
79 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 ...
0
votes
1answer
85 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
17 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
53 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 ...
0
votes
0answers
56 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
63 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
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?
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: ...
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 ...
0
votes
1answer
326 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
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
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 ...
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
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 ...
0
votes
2answers
486 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
99 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 ...
0
votes
0answers
134 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
207 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 ...
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 ...
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 ...