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
170 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
1k 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
213 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
62 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
56 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 ...
0
votes
1answer
300 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
66 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
52 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
52 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
174 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
321 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
183 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
287 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
21 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
120 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
448 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 ...
8
votes
0answers
399 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 and ...
0
votes
2answers
289 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
2k 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
4k 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
218 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
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 ...
0
votes
0answers
59 views

suggestions for list search alternatives using filters?

I have a very large list (a supplier directory) that I want to make "searchable" by keyword within the same page. My company has locked down/removed all of the search web parts so that users cannot ...
1
vote
0answers
512 views

SharePoint 2013 Online CQWP, using design manager can't filter on a managed metadata column

I reviewed a lot of articles and couldn't find anyone talking this issue. My issue is when I use Design manager to create a CQWP snippet, I always get error message when try to filter against a Page ...
0
votes
1answer
358 views

Filter using url QueryString parameter 'a=…' does not always work for all fields

On a SharePoint SearchResults page the core results webpart can be refined or filtered using the QueryString paramters 'r=' or 'a=' in the url. I am attempting to use the 'a=' parameter which works ...
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 ...
0
votes
3answers
2k views

The field 'Author' of type 'User' cannot be used in the query filter expression

I was making a rest api call with Odata filter author/id. I want to get survey responses of a particular user. ...
0
votes
1answer
379 views

Default filter from scorecard to another scorecard

I am using SharePoint Server 2013 and PerformancePoint Dashboard Designer 2013. I have two scorecards, primary and secondary as shown in the following figure. Fig: Primary and secondary ...
0
votes
0answers
320 views

How to create a filtered list on Lookup columns

I have created a couple of custom lists, one called Partners, the other named Countries. The Countries list is populated with a list of the world's countries. The Partners list is a list of our ...
1
vote
1answer
1k views

Current User Filter Web Part - Wildcard Filter from Multiple Names

I have a list view webpart which contains a field which is a list of users, semicolon delimited. The field is a single line text field. I then have a current user filter web part which filters list ...
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
2k views

Filtering List using CAML query and Binding it to dropdown in C#

I have the following code which retrieves all items from list "Employee Info" and bind it to Dropdown list EmployeeDD. if (!Page.IsPostBack) { DataSet ds = new ...
2
votes
0answers
253 views

Filter.aspx and GetDistinctValues

We found an issue, that filters on columns are stop working. Error message is: Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the ...
0
votes
1answer
222 views

Connection Formula - Current and Previous Member

I am using SharePoint 2013 and PerformancePoint Dashboard Designer 2013. I have a Filter and a Chart in a Dashboard Page. When I select a member in a Filter, I want the Chart to display data for ...
0
votes
0answers
297 views

Filtering on managed metadata columns in the insert link from SharePoint view throws invalid viewstate error

I've seen this error before in SharePoint 2010 and now in SharePoint 2013 (w/SP1), and it should be pretty straightforward to reproduce using the following steps: Create a document library Add one ...
1
vote
1answer
137 views

Filter XSLT ListView with metadats as tags

My goals A documents library has a Metadata column. In a webpart page, user selects (through select2) several metadatas as tags. the tag(s) (one or many) are sent to a XSLT ListView XSLT ...
1
vote
2answers
814 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 ...
2
votes
0answers
77 views

Meta data navigation filter on custom page?

I have a public facing website were i want our customers to be able to browse all our support documents using the Meta data navigation filter, but i dont want them to access the real document page. Is ...
1
vote
0answers
54 views

Documents inside a folder not showing when a filter is applied in query string?

I create a webpart to show the Document List on a certain page, and then I applied a filter on a column content to show only certain documents. But in that way the folder structure is lost and all ...
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
0answers
172 views

Losing Filter When Paging Back From Second Page

I have a list view of a task list with filters creating subsets of tasks (Archived, Constructing, Defect, Stabilizing, etc.). The default view has a limit that will return 100 items at a time when ...
1
vote
0answers
406 views

Multiple filter value webpart connection problem

We currently try to connect a custom webpart with a list view webpart. The aim is to send multiple filter values to the list view. The problem we have is that the list view does only use the FIRST ...
1
vote
0answers
25 views

Create Connection beetween TextFilter and List

I have created a text filter webpart on my page and a list webpart app on the same page. If I edit the filter webpart it says that the filter is not connected and I should open the webpart editing ...
1
vote
0answers
81 views

Date range filter without SPD or Infopath

I am having a very difficult time trying to figure out how to create a page in SP2010 Enterprise that displays list items based on a user selected date range and status field is "approved" . ...
0
votes
1answer
203 views

Display list content in editable form, filter on [Current User]

I have been trying to develop a set of pages that each has a form on the page where the user can type a response to questions on each page, and the form is saved when they submit it. If the user ...
3
votes
4answers
4k views

Checked null with dateTime in REST API SharePoint

I want to get all article pages which Article Date is not null. so I have try to do by this way. var ArticlePageContentTypeID = ...