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
1answer
421 views

Filter Data View Webpart based on results of javascript query

I'm trying to dynamically filter the records that a Data View WebPart displays based on the return value of a javascript query. I would like some advice as to how I should do this or if it's even ...
0
votes
1answer
249 views

CAML Query filter by month

I would like to use CAML Query to select records between a certain period (a particular month) and which where made by a certain user. Here's what it look like but it doesn't work ...
0
votes
0answers
53 views

When creating a 'Current User' filter view, “The connection type ”send filter values to“ is not compatible with any other web parts on this page”

I have a custom list, which contains information about Active Directory users such as Description, Use Name, Group Owner, etc... I need to make it so that the only items seen by any user logged in, ...
0
votes
1answer
62 views

View filter settings: how to implement [TODAY] - 6 months

I am building a SharePoint 2013 portal. I have a custom list. On this list I try to modify the default view. I would like to change the filter settings. I would like to show only the items between ...
0
votes
1answer
532 views

date filter of today in rest api

I have a caml query filter for one of my date-time field. <Leq> <FieldRef Name ='StartDate1' /> <Value Type ='DateTime'> <Today /> </Value> </Leq> Is ...
0
votes
1answer
52 views

Imported Excel Spreadsheet not Filtering Column

I am uploading an excel template to the SharePoint site. I have 8 different metrics and want to add a filter to a specific column.SharePoint automatically adds the filter option to certain columns, ...
0
votes
0answers
119 views

Issue while filtering library view from query string

I have a picture library with 4 different views. I provisioned pages for each view and placed the view using module like below: <Elements xmlns="http://schemas.microsoft.com/sharepoint/"> ...
3
votes
2answers
486 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, ...
1
vote
1answer
435 views

REST API filter multi person/ group column by null

I have a multi person/ group column. I need to apply rest api filter on this column. I can filter it by values. eg: _api/Web/Lists/getbytitle('testList')/items?$filter=(Access/Id+eq+21) But when I ...
0
votes
0answers
39 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
103 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
2answers
1k views

How to add programmatically Sharepoint List Filter Wep Part?

I try to add Sharepoint List Filter Web Part to page. I'm not sure if it is Microsoft.SharePoint.Portal.WebControls.SpListFilterWebPart. How to add it to the page and configure? Update ...
0
votes
0answers
58 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
1answer
35 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
16 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
281 views

SharePoint 2013 Online CQWP, using design manager can't filter on a managed metadata column

I reviewed a lot of articles and couldn't find anyone talking this issue. My issue is when I use Design manager to create a CQWP snippet, I always get error message when try to filter against a Page ...
0
votes
1answer
169 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 ...
1
vote
1answer
64 views

Filter Sharepoint 2013

I have a customer who asked a very difficult requirement and do not know if possible. It uses excel but all migrated to sharepoint, and there is a filter in excel there is a text field to write and ...
0
votes
1answer
94 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
2answers
403 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
0answers
144 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
10 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
183 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
54 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" ...
1
vote
1answer
296 views

Displaying Calculated Column hyperlinks as text in filter drop downs

I have a list which has employee IDs as a field. I then have a calculated column which takes this field and uses it to link to our company-wide employee directory. This means I can hide the employee ...
2
votes
0answers
111 views

Filter.aspx and GetDistinctValues

We found an issue, that filters on columns are stop working. Error message is: Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the ...
0
votes
0answers
149 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 ...
1
vote
1answer
61 views

Filter XSLT ListView with metadats as tags

My goals A documents library has a Metadata column. In a webpart page, user selects (through select2) several metadatas as tags. the tag(s) (one or many) are sent to a XSLT ListView XSLT ...
0
votes
0answers
80 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
23 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 ...
1
vote
2answers
200 views

Sort and Filter Rich Text

i have a sharepoint list with a few rich text columns but in the view the headlines of these doesnt have the button to sort or filter them like all other non rich text columns have. is there a way to ...
1
vote
0answers
32 views

Meta data navigation filter on custom page?

I have a public facing website were i want our customers to be able to browse all our support documents using the Meta data navigation filter, but i dont want them to access the real document page. Is ...
1
vote
0answers
33 views

Documents inside a folder not showing when a filter is applied in query string?

I create a webpart to show the Document List on a certain page, and then I applied a filter on a column content to show only certain documents. But in that way the folder structure is lost and all ...
1
vote
1answer
44 views

Categories Dropdown Box (edititem.aspx)

I would like users to be able to select a pre-determined category from a dorpdown list rather than manually typing in their own category. The image below shows the current 'New Item' screen in ...
1
vote
0answers
62 views

Date range filter without SPD or Infopath

I am having a very difficult time trying to figure out how to create a page in SP2010 Enterprise that displays list items based on a user selected date range and status field is "approved" . ...
1
vote
0answers
93 views

Losing Filter When Paging Back From Second Page

I have a list view of a task list with filters creating subsets of tasks (Archived, Constructing, Defect, Stabilizing, etc.). The default view has a limit that will return 100 items at a time when ...
0
votes
3answers
986 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 ...
1
vote
0answers
172 views

Multiple filter value webpart connection problem

We currently try to connect a custom webpart with a list view webpart. The aim is to send multiple filter values to the list view. The problem we have is that the list view does only use the FIRST ...
1
vote
0answers
21 views

Create Connection beetween TextFilter and List

I have created a text filter webpart on my page and a list webpart app on the same page. If I edit the filter webpart it says that the filter is not connected and I should open the webpart editing ...
0
votes
1answer
107 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 ...
1
vote
2answers
1k views

Checked null with dateTime in REST API SharePoint

I want to get all article pages which Article Date is not null. so I have try to do by this way. var ArticlePageContentTypeID = ...
0
votes
1answer
84 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
91 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
126 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
19 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
46 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
244 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 ...
3
votes
0answers
113 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 ...
4
votes
1answer
1k views

List Filter Webpart not loading default value from custom filter provider

I have a request from a client to filter the data in a list view webpart based off of some user controlled custom settings for our sharepoint applilcation. These user settings are stored in a ...
1
vote
2answers
3k views

Trying to open a SharePoint List item in Modal Dialog in Sharepoint 2013 Office 365 (online)

Sorry for the long post. This has been killing me. I had this script working perfectly fine in SharePoint 2010 (online) and basically i have a source custom list (list A) with a hyperlink column and a ...