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
2answers
349 views

How to write a caml query that filters by .pdf or folders?

How can I write a CAML query (for javascript ecma) that filters by only pdf documents or folders in sharepoint 2010? (this is for document libraries) Thanks.
1
vote
2answers
1k 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 ...
1
vote
4answers
2k views

Filtering REST call with lookup field

We have a column defined on a custom list that allows for multiple select of values from another custom list. The column on the list is call Panels. When I do a REST call against this list, I can ...
1
vote
4answers
232 views

How to filter calculated columns in the filtering menu

I would like to display my calculated columns fields in plain text in the filtering drop-down menu when I click on the column title. I don't know why SharePoint displays my calculated formula instead ...
1
vote
1answer
1k views

Multiple filters on view not working

I have a list on which I am applying the following filter (on a view) but it is not working. if((workflow == 16 && status == published) || (workflow == 2 && status == expired)) ...
1
vote
1answer
42 views

Can I enter a value string as one condition of a view's filter?

For example, could I, in one rule, filter a view based on "Show the items when column x contains a, b, or c?
1
vote
1answer
7k views

Filtering data programmatically on SPView

I would like to know how can I filter information in SharePoint list (Library of documents) programmatically. I have tried 2 ways but they don't solve my problem: Using the string ...
1
vote
2answers
150 views

Filtering Lists with A and ( B or C)

Filter = A and ( B or C ) For a sharepoint list, how does one get the above behavior? For example, the default behavior would be Filter = A and B or C Specifically, the desiresed filter is ...
1
vote
1answer
2k views

SharePoint 2010 - Add filter to a list with PowerShell

How it is possible to add a filter to a list with PowerShell? (I want to add a filter to multiple lists) Is there any tutorial, articel or example?
1
vote
2answers
49 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.
1
vote
3answers
1k 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: ...
1
vote
3answers
555 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
1answer
44 views

Wiki search options

For example I have 2 wiki pages. First page includes such keywords as AD.180, AD.159, AD.200, second page includes keywords AD.300, AD.180, AD.159. If I search for AD.300 it displays me all pages ...
1
vote
1answer
357 views

Multiple filters with query string

Imagine this situation: a SharePoint 2010 teamsite 2 lists 1 query string filter webpart to connected to the first list the 1st list is connected to the 2nd to filter the 2nd When I click an item ...
1
vote
1answer
330 views

How do I set FilterOperator1 in the URL?

I know I can filter a SharePoint list by adding ?FilterField1=fieldname&FilterValue1=value to the URL. Microsoft's documentation also lists a property FilterOperator1 that you can use if you want ...
1
vote
2answers
2k views

XSLT filter for Yes/No Column/Field in SharePoint Custom List for SharePoint Designer DataView WebPart

I'm trying this with no luck: [@ActiveStatus='Yes'] also tried 1, '1', 'True' .. get no rows back.. If I remove the filter I get back all rows. full line in code view looks like this: ...
1
vote
1answer
547 views

Autocomplete filter using Sharepoint PerformancePoint Dashboard Designer

I am using Sharepoint 2010 with PerformancePoint Dashboard Designer. I am creating a dashboard that has a filter at the top of the page. The filter contains a very long list of items and I was wonder ...
1
vote
1answer
5k views

What is correct syntax for filtering a list on field values?

Salvete! I want to filter a list like this. Now, [othercolumn] is supposed to be the value of the field in the X-Field column. I want to see if the X-field column contains the text given in the ...
1
vote
2answers
1k views

Custom Search Page Filter Results

I have created a custom search page with a core search web part. It builds a query string in URL to populate the search results. k=[keyword] is the first, then to narrow the search to specific ...
1
vote
2answers
3k views

How to filter column in chart web part?

I have a list with 3 columns, Month, volvo, benz. I have created a chart which contains 2 series, volvo and benz. It shows 2 series based on month, for example for jan, it shows value volvo & benz ...
1
vote
1answer
2k views

SharePoint - Showing folders in a filtered view

