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

learn more… | top users | synonyms

-1
votes
0answers
12 views

How to get all users filtered by role in CSOM Sharepoint 2013?

In my SP2013 environment I want to write javascript code that uses CSOM (client object model) and retrieve all users, but filtered by role. Does anyone know how to do this? I found this Get all users ...
1
vote
1answer
4k 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
1answer
547 views

Display connection information within a ITransformableFilterValues web part

I created a filter web part by extending the ITransformableFilterValues interface, similar to this page: MSDN. I want to mimic the Microsoft query string filter and display the connection information ...
0
votes
0answers
12 views

SharePoint 2013 Date Range Filter on list using FilterFields and FilterOps

I am working on a project in SharePoint 2013. Currently I am trying to implement list view filtering using OOTB QueryString parameters. I have found the following params have been working a treat ...
1
vote
1answer
27 views

Filter by “Created by” is not working

I have created a list view that filters documents on "Created by" column. Users within my organization are able to see the information correctly. However, users who are logging via external ...
0
votes
1answer
2k 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
17 views

Filter by calculated column with rest api in Sharepoint 2013?

Apparently you can't filter by calculated column with Sharepoint 2013 rest api? The calculated column in question returns a string. ...
1
vote
0answers
42 views

View with `Current User Filter` doesn't work

I have a View of a List which uses the Office value of the UserProfile to filter the items, using a UserFilter Webpart and adding the Parameterbinding it works: <WebPartPages:XsltListViewWebPart ...
0
votes
2answers
30 views

How to filter a list by hour

I am on SharePoint 2013 and do not have access to Designer, as a preface. I am trying to create a list view that filters items by whether or not they were added in the last hour. I had done this ...
5
votes
1answer
3k 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
2answers
117 views

Sharepoint 2013 CQWP - Filter by Approval Status

I'm kind of stuck in a Content by Query Webpart. (Yes, i'm aware i'm on 2013, and yes, i could use Content by Search WebPart, but this is a standard edition, so no, finally i can't use CSWP) I would ...
0
votes
1answer
36 views

Disable column header filter and sorting

I am using SP2013 on-premise. On a list view all the columns' header come with a filter+sorter function. It is not useful on some columns (e.g. photo, which show a picture and no point to sort, and ...
0
votes
1answer
18 views

how do I filter a view in SharePoint based on last year?

I need to create a view with only last year, 2014, data showing. I tried creating calculated columns for start and end date and using less than start date and greater than end date filter in the ...
0
votes
0answers
13 views

Add filters under webpart.xml properties: <property name=“”

I have a webpart coded with XML, there I retrieve data from Announcements list. It was working fine without any filters. Now I want to filter by Expires date. I have added one line of xml. But it ...
0
votes
2answers
1k 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
9 views

How do I filter my result set by user when querying a survey list?

I don't like the way SharePoint forces an error message on my users when they've already responded to a survey. My task is to check the survey first, to see if they've already responded and then ...
0
votes
1answer
22 views

2010: Query String URL Filter doesn't filter until postback

I have a Query String URL filter sending a value (ProjectID) to a task list which filters the tasks down to match the query string. On page load, however, all tasks are displayed, making it seem that ...
0
votes
1answer
34 views

How to create a display for last major version only

We are using a SP2013 site with some workflows and we need to display documents withe their last version only. Let's say we have 5 docs with minor versions (1.2, 2.6, 2.2, etc...) and we want to ...
0
votes
1answer
2k 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
1answer
34 views

How do I use REST $filter with a “Hyperlink or Picture” type column?

The $filter method works perfectly on regular text columns, but I can't figure out how to use it with a "Hyperlink or Picture" type column. For example: ...
0
votes
1answer
551 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
0answers
13 views

WebPartPage and MultipleItemView

I have a list List1 that is references 1:1 to the Sharepoint users. I need to create a page which displays the data of the record of List1 based on the current user. I know that I could create a View ...
1
vote
1answer
23 views

Configuring Connection from Sharepoint List Filter Web Part to List View Web Part

For some reason I can't get a selectable connection to pass the filter values to the list view web part. I select the web part to pass the filter values to, but then the Connection Box comes up empty ...
0
votes
0answers
9 views

use today as default filter in WebPart page

I've got a WebPart page with: 2 list view Web Parts with a date column a query string filter that looks for "meetingDay" and sends the value to the list view Web Parts So when I go to ...
0
votes
0answers
9 views

Multiple Column Lookup in SSRS expressions

Hi I am working in SSRS 2012. My dataset/table schema is as below. ID,Name,Age,Address In my report table this data set is the source. What I want to do is I want to filter my data set in ...
3
votes
1answer
936 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 ...
1
vote
1answer
750 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 ...
5
votes
3answers
3k 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
8 views

