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
1answer
3k views

How to add a custom filter for a chart?

I have a list which contains multiple columns. I have inserted the chart web part and it's showing the graph based on the column list. Now I want to add a custom drop down filter which contains column ...
1
vote
2answers
19 views

Remember filter value using jquery and cookies

I am looking for a solution for the following problem: I have a large list that is related to a second list. The two list web parts are on one page, when you select an item in the first list, the ...
0
votes
1answer
586 views

Unable to create valid SPDataSource Select Command

I am to use SharePoint Designer, no custom c# code. I am 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 ...
1
vote
2answers
250 views

SP 2010 REST $filter column

I'm trying to filter a list using the REST service. The column im trying to filter is the default column "Modified". My problem is: I can get all itens created today, but not only the items created ...
3
votes
2answers
71 views

REST with $filter for List Items in Sharepoint 2013

Sharepoint 2013, REST API, native C++ application: I want to get all Folder items from the list. Try /_api/Web/Lists(guid'GUID')/Items?$filter=FileSystemObjectType+eq+1 and get HTTP 400 Bed ...
0
votes
0answers
15 views

Async Refresh LVWP on load with HTML Form Param

I have a List View WebPart that I need to asynchronously take a parameter from an HTML form WebPart and update the LVWP. I have some odd behavior happen when I attempt this. I have Async Load, Update, ...
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 ...
0
votes
0answers
8 views

Filtering by column heading column causing error Cannot show the value of the filter

I have a list in sharepoint i have created three views which filters the items according to the year they were created. But when i am in the list and i want to filter with the column heading i get the ...
3
votes
2answers
2k views

Filter a Multiple Selection List Box in Sharepoint

I have what I thought a simple problem, but can't seem to find any solutions that work or exist in SharePoint 2013. I have a multiple selection list box in an InfoPath 2010 form. This box defines the ...
0
votes
4answers
3k views

REST service $filter Date column

Using the REST services, I'm trying to filter by the Created column, which is a Date data type. When trying to $filter on that column, I passed in the same date format that comes back in the JSON ...
1
vote
1answer
518 views

Display connection information within a ITransformableFilterValues web part

I created a filter web part by extending the ITransformableFilterValues interface, similar to this page: http://msdn.microsoft.com/en-us/library/ms499375(v=office.12).aspx. I want to mimic the ...
1
vote
1answer
722 views

How can I Filter a Joined DVWP by [Current User] in Multi-User People/Groups field?

I have a joined DVWP. List A includes a "category" lookup field among other columns. List A includes the same "category" lookup field as well as a People/Groups field with multiple selections. I'd ...
1
vote
1answer
846 views

BDC List column picker filter - search/filter not working and exact entry says not found?

I'm working with MOSS 2007. Rephrasing the question. I have a BDC column to an external datasource in a custom list. Today searching and filtering is not in place and actually exact matches are not ...
2
votes
1answer
2k views

Filters on a large list exceeding throttle limit

On a SharePoint 2010 Server installation, I have a list with more than 5000 items. I created an indexed column and a view based on this column which is returning 100 items only, so far less than the ...
0
votes
1answer
24 views

Filtering a SharePoint list

I have 2 lists and 2 pages. The first one lets call it System contains 2 columns, Name and Action. The Action column is a URL that redirects to the second page. The second one lets call it ...
0
votes
1answer
439 views

Grabbing a filter value via CEWP code behind

I have employed a Query String Filter to parse a value and send it to a chart web part. now I would like to use this value in a CEWP to provide an explaination/clarification for the chart, but the ...
0
votes
1answer
26 views

SP13: Filtering Default Calendar Start and End Time

I am working off of a list from a calendar. Within the calendar list I am to filter all event columns except Start Time and End Time field. See image below for a visual example. Does anyone know ...
0
votes
0answers
9 views

Filter WebCollection using a List of Urls

I have a List that holds the URLs of the Subsites I want to retrieve. I need to use that as a filter (optimize the query) so when I query the SharePoint it only returns the webs I want to work with. ...
0
votes
1answer
355 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
1answer
27 views

Due in next 90 days filter in a data view

I'm making data views and for a couple of them I want to filter to show any items that are due within the next x amount of days. My immediate thought was to filter by Current Date + 90. I've done ...
0
votes
1answer
463 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
0answers
37 views

Lookup Columns and Web Part Connections

I'm working on creating a Page Template which will display various content from different lists together based on a common lookup field which is in each list. I've created a new Content Type based ...
0
votes
1answer
1k views

Custom List Filter - update list view only on second button click

