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

learn more… | top users | synonyms (1)

1
vote
0answers
393 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 ...
2
votes
1answer
1k 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
526 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 ...
0
votes
0answers
63 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?
4
votes
4answers
33k 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
235 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 ...
1
vote
1answer
453 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
114 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
4k 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
1k 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
295 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
1answer
2k 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
1answer
346 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
57 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
1answer
3k 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
178 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
1k 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)) ...
11
votes
5answers
12k views

Paging and sorting with BCS

I going to use the new exciting External Content Type feature to display a list of data from an external LOB system. The list is potentially long, so paging with filtering at the LOB system side is ...
1
vote
1answer
223 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
1answer
141 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
1answer
11k 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
161 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 ...
1
vote
2answers
811 views

Page Field Filter displaying 1;#ColumnName instead of ColumnName. Bug?

I have a Document Library with a column (we'll call it ColumnName) and a Web Parts Page with a value assigned for that column. On that page I have a list view displaying the Doc Library files and a ...
0
votes
1answer
746 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
53 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
253 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(); alertview.ParentList.Update(...
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
3answers
5k views

Filter List By User Group

I am running Sharepoint Foundation on Windows 7. I am trying to filter a list based upon the user group a person may belong to. If the current user is member of the Division Managers group, then the ...
0
votes
1answer
115 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 ...
1
vote
1answer
397 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
1answer
178 views

Custom field values in filter picker

Is there any way to modify logic which SharePoint use to display filter values? When there is custom field which inherit from SPFieldText, the filter values are taken directly from fieldValue... ...
0
votes
2answers
2k views

How to filter(search) a list

I'm not sure if this can be achieved with Filter or need to create a search function. I have a list with about 500 items with potential to grow to several thousand. I want to give user ability to ...
1
vote
0answers
76 views

Filtering Multi-Selection Lists

I am having trouble filtering a multi-selection list, and I think the problem is with the reference to the current item. I need a way to reference the item that the filter is being checked against (...
2
votes
0answers
228 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 ...
1
vote
1answer
1k views

Calendar DVWP to show only today with recurring and all day events

I got a interesting problem here. I developed a dashboard for one of our departments, they wanted a widget that shows only today's events. I have the DVWP in place, and filtering by a calculated ...
1
vote
0answers
143 views

InfoPath current() Function in Multi-Lists

When you call current() from a multi-selection list, where does it resolve to? I ask because I need to use it in a complicated filter to control what values are present in the list. Has anyone used ...
1
vote
1answer
381 views

How do I set FilterOperator1 in the URL?

I know I can filter a SharePoint list by adding ?FilterField1=fieldname&FilterValue1=value to the URL. Microsoft's documentation also lists a property FilterOperator1 that you can use if you want ...
4
votes
1answer
1k views

Use Term Store as a Filter Webpart

I have a couple of libraries that share a term store field for Clients. I put two list views on a page and planned on using the term store navigator to filter the lists, but couldn't find it in the ...
1
vote
2answers
370 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.
0
votes
1answer
51 views

InfoPath Filtering

I am working on a form for a SharePoint list called Scheduling, to be used for scheduling assets. The problem I am looking at now involves filtering the options in a multiple-selection list. I would ...
1
vote
1answer
509 views

Populate a Filter web part from a List item and execute

I have a Business Data Related List called Projects. It is connected to a Business Data Item, so it has the option to select an item (the two-way arrow next to an Item). From this List I need to pass ...
0
votes
1answer
153 views

List view on subsites with filtered choice field

I have a site with a list of projects. I then have multiple subsites which represents all the companies. I need to have a page on each subsite that contains the projects list with a specific view. ...
0
votes
1answer
486 views

change view of calendar web part

i have a calendar with a custom column called discipline. This is a master calendar that all disciplines will use. I've added the calendar web part to a sub page and i need to filter the calendar ...
1
vote
0answers
108 views

Customize Filters in Document Library

We got several document libraries which has a column type. This like all other columns can be filtered by values that is inserted on the document library. In Type, we got file types like doc, docx, ...
1
vote
0answers
261 views

Sharepoint Webservice not filtering Data

Working Version Issue: I am querying SharePoint using SP CAML Query Helper. Using SPCQH I am able to retrieve one order. The query works. Once I add the query to my Biztalk solution the query below ...
0
votes
1answer
49 views

Can a calendar popup be added to a list's date filter instead of a list of text choices?

How would I replace the OOTB list date filter dropdown to be a calendar view instead? JQuery/Javascript solutions are feasible for me if it is indeed possible. So far looking at the page tags upon ...
3
votes
1answer
188 views

Filter Webpart to match any column

I have a list of products with hundreds of entries. Each product has contact details with it as well as company information etc. I would like to be able to run a search on this list and return ...
0
votes
1answer
414 views

Regarding Filter on a List

on a list on Filter section i.e. 'show items only when following is true' is limited to only 10 conditions only and I have 25 conditions/rules to apply (due to lot of users) so that I can create a ...
1
vote
1answer
232 views

Filter a parent list by a particular child list item's lookup field value

I have two lists, Activities and Objectives. The Activities list has a multi-value lookup field that references the Objectives list. I am trying to create a filtered view on the Objectives list that, ...
0
votes
1answer
265 views

XSLT Filter list items in DFWP by Current Date & Time

I have a list with the fields "Effective" and "Expires". Both fields are Date and Time data types. I want to show the list items where the current date/time is greater than Effective and less than ...