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

learn more… | top users | synonyms

0
votes
1answer
172 views

Filtering a REST call with a View

I have a list in SharePoint I want to make a REST call to access it. I need to filter this list by an Alert Yes/No field. The field is called Alert and I try to filter it on "true" but the results ...
0
votes
1answer
67 views

Filtering Custom List Items

I created a custom list then I created a webpart for custom list. I edit settings of the webpart. I created a new filter for this list. I clicked the "Edit Page" then I selected webpart. I edited the ...
1
vote
1answer
2k views

Getting document name using REST (not title) while filtering document library

I am trying to filter through a list and return metadata of the documents in that filter. How do I return the name of a document from a document library using REST while being able to filter the ...
0
votes
3answers
1k views

Filtering Look up Columns with Javascript

I'm trying to find a way to dynamically filter a look up column on the new and edit forms in SharePoint 2013. I want to be able to get a value from the URL and use that to filter the look up ...
0
votes
1answer
95 views

Filter SharePoint lists by a Person or People Picker

How can I create a web part page, where the search web part is a "peoplepicker" like control which then filters 3 SharePoint lists below it on the "CreatedBy" column. Scenario: Find all entries made ...
-1
votes
1answer
41 views

How to filter values in a doc library

I have a doc library with let say 200 documents and two category so if i in the first category that is called Doc category i choose Devices then i want in the next column that is called Category type ...
1
vote
3answers
566 views

Remember filter value using jquery and cookies

I am looking for a solution for the following problem: I have a large list that is related to a second list. The two list web parts are on one page, when you select an item in the first list, the ...
7
votes
4answers
12k views

REST with $filter for List Items in Sharepoint 2013

Sharepoint 2013, REST API, native C++ application: I want to get all Folder items from the list. Try /_api/Web/Lists(guid'GUID')/Items?$filter=FileSystemObjectType+eq+1 and get HTTP 400 Bed ...
0
votes
0answers
117 views

Async Refresh LVWP on load with HTML Form Param

I have a List View WebPart that I need to asynchronously take a parameter from an HTML form WebPart and update the LVWP. I have some odd behavior happen when I attempt this. I have Async Load, Update, ...
0
votes
1answer
58 views

Filtering a SharePoint list

I have 2 lists and 2 pages. The first one lets call it System contains 2 columns, Name and Action. The Action column is a URL that redirects to the second page. The second one lets call it ...
0
votes
1answer
99 views

SP13: Filtering Default Calendar Start and End Time

I am working off of a list from a calendar. Within the calendar list I am to filter all event columns except Start Time and End Time field. See image below for a visual example. Does anyone know ...
0
votes
0answers
31 views

Filter WebCollection using a List of Urls

I have a List that holds the URLs of the Subsites I want to retrieve. I need to use that as a filter (optimize the query) so when I query the SharePoint it only returns the webs I want to work with. ...
1
vote
0answers
44 views

SP 2013 : Specific item in a lookup field cannot be filtered

the list A has a lookup field connected to list B in field Title. One of the items in list B has title "CCAA". On A/ViewAllitems, i can filter in column lookup:listB:Title for every item, except for ...
1
vote
1answer
70 views

SharePoint list to show all items, with the exception of closed/completed items that are older than a specific amount of time (e.g. 7 days)?

I am familiar with filtering the list to only show current items (not closed/completed), but is there a way to show all items except any that have been placed in closed/completed status more than 7 ...
1
vote
1answer
101 views

Sending user's input from JavaScript into date filter webpart

I want to do date filter for one field in my external list using calendar in order to hep user input date value. Since drop-down calendar in date filter web part doesn't work (i don't know why, when ...
1
vote
1answer
57 views

How do I filter a free text column in a MOSS 2007 list?

I want to add a filter to a list I have created. When I use a form filter I don't get the option of filtering by any of the columns that are multiline text columns. Basically I have an A-Z. The first ...
1
vote
1answer
924 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?
0
votes
2answers
43 views

Alerts on Document Library filter by user

I copy folders and documents to a document library by code through a feature. I am trying to prevent alerts from being fired when the document library is populated. I tried setting the Filter ...
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 ...
0
votes
1answer
119 views

Due in next 90 days filter in a data view

I'm making data views and for a couple of them I want to filter to show any items that are due within the next x amount of days. My immediate thought was to filter by Current Date + 90. I've done ...
0
votes
0answers
76 views

Filter BCS Data by Users AD Group

I'd like to know if it is possible (and if so, how) to filter the BCS data results by the AD group a user belongs to. For example. User A belongs to AD group 'group1'. In the external data that ...
0
votes
1answer
689 views

Filter a List View based on data in another list

I'm looking for guidance on how to approach a problem. I have two lists, Goals and Tasks. Goals is a simple custom list with Name and People-Involved. Tasks is a task list with a lookup field to ...
2
votes
1answer
2k views

“Show filter choices” link instead of actual values in a list column filter

I have created an standard list with a few simple text columns. Why can I not see the normal filter values of all columns? Instead it shows a new "Show Filter choices" link (pic 1) which when ...
0
votes
1answer
38 views

Cross referencing with Dataview webpart

Oh man I must be losing my mind but I can't for the life of me figure this out. I have a list called "Stuff" and a library called "Stuff documents". "stuff documents" has a lookup column to the title ...
0
votes
2answers
177 views

Overcome List View Threshold with OR filter?