I have a library with a few folders in it, and the files in the folder have a "Status" property and an "Assigned To" field. I want to make a view with the following logic: If (Content Type == ...
1
vote
1answer
2k views

Filter Multiple connections List (no-code solution)

I have a mission to create a filter for any field of my list, there are many. The connection is just made in the first filter, I cannot connect more than once... I've searched for code which would ...
1
vote
3answers
13k views

How to apply 2 different conditions in the filter of list?

I have two different conditions based on which I need to apply filter on the list data. The conditions are based on the user role and status column. I have applied the filter condition as : ...
1
vote
1answer
920 views

How to format the spgridview filter data?

I have a SPGridView where I am binding a calculation field. I am dynamically binding data to sp grid view in a web part. The filter value is displaying like String;#filterexp1, String;#filterexp3, ...
1
vote
1answer
827 views

Filter by metadata through connection to another item

I was wondering if it is possible to filter a list item based on metadata values from another list item. I tested it locally but it didn't seem to work althougth another post here said it should work ...
1
vote
1answer
136 views

Best approach to implementing a forced filter on a site?

I'm relatively new to SharePoint development so please excuse the question if it is an obvious one. Environment I have a site hierarchy that looks like this Client Dashboard Client sites (one or ...
1
vote
1answer
437 views

Filtering for recurring events happening [Today]

Is this possible? Ryan Wheeler says its not here. Tim says it is if your view is of type "Standard View, with expanded recurring events" here. I haven't been able to get Tim's suggestion to work. ...
1
vote
2answers
2k views

Sharepoint View Filter (how to check for nulls in Scheduling Start/End Date)

I am trying to use the built in sharepoint U.I to setup a filter for Scheduling Start Date & Scheduling End Date. However I noticed that if you setup something with a "Scheduling Start Date" as ...
1
vote
1answer
2k views

Multiple filters in ECT External Item Picker in SharePoint 2010 BCS?

I am using SharePoint 2010 BCS to connect to a SQL Server database table and created an External Content Type (ECT). In this ECT you can specify a filter and I have done that, and I mapped the ECT to ...
1
vote
1answer
691 views

How do I use a javascript variable in the Filter Criteria for a DVWP?

I am converting some numbers using Javascript and need to filter a list using these conversions. I cannot do the conversions within SharePoint itself, so I had to use Designer and some Javascript. I ...
1
vote
3answers
36 views

Need to filter a list with 10+ criteria

Need to create a list filter with over 10 criteria. Research tells me that it can be done with a Data View web part but I have not found any instructions on how this is done.
1
vote
1answer
27 views

Multiple columns $filter in SP designer 2013 http web service call

How can I filter on multiple columns when making a web service call in a SP 2013 designer workflow? For example if this is the url for the service call then how is the $filter part different from what ...
1
vote
1answer
25 views

KeywordQuery filter by Start and End dates using Today

I have a KeywordQuery that I need to filter so the current date is between the Start Date and End Date. Today >= "Start Date" && Today < "End Date"
1
vote
1answer
30 views

How to implement user based views

I would like to have a team site that changes based on the user that is logged in. The team site is supposed to be a landing page for everyone in the company to start their day. How can I set it up ...
1
vote
1answer
21 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 ...
1
vote
1answer
453 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 ...
1
vote
1answer
46 views

Jquery datatable [duplicate]

I have a custom list with Employee Name, Approval Status, Created Date columns in it.I am using SharePoint 2010 version. I want to display the list items depending on one of the column "Approval ...
1
vote
1answer
32 views

Order of choices in filter drop-down

In a list, at the filter drop-down section, choices are in ascending order: Is it possible to display the choices in descending order? (It would be more comfortable because users usually choose the ...
1
vote
1answer
233 views

web api query with $filter return HRESULT : 0x80131904

I try to filter items using SP2013 web api such this request : _api/web/lists/getbytitle('Activity')/items?$filter=Mylookupfield eq 'SomeValue'. All works fine in my DEV machine but in the customer ...
1
vote
1answer
385 views

Filter contact list by current month

I have a list of employees with a birthday date/time field in the format of mm/dd/yyyy. I want to create a filter that will show me employees that are having a birthday in the current month. How ...
1
vote
1answer
1k views

Where is Query String (URL) Filter?

Based on the answers to a previous question I want to use the Query String (URL) Filter, but I don't see it on my site. Is there something I have to enable?
1
vote
1answer
70 views

Filter content on Userlanguage in SharePoint 2013

Is there any possibility to filter content with the actual selected language of the user? I've created a document library with metadata where I have filled up the language of the content. Now it ...
1
vote
2answers
763 views

How to use an index with list view threshold

I have a list with 20,000 records that I have been trying to deal with. Threshold is at the default 5k. I was under the impression that if I index a column, filter on it, and my results are under 5k, ...
1
vote
1answer
493 views

Hide forms in SharePoint list where checkbox = checked

Ok. So the problem I have is: I have a SharePoint online form library which shows a list of warranty claims, the warranty claim form has a "Claim completed:" checkbox - and what I want to happen is ...
1
vote
1answer
2k views

REST API filter multi person/ group column by null

I have a multi person/ group column. I need to apply rest api filter on this column. I can filter it by values. eg: _api/Web/Lists/getbytitle('testList')/items?$filter=(Access/Id+eq+21) But when I ...
1
vote
1answer
174 views

Filter Sharepoint 2013

I have a customer who asked a very difficult requirement and do not know if possible. It uses excel but all migrated to sharepoint, and there is a filter in excel there is a text field to write and ...
1
vote
1answer
1k views

Displaying Calculated Column hyperlinks as text in filter drop downs

I have a list which has employee IDs as a field. I then have a calculated column which takes this field and uses it to link to our company-wide employee directory. This means I can hide the employee ...
1
vote
2answers
919 views

Sort and Filter Rich Text

i have a sharepoint list with a few rich text columns but in the view the headlines of these doesnt have the button to sort or filter them like all other non rich text columns have. is there a way to ...
1
vote
1answer
156 views

Categories Dropdown Box (edititem.aspx)

I would like users to be able to select a pre-determined category from a dorpdown list rather than manually typing in their own category. The image below shows the current 'New Item' screen in ...
1
vote
1answer
789 views

Filter file types from list to NOT show certain file types

I have a document library list. Lots files, and a handful of file types. I know how to force a filter via the URL. Saw docx file. But right now, I have a need to show all files except docx, pptx, ...