Tagged Questions

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
111 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 ...
1
vote
0answers
557 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
541 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
1k 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
151 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
53 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
119 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
604 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
1answer
713 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
155 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
84 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
3k 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
124 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
120 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
76 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
1k 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.
2
votes
2answers
2k 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
1answer
393 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
44 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
137 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
84 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
194 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 ...
3
votes
0answers
205 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) ...
3
votes
2answers
597 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, ...
0
votes
1answer
117 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
770 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
110 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
0answers
73 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 ...
1
vote
0answers
90 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
122 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 ...
0
votes
1answer
1k 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 ...
1
vote
2answers
147 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.
3
votes
0answers
185 views

Query string filter on an InfoPath lookup field

I am trying to use a query string filter to filter data on an InfoPath form using this guide. The column that I'm trying to filter is a lookup field and it is not available in the list of Consumer ...
0
votes
1answer
406 views

Items in folder not showing after filtering

following situation... The goal: i have a document library with different Project folders. Within these folders are various project files (exel - word - pdf etc.) that belong to that specific ...
0
votes
1answer
40 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
244 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
85 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
305 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
81 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
2answers
839 views

XSLT filter for Yes/No Column/Field in SharePoint Custom List for SharePoint Designer DataView WebPart

I'm trying this with no luck: [@ActiveStatus='Yes'] also tried 1, '1', 'True' .. get no rows back.. If I remove the filter I get back all rows. full line in code view looks like this: ...
1
vote
0answers
150 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
161 views

Filtering Web Part on Lookup Field with multiple values

I'm looking to be able to filter a web part to show multiples values, based on a field in another web part that contains multiple values. The scenario I'm testing is: In a school environment, the ...
0
votes
1answer
33 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
121 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
181 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 ...
0
votes
1answer
402 views

Filter Search Results Based On Link Clicked

I am using SharePoint 2013 and have links on the home page such as (Tax, Assurance, Advisory). Does anyone know how I can in SP 2013 use one search page but filter out the results depening on the link ...
0
votes
1answer
142 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 ...
1
vote
1answer
110 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
3answers
1k 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 ...
0
votes
2answers
70 views

filter with url: should be very easy but doesn't seem to work?

This is really weird as it seems so simple to me, but just won't work. myserver/site/lists/ExampleList/AllItems.aspx?ID=133 isn't this the basic url filter to only show that item? it does work ...