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
9 views

Combine JSLink of UserContextFilterWebPart and a XsltListViewWebPart

I have a WebPartPage which includes a XsltListViewWebPart and a UserContextFilterWebPart. In order to filter the results by the user office and 'connect' the two webparts, I added the parameter ...
1
vote
1answer
11 views

SharePoint Online - Custom List - Permission on Based on Department Column

I have a custom list with 200 records/items and there is a column (lookup) with department names (about 20 department). I want to give access to number of items based on the department. A similar ...
0
votes
3answers
2k 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. ...
2
votes
0answers
13 views

no items returned in a view with a filter on a calculated column

I'm having a strange issue and Google isn't helping me much in figuring out why. I have a custom list with 3 fields: Title Year calculated column =left([title], 4) single line of text Month ...
0
votes
1answer
23 views

How to apply a Date Filter on a list with JS

I have a Date Filter webpart connected to a List on page. I am setting the default value of the list with JQuery (it sets that value to the next Wednesday). Here's a jfiddle showing how we are ...
1
vote
1answer
567 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
3answers
878 views

Filter current month in list

I have single text for Month. I want to create View with filter with Month. Example :Month is equal to the current month formula is =MONTH([Today]) But it is not working.
1
vote
1answer
23 views

Disallow Manual Filtering

I'm using SharePoint 2010. I have a webpart page with a Choice Filter webpart and a list webpart connected to the filter. Everything is setup and functioning correctly. But... If the user manually ...
0
votes
0answers
17 views

Using Filters on a Data View web part from a SOAP Query

I have a SOAP query that pulled in information from a list that I want to create a Data View Web Part for. When I enabled the "Sort & Filter on Headers" option in SP designer I noticed an issue. ...
0
votes
1answer
688 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 ...
1
vote
1answer
1k 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 ...
1
vote
3answers
564 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 ...
3
votes
1answer
40 views

Filtering a large list by Month/Year

I've got a large list (85-100k items) in SP2013 that the user wants to filter by month and year (each month of data is 2,500-4,000K items), preferably selecting from drop downs. (Clarification: ...
2
votes
1answer
1k 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
0answers
29 views

SP2010 - How to stop a Jscript filtering folders

I'm on SP2010, managed by my company so unfortunately no access to server and can't add additional web parts. I previously had the need to build an A to Z filter in a library. I have used a Jscript ...
1
vote
3answers
414 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
2k views

Filter list in a WebPart by Contains not Equals (adding a wildcard)

If I need to "search" list data using a wildcard, I have to modify the XSL code. A step-by-step instruction for doing it in SP2007 has been provided at Can I Filter a List/Data View using Contains ...
1
vote
1answer
571 views

What is this URL list filter parameter?

I have a I am trying to build but I need to know what to populate in one of the parameters... For Example... ...
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
21 views

How to display My Events calendar?

I have a calendar on SharePoint page where several people can add meetings and add attendees between them. No problem to show a calendar with a view for all the meetings. However, I need everyone to ...
1
vote
1answer
651 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 ...
7
votes
2answers
5k 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 ...
1
vote
1answer
294 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 ...
2
votes
0answers
15 views

Filter web part list from URL parameter

I want to have a site template, that has a central web part list on it (I managed to make this, using SharePoint Designer. Added a Data-View) which is filtered by some data from the URL, or from a ...
4
votes
2answers
46 views

List View Threshold questions

I've done tons of reading on the list view threshold and ways to work around it but I haven't been able to answer a couple questions or ultimately find a good way to deal with it in my situation. ...
1
vote
0answers
26 views

Getting too many groups when sorting after grouping on spgridview?

When applying a sort on my spgridview after grouping, the sort does works but the groups are splited in many others labeled identically. For instance, if I have: group 1 4 2 group 2 3 group 3 ...
0
votes
1answer
30 views

SharePoint 2013 Calendar Time Filter

I am trying to create a view which only shows the event that are current. I know there is 'current event' view available but it doesn't filter based on the 'time' so if an event finished at 5pm and ...
0
votes
0answers
18 views

