We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [filter]

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

Filter by
Sorted by
Tagged with
4
votes
2answers
2k views

How to limit a Data View Web Part to 1 Item Per (Most Recent)?

I have a DVWP that I need to set up a complex filter on. It WAS all set - grouped by category field, sorted by item title, then filtered on 2 other fields (year & quarter). Then I was given ...
4
votes
0answers
557 views

select multiple key filter values in metadata navigation

I just discovered metadata navigation while setting up an Asset Library to store my company's media. It's really handy, given that I had previously just been applying filters directly from the columns....
4
votes
0answers
553 views

How to filter a paged and sorted external list

I have succesfully implented an external content type with a read list method, which can sort and page through the external data. The external content type has 4 filters (two limit and two wildcard) ...
4
votes
1answer
4k 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 ...
4
votes
0answers
743 views

Query string filter on an InfoPath lookup field

I am trying to use a query string filter to filter data on an InfoPath form using this guide. The column that I'm trying to filter is a lookup field and it is not available in the list of Consumer ...
4
votes
1answer
806 views

Consumer+provider web part connections: output is asked before input

I created a simple web part that has both a consumer and a provider connection. The provided output depends on the consumed input (so this is a sort of pipeline approach). I managed to implement the ...
3
votes
2answers
482 views

SharePoint Rest API URL to filter records from list

I have list called Users. In users list, column called Age of type Number. Using Rest API I'm trying to get users whose age is between 50 to 100. I need only the URL to filter these records.
3
votes
3answers
7k views

How to get value of List Filter web part in Javascript?

I use the SharePoint List Filter web part on a page to control several Data View Web Parts. How do I read the current value of the List Filter in Javascript?
3
votes
2answers
5k 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 ...
3
votes
3answers
25k 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.
3
votes
1answer
10k views

Filtering a list with date ranges - xslt / advanced expressions on list filters possible?

I've got a Sharepoint 2010 list that I'd like to filter with date-ranges. I'm doing something like if END_DATE > [NOW - 1Week] and END_DATE < [NOW + 1Week] or PLAN_END > [NOW -1Week] and ...
3
votes
1answer
719 views

SharePoint REST filter items with multiselect field as null

I wanted to ignore items which have the multiselect field set to null. I used ne '' and ne null and none seems to work.
3
votes
2answers
3k views

Disabled Users in SharePoint 2013 - Best practices

What is the best practice for managing disabled users? Should these be imported in SharePoint? And if not, how to filter these records? SharePoint 2013, Synchronization option in User Profile Service
3
votes
1answer
2k views

Filter Hyperlink field url using SharePoint REST API

I want to filter Hyperlink filed URL using REST API in SharePoint 2013. My URL is like below is working fine https://<siteurl>/_api/Web/Lists/GetByTitle('Pages')/items?$select=NavigateURL/Url ...
3
votes
2answers
1k views

Filter a view to show only entries from a specific month

I have a SharePoint view with a lot of colums. One of the colums is "created" which is the date the entry was created. When I want to export the view for a specific month only, it's a bit tedious ...
3
votes
1answer
1k 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
3answers
19k views

Filter one list depending on selection in another list

let's say I have one list with my company's departments and one list with all employees. My list of employees has a lookup field to select the department. Now I want to have one page with a list of ...
3
votes
2answers
1k views

Show All Tasks Assigned to Me (including those assigned to Me and Multiple Users)

I have a Task List WP on my Site Page and I want it to show all Tasks Assigned to Me (my name is Jay Scott). This includes both of the following Tasks: TASK 1: Assigned to Me only, ex. 'Assigned to: ...
3
votes
1answer
63 views

Filter by URL - not parameter

I know how to use parameters in content query web parts. Is there any option to filter a list by the site URL only? Like if I am on /customers/customer1 I would like to see details for customer1. The ...
3
votes
1answer
710 views

Is Possible to make filter on calculated column??

I have Date column in list on based it i have create two calculated column month and year. Now i am trying to get data for particular month and year so I have give filter in REST query but it give ...
3
votes
1answer
145 views

Filter library by current user using url

so I know in the view editor one can add the option of filtering by [me]. My question, is is there any way to do this in the URL and not the view? I would like to keep the standard allitems.aspx, but ...
3
votes
2answers
4k views

Can I filter a SharePoint Calendar? Is such a thing possible?

It strange that for something that sounds so simple and common, it is most likely impossible. When I first approached this request I never thought I'd end up here typing out my problem ... I added a ...
3
votes
1answer
802 views

Filter Rest API AssignedToId

I've been trying to filters with rest API, but I seem to be struggeling with easy requests. So this one works without any problems http://myserver/_api/web/lists/getbytitle%28'Tickets'%29/items?$...
3
votes
2answers
2k views

SharePoint 2013 list using multiple drop down list as filters

