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
69 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
31 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
4k 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
732 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
17 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
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
0answers
234 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
69 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
113 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
315 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
580 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
310 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
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
0answers
259 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
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 ...
8
votes
2answers
6k 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
435 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
71 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
290 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
53 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
450 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
81 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
155 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 ...
0
votes
1answer
179 views

Sharepoint filtered drop down list depending on group

I want to filter a drop down list within a list, depending on which group the user is bound to. Let's say that one group is called "green". The drop down list will originally have all different types ...
0
votes
0answers
2k views

SharePoint 2013 - How to disable Filter and Sort item on view?

Is there any option to turn off or turn on "Filter" and "Sort" item on view of Share point 2013? I update Field properties: Filterable = false; Sortable = false It OK, but all Views of list is ...
1
vote
0answers
241 views

Creating a survey with a question being lookup column with filtering

So I need to create a survey on a monthly basis with just one question. Possible answers should be the values from a lookup column, but limited only to those from the previous (calendar) month. Is ...
0
votes
0answers
39 views

List Item Filtering for Adminsitrators

I have a list that I'm querying using RESTful uris like so: http://site/_api/lists/getByTitle('Links')/items Each item in the list has individual permissions applied to it (both users, and groups) ...
0
votes
0answers
64 views

Sharepoint 2013: can a page automatically filter content based on credentials?

Is there a way for Sharepoint 2013 to display only certain data on a page based on the credentials of the person logged in? To clarify: My project Director wants to visit a page and automatically ...
0
votes
2answers
57 views

How do I get a lookup column to filter in 2013?

I have data in page view that places the information for "project" in a lookup column. When I try to filter this column I get the error "this column cannot be filtered." How to I get this column to ...
1
vote
1answer
357 views

How to filter web part content based on current wiki page taxonomy/category/keywords?

I have a series of simple wiki pages inside a Wiki Library (SharePoint 2010); As a test on a page, I have added a web part showing all wiki pages (w/ custom view), but I'd like to extend this web part ...
0
votes
1answer
74 views

Filter lists based on user permissions

I am following this guide to help me solve my problem. However, it is causing issues when I try to save the edited code in SharePoint Designer. I would greatly appreciate If someone could help me ...
0
votes
1answer
56 views

Use field in last item to filter the list view

I have a list which is updated about once a week with 50-100 new items through the use of Spreadsheet view and pasting from Excel. My problem is that I need to find what date when the list was last ...
1
vote
1answer
26 views

How do I change the web adress of a list?

I deleted a default list view and the web adress didn't change with that. So now it search for List/Old.View.aspx even though Old.View doesn't exist. This makes the site unavailable. How do I point ...
0
votes
1answer
53 views

How do I use the filter web part to sort out specific types of data from a list?

I am creating a landing page and was wondering how the filters works. Specifically, I want lists to be filtered depending on the user's permissions. So a user with contribute permissions for group A ...
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 ...
0
votes
1answer
359 views

SharePoint 2013 Managed Metadata Filter and Sort Issue in List View

My managed metadata filter is working properly by itself. However, when combined with other fields, all of my data are gone. Here are the set of combinations where my data is gone. 1. a. Managed ...
0
votes
2answers
206 views

Query String Filter Configure Connection not responding

So I have a Query String (URL) Filter, and a SSRS Report Viewer. I am trying to connect these two and a Configure Connection -- Webpage Dialog pops up and I can't do anything to my IE now. Normally ...
0
votes
1answer
310 views

How to render HTML/Plain Text to the filtering drop-down columns

I have a custom list, with some columns. In order to design my list with colors, I used calculated columns with a Content Editor Web Part which contains my script (JavaScript). I used this script : ...
0
votes
0answers
22 views

Under a list column the More option doesn't work reliably

I am using SharePoint 2013 and have tested this in IE11 and the latest version of Chrome with similar results. When I have a list and attempt to filter the list column. There is a More option that ...
0
votes
1answer
138 views

Textfilter webpart doesn't send empty parameter but parameter with previously searched word to external listview

My Filter in BCS is named 'FirstName'. Default view has following: <Method Name="GetEmloyees"> <Filter Name="FirstName" Value="{Param1}" /> </Method> <ParameterBindings> ...
0
votes
1answer
517 views

Content Search query, filtering using managed meta data

In a Sharepoint 2013 template, I'd like to get all contacts in a contact list filtered by their selected categories using Content Search. I do know how to get contacts based on a single value, but how ...
10
votes
0answers
464 views

Page Layout html page field filter outside of web part zone

I have a page layout with some web parts outside of a webpart zone so that they are added to already created pages which use the page layout. I want to add a page field filter to the page as well ...
0
votes
2answers
393 views

Multiple Filter Dropdowns on a webpart page

I am looking to set up three dropdowns at the top of a web part page that will allow the user to choose Week#, Region and Site in order to show a specific item (or items) from a Sharepoint custom list ...
0
votes
1answer
2k views

Filter Data View Webpart based on results of javascript query

I'm trying to dynamically filter the records that a Data View WebPart displays based on the return value of a javascript query. I would like some advice as to how I should do this or if it's even ...
0
votes
1answer
1k views

CAML Query filter by month

I would like to use CAML Query to select records between a certain period (a particular month) and which where made by a certain user. Here's what it look like but it doesn't work ...
0
votes
1answer
3k views

View filter settings: how to implement [TODAY] - 6 months

I am building a SharePoint 2013 portal. I have a custom list. On this list I try to modify the default view. I would like to change the filter settings. I would like to show only the items between ...
2
votes
1answer
5k views

date filter of today in rest api

I have a caml query filter for one of my date-time field. <Leq> <FieldRef Name ='StartDate1' /> <Value Type ='DateTime'> <Today /> </Value> </Leq> Is ...
0
votes
1answer
249 views

Imported Excel Spreadsheet not Filtering Column

I am uploading an excel template to the SharePoint site. I have 8 different metrics and want to add a filter to a specific column.SharePoint automatically adds the filter option to certain columns, ...
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 ...