What I try to do is making a simple list filter tool for SharePoint 2010 lists. What I have so far: I made a VisualWebPart (VWP) named "ListFilter", which should update the view of the list (see code ...
0
votes
0answers
14 views

Show blank list on No Item Exists error

I have two lists, one which contains project Issues and one which contains lower level actions. The Issues list has a column with a hyperlink that takes the user to the actions list and it passes 'ID' ...
1
vote
0answers
85 views

When I click on the library setting “Metadata navigation settings” or “Per-location view settings ” got the error: Object reference not set to an

I am using sp2010. I have a document library with documents. I have 3 managed metadata columns in this library. When I go to the library settings and click on the option "Metadata navigation settings" ...
0
votes
0answers
18 views

Change size of filter button in ActionFilter WebPart

Is it possible to change size of ActionFilter Webpart button? Is it possible OOTB?
1
vote
0answers
36 views

SP 2013 : Specific item in a lookup field cannot be filtered

the list A has a lookup field connected to list B in field Title. One of the items in list B has title "CCAA". On A/ViewAllitems, i can filter in column lookup:listB:Title for every item, except for ...
0
votes
0answers
32 views

Multiple Fields for Query String Filter on WebInfo Part

Using sharepoint 2010 I have a form that i would like to autofill values via a url i.e newItems.aspx?ID=44. I have been successful in doing this with one parameter using a query string URL filter. I ...
1
vote
1answer
26 views

SharePoint list to show all items, with the exception of closed/completed items that are older than a specific amount of time (e.g. 7 days)?

I am familiar with filtering the list to only show current items (not closed/completed), but is there a way to show all items except any that have been placed in closed/completed status more than 7 ...
1
vote
1answer
44 views

Sending user's input from JavaScript into date filter webpart

I want to do date filter for one field in my external list using calendar in order to hep user input date value. Since drop-down calendar in date filter web part doesn't work (i don't know why, when ...
1
vote
1answer
19 views

How do I filter a free text column in a MOSS 2007 list?

I want to add a filter to a list I have created. When I use a form filter I don't get the option of filtering by any of the columns that are multiline text columns. Basically I have an A-Z. The first ...
0
votes
2answers
69 views

Query String Filter Configure Connection not responding

So I have a Query String (URL) Filter, and a SSRS Report Viewer. I am trying to connect these two and a Configure Connection -- Webpage Dialog pops up and I can't do anything to my IE now. Normally ...
0
votes
2answers
30 views

Alerts on Document Library filter by user

I copy folders and documents to a document library by code through a feature. I am trying to prevent alerts from being fired when the document library is populated. I tried setting the Filter ...
0
votes
0answers
42 views

Pointing (or Connecting) to List View Web Part (SP2013)

Although I have solved this issue using a Filter List web part connected to the List web part, it is not good enough for my boss. He would prefer that the user have to only click once, rather than ...
1
vote
1answer
70 views

Where is Query String (URL) Filter?

Based on the answers to a previous question I want to use the Query String (URL) Filter, but I don't see it on my site. Is there something I have to enable?
1
vote
1answer
23 views

Filter content on Userlanguage in SharePoint 2013

Is there any possibility to filter content with the actual selected language of the user? I've created a document library with metadata where I have filled up the language of the content. Now it ...
0
votes
2answers
95 views

Overcome List View Threshold with OR filter?

I have a list that multiple different people of different roles have to use. There are "submitters", "targets" and "managers" (specifically called "Created By", "Assigned To" and "DM", erspectively, ...
0
votes
1answer
362 views

Filter Parameter from Visual Web Part to XSLT or DataForm Web Part

I have a scenario where from Visual Web Part I need to send filter parameter to XSLTListView or DataForm Web Part on the same page! If I use Query String then I need to Response.Redirect and that will ...
0
votes
0answers
39 views

Filter BCS Data by Users AD Group

I'd like to know if it is possible (and if so, how) to filter the BCS data results by the AD group a user belongs to. For example. User A belongs to AD group 'group1'. In the external data that ...
2
votes
2answers
689 views

Disable filtering option on the list after the webpart page has loaded loaded completly

I am filtering a list by passing query string to a custom list http://TestSite/TestSubsite/Lists/TestList/allitems.aspx?FilterField1=FirstName &FilterValue1=Apelles This does the job of ...
3
votes
0answers
222 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
0answers
9 views

In Library column header filtering and MMS Navigation not behaving as expected

I have a simple document library with two additional columns (A and B). I am using the MMS for column A to show a policy area. In column B I am using a drop down choice field to show the document ...
0
votes
1answer
70 views

Filter a List View based on data in another list

I'm looking for guidance on how to approach a problem. I have two lists, Goals and Tasks. Goals is a simple custom list with Name and People-Involved. Tasks is a task list with a lookup field to ...
0
votes
0answers
40 views

Is there a way to dynamically change the view of the a list? Basically, slicers in Sharepoint for lists?

I have a list on SharePoint 2013. It is a very long (it's basically a glossary) it has 3 columns. The term, the definition, and the category. Since I have about 300 terms, the list can get very long, ...
0
votes
1answer
171 views

“Show filter choices” link instead of actual values in a list column filter

I have created an standard list with a few simple text columns. Why can I not see the normal filter values of all columns? Instead it shows a new "Show Filter choices" link (pic 1) which when ...
0
votes
1answer
23 views

Cross referencing with Dataview webpart

Oh man I must be losing my mind but I can't for the life of me figure this out. I have a list called "Stuff" and a library called "Stuff documents". "stuff documents" has a lookup column to the title ...
0
votes
0answers
19 views

Best bet disapear when selet site refiner

I've some best bet in my sharepoint 2010 server, it works correctly but when i filter (with refinement panel site) on the site where my bet is, my best bet disapear. Do you know a way to correct ...
0
votes
1answer
23 views

Lookup list filter only future events

I have a task list that assigns tasks to specific future events. The custom task has a lookup column that is based on an events calendar. Is there any way I can cleanup this lookup list to only show ...
0
votes
1answer
30 views

How to write a view filter to show all pages created by me and have either “Pending” or “Approved” statuses

I want to achieve this , to display all pages that are assigned to me and have either (Pending or approved) statuses. But when I define the following, It will show all the pages that are rejected ...
1
vote
3answers
354 views

Filter list view with url parameter. Strange behavior in Internet Explorer (SharePoint 2013)

I have a link opening the listview AllItems.aspx with specific filter parameter in the url which works fine. But if the user tries to change the filter of the prefiltered column, e.g. by selecting ...