Long time reader, first time poster... I have found many of the best solutions for my problems here, so thank you for all your hard work! I have been trying to get this problem figured out for few ...
3
votes
3answers
12k views

Retrieving files from a document library using REST with a filter on a field

I have a standard document library with one added field StudyId (string). I can't figure out how to retrieve files using a filter on that field. I retrieve files as following: http://test-site/_api/...
3
votes
1answer
96 views

Creating a view in SharePoint 2010

I have a ticketlist which has ticket_id for 2 different locations, tickd1,tickd2,tickd3,tickd4 for Dallas ticka1,ticka2,ticka3,ticka4 for Atlanta Now I am trying to create 2 views, one for ...
3
votes
1answer
43 views

Holiday System - Show all team holidays to a manager

I'm currently building an automated holiday system for the company intranet. The issue I'm having is trying to find a way of managers to view their team members holidays in a calendar list. The only ...
3
votes
2answers
114 views

SharePoint list filter web part disappears once I add it to my wiki page

I don't know why SharePoint list filter web part doesn't show on the page once I add it. I opened web part in maintenance view and it is there, but not showing on the page. I appreciate the help.
3
votes
1answer
180 views

AJAX get for this weeks birthdays

Greetings fellow sharepoint warriors. I am trying to understand the way all the filtering goes and I've stumbled upon a problem. I would like to get items from list where birthday falls in current ...
3
votes
1answer
53 views

SharePoint Filter Search

I want to provide search capabilities for my document library some what similar to as depicted in the following screenshot. But the point is I don't want the user to enter anything in the searchbox, ...
3
votes
1answer
3k views

How to create various timeline views of project tasks

Since it is not possible to relate a timeline to different views of the same task list (See this question), has anyone found another way to use SharePoint task list and timeline features to show ...
3
votes
1answer
510 views

Creating a custom Filter Webpart in SandBox? How-To?

Since a little while now I've been trying to create a custom filter webpart in Sandbox. So far, it seems that all the usual ways to create a custom filter webpart programatically ina farm solution are ...
3
votes
1answer
1k views

How do I show a view of documents for the current user's department?

My first sharepoint task ever is to create a demo document management site, i need to define a way of departmentalising documents added to the store, then when a user logs in they only see documents ...
3
votes
2answers
825 views

SharePoint Online Image library with metadata collumns

I am experiencing an issue with metadata. I have an Image Library that has around 8000 files. I had uploaded them with metadata for some custom collumns. I did create a few views filtering with that ...
3
votes
3answers
17k views

How to get specific sub sites Using Get-SPWeb object

In the code below i only want to get following 3 specific subsites using Get-SPWeb Object. which filter command is most appropriate to target only these 3 sites 1. http://myCo.root.site/sites/News/...
3
votes
1answer
183 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: ...
3
votes
1answer
222 views

Filter Webpart to match any column

I have a list of products with hundreds of entries. Each product has contact details with it as well as company information etc. I would like to be able to run a search on this list and return ...
3
votes
2answers
1k 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 ...
3
votes
1answer
341 views

Is it possible to filter a BCS list using a site's name?

I'm running SharePoint Foundation and copying a site template per project. I would like to filter the BCS list in my template using the site name. Is there a possible method?
3
votes
4answers
786 views

Web part filtering

For our web site we would like to be able to have a combo box which the end user selects a “Province/State” from the drop down menu. Depending on which “Province/State” he selects, some web parts will ...
3
votes
0answers
111 views

Construct CAML Query from ListView Filter URL-Params in SP2013

Im trying to construct a CAML query from the current Listview filter settings. I dont know in prior how many filters the user may set. My goal is to create a CAML query which has the exact same ...
3
votes
1answer
852 views

Filter sharepoint list using multi line text field

I'm trying to filter a sharepoint list using ajax api. So one of the filtered field is Multi line text field (FieldType.Note) , after performing request it throws an error telleing that the field ...
3
votes
3answers
4k views

SharePoint views - Filtering by date and time

We have a custom web-part that uses a View to filter Procurements (Tenders) by date. We are trying to filter the view using the [Today] function but from what I gathered it only uses the Date and ...
3
votes
1answer
515 views

Filter/Search specific fields in list

I have a custom list with two columns: Person Name Person Age I want to have a search/filter area where user can search by person name or age. Name search should not be exact match and must be like "...
3
votes
1answer
105 views

List view filter

Can I filter my view to show only 5000 recent added/updated out of 6000 items? My list has more than 5000 items and I want to show only 5000 recent items.
3
votes
0answers
42 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 ...
3
votes
2answers
1k views

Why doesn't FilterOp work with Inplview?

I am trying to pass a URL into a SharePoint listview with parameters for filtering. The FilterOp paramter doesn't work with inplview for me. If I pass the parameters in normal query string format (?...
3
votes
1answer
364 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 ...
3
votes
0answers
175 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 ...
3
votes
0answers
192 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 ...