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
145 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
37 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
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
3answers
774 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
1answer
43 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
331 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
277 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
533 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
4k 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
1answer
893 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
794 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
135 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
434 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
1k 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
685 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
1answer
289 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
45 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
3answers
408 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
28 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
203 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
190 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
915 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
60 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
643 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
414 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
1k 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
163 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
982 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
813 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
125 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
657 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, ...
1
vote
2answers
892 views

Document Library Filter

This may seem like a simple question, but I have spent hours trying to get this function to work properly. I have two data columns in a document library with a view titled "today". The idea is as ...
1
vote
1answer
982 views

Filter Sharepoint 2010 List with Duplicate Items

I have a list that is being used for document control. The list contains multiple items with the same Title as well as other columns. It also contains a manual revision column I would like to display ...
1
vote
1answer
917 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 ...
1
vote
2answers
159 views

How to connect two lists and produce customized reports

I have two lists. The first list, 'Suppliers', is a list of suppliers with the various contact information. The second is 'Ratings' this contains a lookup of the supplier name and various number ...
1
vote
1answer
451 views

Populate a Filter web part from a List item and execute

I have a Business Data Related List called Projects. It is connected to a Business Data Item, so it has the option to select an item (the two-way arrow next to an Item). From this List I need to pass ...
1
vote
1answer
373 views

How to set a value in a list based on the current filtered column value

I have edited my document set Welcome Page to include a web part of a "Notes" list. This list is filtered so that only notes pertaining to the currently viewed document set are visible. Question: ...
1
vote
2answers
613 views

Page Field Filter displaying 1;#ColumnName instead of ColumnName. Bug?

I have a Document Library with a column (we'll call it ColumnName) and a Web Parts Page with a value assigned for that column. On that page I have a list view displaying the Doc Library files and a ...
1
vote
1answer
353 views

How do i create a static text filter on a list webpart

I would like to use a constant as a text filter on a SharePoint list webpart. I can add a text filter and use it to filter the list successfully, but I don't want a control and I never want to change ...
1
vote
2answers
341 views

SP 2010 REST $filter column

I'm trying to filter a list using the REST service. The column im trying to filter is the default column "Modified". My problem is: I can get all itens created today, but not only the items created ...
1
vote
2answers
427 views

Filter Library with parameter

I am an intern at a company, so I am not completely sure about the structure of the servers etc. However, I have a library that I want to filter by the department that the currently logged on user is ...
1
vote
2answers
2k views

Sharepoint 2010: List view to always show last friday's data

I've been working on this issue forever now...Here's what I'm trying to do. I have a custom list where people add some info. I crated 2 views to view items added today and yesterday. Now I'm trying to ...
1
vote
1answer
394 views

Filter Data View with SOAP Query as Source

I am creating a printable company directory. I have a SOAP Service query that pulls everyone's data from the search service. The query returns all the results I want. I have enabled the "Sort & ...