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
0answers
7 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
15 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
829 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
15 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
674 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
557 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
39 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
401 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
567 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
648 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
286 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
44 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
25 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
29 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
914 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
5k 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
489 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
20 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
60 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
265 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
74 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
73 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
43 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 ...
0
votes
0answers
24 views

SharePoint Discussion Board Approval - Show All Unapproved Posts

I'm trying to create a discussion board view which shows all unapproved posts, whether they're a discussion topic or a post within a discussion. Is there any way to create this view? Thank you in ...
5
votes
1answer
5k views

Can I Filter a List/Data View using Contains instead of equals in SP2010?

I have a page where I am using a Text Filter to filter a long (15K) list of clients in a Business Data List web part. The filter works fine for All and for an entered name, so long as the full name is ...
1
vote
0answers
1k 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 ...