“Get Filter Value From” prepends “id;#” to the value

I have two lists that are connected to each other. Tracking Numbers: Has one Shipping address Shipping Address: Has many Tracking number On the Tracking number edit form I would like to display ...
0
votes
1answer
24 views

Manipulate Filters in Javascript

Is there any code in JavaScript which allow to manipulate filter to a library webpart?
0
votes
1answer
757 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
votes
1answer
19 views

Filter list based on week day

My list has a column of weekday: title weekday itemA 1 itemB 2 itemC 3 itemD 4 itemE 5 itemF 6 itemG 7 How can I filter a sharepoint 2013 list Item based on the day of the ...
0
votes
0answers
21 views

Consumer Field Name - no parameters provided

I am trying to to filter my chart based on start and end dates but I the configure connection webpage dialog box does not provide the field names to choose from.
1
vote
0answers
353 views

Filter a CQWP on a Lookup Column

I'm creating a custom page layout that contains a CQWP that I'd like to display documents related to the page. The document library has a lookup column that relates to the page title in the Pages ...
0
votes
3answers
77 views

Document Library Not Filtering Columns

There is a document library which has over 5000 items, it has passed its item view threshold. The view was reduced to show items that met certain requirements. This view now shows less than 1000 ...
1
vote
0answers
14 views

Limit Dates available for selection and limit enteries displayed by those dates

I am creating a small timereporting list and would like to have the user select from a list of limited dates. The dates should be all the date for beginning of the week (i.e. 05/04/2015, 05/11/2015, ...
0
votes
1answer
24 views

Filter SharePoint List differently in context of logged in user

I have a list view with a filter matching according to a people picker column called Manager is equal to [Me] so that Managers see their own records. The creation of the records are initially done ...
0
votes
1answer
15 views

Need help with setting up a filter for a view (sharepoint UI only)

I need help setting up a and/or filter and I can't seem to get it right. Its based off dates. I am looking for the following: Between (StartDate-Status1 and EndDate-Status1) OR ...
0
votes
0answers
11 views

SharePoint List Filters search options

I am using SharePoint 2007 and want to know if it is possible to search on part of a value within the specified column I link to within the list. Currently it is set up to 'search on first name' ...
1
vote
2answers
128 views

Workflow Task List - View Filtered By Assigned To = [Me] not working for SPGroups

I want to filter my Workflow 2013 Tasks list only to display the tasks assigned to the current user. Hence I went ahead and set a filter 'Assigned To' is equal to [Me] in the view. However, I am not ...
4
votes
2answers
4k 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
0answers
14 views

Display Active directory user Properties(name,mail) And filter through People picker value

I want to display AD user properties which filter through people picker value which I getting from the people picker control I show all user using this filter search.Filter = ...
0
votes
0answers
9 views

Create Hyperlink to pass filter parameters between pages to filter web parts

The setup is this: I have a web part page (my "Results" page), with a series of list web parts (i.e. different list views) on it. These web parts take filter from a SharePoint List Filter web part on ...
0
votes
1answer
22 views

Search a SharePoint 2010 List

Using out of the box functionality, I added a search web part and my list view below it on a page. Connected the two and I am able to search the list as needed. The problem is that the list already ...
0
votes
0answers
43 views

Filter view by hyperlink column

I'm using SharePoint 2013 and I have a library in which one column is of the type hyperlink. Now I have a view in which one of the columns to be displayed is the hyperlink, this one has the url and ...
1
vote
0answers
15 views

Linked webparts filter

I have a page with 2 linked webparts, actually 2 list views. (One view is simply sending a parameter to the other view). My problem is that when I use the list filter (by clicking on the view column) ...
0
votes
1answer
91 views

Dynamic filtering an XsltListViewWebPart

I want an XsltListViewWebPart filtered based on some custom metadata derived from the current user. Following Claudio Brotto’s article ...
1
vote
2answers
35 views

Save Choice Filter Selection

I have four lists on a web page that I want to be controlled by a choice filter web part. The four lists have a common column between them, so I want users to be able to select an item in the choice ...
1
vote
1answer
20 views

Need to show oldest 3 items in one webpart and the remaining items in another webpart

I have a scenario where I want to divide a list's items into 2 webpart views - one that shows only the x oldest items (people that should be seen next) and another list on the same page showing the ...
1
vote
1answer
33 views

Conditional List Filters

I'm having trouble figuring out a way to create a filter that I need for a list I've made. I need to filter a certain column based on the current user. For example, if the current user is "John ...