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

learn more… | top users | synonyms (1)

3
votes
1answer
54 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: ...
1
vote
0answers
31 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
656 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 ...
1
vote
2answers
38 views

Refine discussion list

I am using a Community site and I need to refine my discussion list. I added a column with multiple choice. I would like to add a combobox with the possibility to filter for that column. How can ...
0
votes
1answer
57 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
559 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
24 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 ...
5
votes
2answers
69 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
39 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
112 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
21 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
1k 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
47 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
31 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 _api/web/lists/getByTitle('System%...
2
votes
0answers
26 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
28 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 name="...
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
104 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
502 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 ...
1
vote
1answer
51 views

How to filter on System.DateTime using FilteredDataSourcePropertyFormat?

I'm using an SPGridView that displays search results and it works perfectly. Sorting and filtering works fine as well unless for the DateTime Column. When I'm trying to filter by Date I have the ...
0
votes
1answer
31 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
16 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
117 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 ...
1
vote
2answers
50 views

How to filter webpart for multiple values

I've added a list webpart (using UI) to a webpage and also added a Choice Filter Webpart. It appears I can only filter the list using a single value, i.e. multi-values are not supported. Is there any ...
0
votes
2answers
350 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
152 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 ...
5
votes
0answers
236 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
116 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
17 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
567 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
21 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
90 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": { "results": ...
1
vote
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
30 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 ...
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 ...
0
votes
0answers
117 views

Unable to filter list view from query string for taxonomy fields

I have created a list view using UI and I want newly created view to filter data using query string. I referred this post to change the view schema using SharePoint designer. It is working fine, ...
1
vote
0answers
37 views

unable to use content query webpart to retrieve the list content (custom template) from subsites

I am unable to retrieve the list items via content query web part from all the sub sites of a custom list created with a template. This is a SharePoint online site collection and i have placed the web ...
0
votes
0answers
31 views

Xslt list view web part filtering not working in IE

I have placed an XsltListViewWebpart on page and filtering the data using FilterField1 & FilterValue1. The web part shows me no data message if I open the page in IE but if I open the page with ...
0
votes
0answers
111 views

filter list/library by 2013 workflow status

I am looking for a way to filter a list by a share point designer 2013 workflow. I can filter fine using a 2010 workflow however 2013 workflows do not appear on the filter options (although they do ...
0
votes
0answers
31 views

Sharepoint 2013 filter (required) column values depending on previous column selection

Perhaps you can help me with an issue I have setting up an new SharePoint library: We have (among others) 2 required columns for the users before they are allowed to upload their document. The first ...
0
votes
0answers
49 views

How to set the default of a Date Filter to a calculated value?

I have a List web part that has a (hidden) date column. I've added a Date Filter web part and connected it to the list. The filter is working. Setting the default to a calculated value doesn't seem ...
0
votes
0answers
21 views

Filtering Web Part --

I am a newbie to SharePoint, working on my first assignment. I need some help to resolve this issue I am having. In Page -1 I have reference list added as a web part in it When I click on a ...
0
votes
0answers
13 views

Linked Data Source Merge Filters removed?

Using SharePoint Designer for SharePoint 2010. I have a linked data source where all the lists are being merged. This works properly. Now, I want to filter each list or the entire merged listed ...
0
votes
0answers
48 views

Filter Categories in a community (Tiles View)

We have a community site(2013) with more than 100 categories (grouped by products), we want to provide an option to the users to filter these categories by "Product", we would like to implement this ...
0
votes
1answer
65 views

Filtering a simple list data source?

I'm using SharePoint Designer for SharePoint 2010. I created a new site page. On this page, I added a simple DataView via the designer (XsltListViewWebPart) that pulls all items from a list in the ...
0
votes
0answers
495 views

Filtering items in list view using query string - FilterName & FilterMultiValue 32 values limit?

Basically what I am trying to do is to filter list view using query string parameters FilterName=ID & FilterMultiValue=1;2;3;... Let say we have list with default view. We want to filter items ...
0
votes
1answer
49 views

Dept. wise Prompted link!

I need to create a page with tiles (linked with URLs of internal Department web-apps), concern is that only the related tiles should be display to the user (HR tiles to HR dept. user and Finance Tiles ...
1
vote
2answers
52 views

What is the French equivalent of [Today]?

I'm creating a view in French where it filters on items greater than today's date. Unfortunately, I cannot find the French equivalent for [Today]. Anyone know? Thanks.
0
votes
2answers
39 views

Document Library Multiple Views

I have a document library, and the library contains multiple folders and files within each of the folders. I have a unique column called "Header" and this refers to the type of file that appears. The ...