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
1answer
3k views

Dynamically setting Default Value in ParameterBinding through Javascript

To make a long story short (too late), we have a dropdownlist that is populated through a list of items. We want to use this dropdownlist to filter the list in a data view web part. This works ...
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
638 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
558 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
753 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
809 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
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
514 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
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
30k 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
817 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
4k 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
1answer
2k views

How to create a view thats filter a group or person type field

I have a Person or Group field called Teachers that I created in Infopath. It can contain only one user for the current project and it's not a SharePoint Group. How I can create a view to filter the ...
3
votes
2answers
2k 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
2k 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
20k 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
3answers
14k 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
81 views

Link Document Library to Search Filter

I have a SharePoint Content site which also has a document library. The document library has columns that classify the document. I am trying to (on the homepage of the content site) add a Search ...
3
votes
2answers
2k 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
70 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
1k 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
165 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
5k 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
929 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
3k 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
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
2answers
4k views

PowerApps: How to filter a people picker combobox?

I have a combobox in a powerapps form to select a user, works good. The filtering works as text is typed in, but initially it displays the full listing of users. Is there a way to show nothing until ...
3
votes
1answer
46 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
154 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
208 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
59 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
511 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
1k 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
8k 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
3answers
18k 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
234 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
228 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
121 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
1k 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
1answer
534 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
121 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 (?...

1
2
3 4 5
17