I have a list that multiple different people of different roles have to use. There are "submitters", "targets" and "managers" (specifically called "Created By", "Assigned To" and "DM", erspectively, ...
0
votes
1answer
40 views

How to write a view filter to show all pages created by me and have either “Pending” or “Approved” statuses

I want to achieve this , to display all pages that are assigned to me and have either (Pending or approved) statuses. But when I define the following, It will show all the pages that are rejected ...
0
votes
1answer
63 views

Lookup list filter only future events

I have a task list that assigns tasks to specific future events. The custom task has a lookup column that is based on an events calendar. Is there any way I can cleanup this lookup list to only show ...
0
votes
0answers
29 views

Linking Lists or something similar

I relatively new to SharePoint so hopefully I can explain what I am trying to do (with little SPD skills). List A provides users with all the courses available to them (with hyperlink to LMS). So it ...
2
votes
3answers
3k views

Filter list view with url parameter. Strange behavior in Internet Explorer (SharePoint 2013)

I have a link opening the listview AllItems.aspx with specific filter parameter in the url which works fine. But if the user tries to change the filter of the prefiltered column, e.g. by selecting ...
2
votes
1answer
570 views

how to add a view filter to check if the login user is inside a group,same as for [Me]

I have added the following filter inside a view:- Which will filter if the “Assigned To” field equals the logn user. But now if the “assigned to” field contain a group which I belong to, then the ...
0
votes
0answers
16 views

List - Filter at beginning

All, I have a Person list with Status column (Active/Inactive). Is there a way when user clicks on Person list, it just displays Active Person only? Can we make the Filer of Status Column chooses ...
1
vote
2answers
645 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
0answers
204 views

When I click on the library setting “Metadata navigation settings” or “Per-location view settings ” got the error: Object reference not set to an

I am using sp2010. I have a document library with documents. I have 3 managed metadata columns in this library. When I go to the library settings and click on the option "Metadata navigation settings" ...
1
vote
0answers
67 views

Filtering list based on user preferences

On SharePoint I have 3 lists created. The 1st list contains 2 columns: user's unique ID and user's name. The 2nd list contains 2 columns: user's ID and a multiple choice of preferences of ...
0
votes
0answers
91 views

using SpListFilterWebPart in sharepoint 2013

I want to use SpListFilterWebPart in allitems.aspx view in my share point 2013 and I do it with share point designer 2013 but I can't see SpListFilterWebPart in my page view Why it happened?
0
votes
1answer
259 views

Filter list based on dropdown selection - SP 2013

I would like to implement a list filter feature. I need to filter the list based on 3 drop down field values. The values of the drop down are populated from same list (that I want to filter). I am ...
0
votes
0answers
524 views

How to get “SQL Server Analysis Services Filter” to work?

In an SharePoint 2013 BI Portal I am using two Report Services Report Web Parts with a common data source (.rsds file). Reports work fine and I want to filter the data of one report (or both reports ...
0
votes
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 ...
1
vote
0answers
286 views

External List filtering using Web Part Connections (send filter value to)

I have an external list (WCF) and I would like to have another web part that searches 1 or more columns on the list (e.g. Product Title, and Product Status etc) I'm using SP2013, guess it would be ...
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
0answers
235 views

Export filtered list to Excel in SharePoint 2013

I have a question about Excel export. I saw a bunch of negative answers on that, but not recent ones. In SharePoint 2013, is there still no out of the box solution to export a filtered list in Excel ? ...
1
vote
1answer
418 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 ...
7
votes
2answers
4k views

REST API OData Filter on Boolean not Working

When I perform a REST query to the following URL: _api/web/lists/getbytitle('BtProjects')/items?$filter=Active eq true I receive only the one item that has this field marked as false. I get the same ...
0
votes
1answer
387 views

Most Recent Documents / Items with Sort and Filter functionality

I want to have a Webpart that displays the Most Recent Documents for the entire site collection. Main concern with this webpart is that there is a requirement for Filter and Sort functionality for ...
1
vote
0answers
69 views

Sharepoint 2010 metadata filters- Driving from a link or script

The "old style" list filters in Sharepoint List views (e.g. when the user clicks on a column to filter or sort on column values) use an http GET, so the filter paramaters are transmitted in the page ...
0
votes
2answers
220 views

Autopopulated list column with values from another column?

Please let me know if there is an easier way to do this.. I am attempting to perform an "OR" filter. I need to able to search a list by either the Title column or the Description column. I'm using ...
2
votes
1answer
47 views

Filtering a grouped list via the URL - Rows excluded from the filter showing if group contains filtered rows

I am attempting to filter a list that is grouped by a field using parameters in the URL. My url is ?FilterName=Status&FilterMultiValue=Approved;Review As far as I know, this should return the ...
0
votes
1answer
383 views

SPGridView - when sorting AFTER filtering, column looses it's filtered state (filter not removable) How to solve this?

I've got a SPGridView in a webpart that has sorting, filtering, paging and grouping configured. Most of it works fine so far, but it seems like I can't get around this problem: If I filter the ...
1
vote
0answers
77 views

How to filter listview using webpart?

We have a list view webpart on a page. I want to create a textbox webpart and pass data into the list view webpart and filter it based on this data. Is there OOTB method? Or do I develop a VS ...
0
votes
1answer
151 views

How can I build some search criteria with 9 fields

I am using SharePoint 2010. I have created a document library. In this document library I am using some custom contententtype with 9 fields. I would like to make some search page where it is possible ...