Selecting a lookup filter causes all lookup information to dissapear (Recent SP '13 Upgrade)

I have a list of project documents that I'm using lookup fields to tag information about the document. When I want to look at just one project, eg Varian Implementation," I select that column and ...
1
vote
1answer
919 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 ...
0
votes
1answer
35 views

Filter list without using SPD

I'm trying to filter a list, something like the OOTB WP, but more flexible. The problem with the webpart is that the user has to input the exact contents of the item he wants to find. I would like the ...
0
votes
0answers
19 views

How to get data from level 2 lookup lists by REST API

I want to get Users (UserLookup) where SbuId equal something and RoleLookupId equal something Below is code is to select those fields without $filter, the code ...
2
votes
1answer
5k 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 ...
2
votes
0answers
17 views

SharePoint 2010, filter Document Set in URL

I'm trying to filter a document set in SharePoint 2010. For example, the URL to the main document library is #1) http://uat/sites/dps/doc/Forms/folders.aspx I would access a document set like this ...
0
votes
0answers
18 views

Using CQWP retrieve 1 most recent Item from list?

i have created Announcements CQWP. in my CQWP ,displaying item whose Expire date is greater or equal to Today using Filter. i have created Template in ItemStyle.xsl file <xsl:template ...
5
votes
3answers
6k 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
42 views

How to Match Current User's Email Against Text Field

In my list there is a column for email addresses and one for usernames. The email addresses are added through a workflow and are not necessarily the same as the ones stored in the user profiles. I ...
1
vote
0answers
490 views

How do I change the date filter format in the Data View Web Part toolbar?

I have added a toolbar to the DVWP and enabled the Filter option. When I click on the filter, the Due Date field displays choices as Saturday, September 11, 2010. Within the DVWP I have the format set ...
0
votes
1answer
21 views

Apply a filter from a Date Filter web part that was set with JS/JQuery

I have a Date Filter web part that is connected to a list. I can set the content of the filter with jQuery, but how can I get the filter to apply itself when I set the value this way? Normally you ...
0
votes
0answers
12 views

Connect an OOB DisplayForm WebPart to a DVWP on a lookup field

When trying to connect an OOB WebPart to a DVWP and send the value of a lookup field it sends the value like "ID;#Title". The problem is I cannot use this as a filter in the SelectCommand to filter on ...
3
votes
1answer
62 views

Remove filter control in column using Client-Side-Rendering

Background: I have a listview 1 and I'm using CSR for set specific rows with Hyperlinks and hide only a column (called Id with InternalName Id0) in the OnPreRender > Templates. Here is the code ...
0
votes
2answers
270 views

How do I format SharePoint Rest API Results?

How do I get my SharePoint Rest API Results to return like so: Title : FDA Project RioBravo Module: Primary Training Roles : Project Manager, Lead Agent versus the way this returns them like so: ...
3
votes
1answer
56 views

What are All Possible Variables for a List View Filter?

In List Settings for a list you have the option to filter the list; there are variables such as [Me] and [Today]. Are there any others? What are they? (I've searched the world over for such a ...
3
votes
0answers
76 views

SharePoint 2013 REST expand and filter issue

I've been using REST for a lot of tasks, and with the recently added $batch endpoint, it's more fun than ever. There is one thing bugging me though, and I'd like to share it with you, perhaps someone ...
1
vote
2answers
105 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 ...
1
vote
0answers
15 views

Dynamically create metadata terms

Use case: SP List synced to Access database. Database gets data from an external app and updates list dynamically. The value in one field gets added to metadata term set. Users can search/filter the ...
0
votes
2answers
1k views

Filter form for a list

I have a Sharepoint 2007 site and want to create a list that users can filter dynamically using a form or something similar. The use case is as follows: A user is shown a list with any number of ...
2
votes
1answer
85 views

Rest API - $filter multiple values

Assuming there is a list of Students each with a zip-code, how can I get records for multiple (but not all) zip-codes. When using $filter how do specify multiple values? Here's what I have so far: ...
0
votes
0answers
12 views

Create Filter for Recycled Bin and Managed Files Which Have No Checked In Version

I wanted to create a filter on both the Recycled Bin and the view inside Manage files which have no checked in version located under Library Settings. In short, I want to have the capability to ...
0
votes
1answer
45 views

Filtering Data on the results array Expanding a deffered uri

http://myserver/_vti_bin/ListData.svc/abcList?$select=ab/Title&$expand=ab This is my request. I am getting expanded results of ab in an "results" array Like this : "ab": { ...
0
votes
0answers
2k views

View Month and Year of Group calendar

I have setup a group calendar using this article http://absolute-sharepoint.com/2014/06/create-color-coded-group-calendar-sharepoint-2013-step-step.html Now I see all the users in week view with all ...