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
0answers
75 views

Error during Meta Data filtered list viewing using Quick Edit in SP2013

I get this error when I click on filtering meta data columns in a Quick Edit Grid, "div class= ms-vb unable to render the data". Any ideas on the cause or solutions?
0
votes
0answers
57 views

Picker Control Filter for External List in SharePoint 2013

I have an External List in SharePoint 2013 as shown in image below. I have a field called Department. In the Read List operation, I have added wild card filter for Department column. For Calendar ...
2
votes
2answers
25k views

How can I filter a SharePoint list based on a date column?

I have a column with "start date". I also have a column called "expire date". How can I make a filtered list so that it only shows items where the "start date" is equal or greater and equal or ...
1
vote
1answer
54 views

Filter by “Created by” is not working

I have created a list view that filters documents on "Created by" column. Users within my organization are able to see the information correctly. However, users who are logging via external ...
2
votes
0answers
265 views

Filter by calculated column with rest api in Sharepoint 2013?

Apparently you can't filter by calculated column with Sharepoint 2013 rest api? The calculated column in question returns a string. ...
1
vote
0answers
74 views

View with `Current User Filter` doesn't work

I have a View of a List which uses the Office value of the UserProfile to filter the items, using a UserFilter Webpart and adding the Parameterbinding it works: <WebPartPages:XsltListViewWebPart ...
0
votes
2answers
142 views

How to filter a list by hour

I am on SharePoint 2013 and do not have access to Designer, as a preface. I am trying to create a list view that filters items by whether or not they were added in the last hour. I had done this ...
0
votes
1answer
264 views

Disable column header filter and sorting

I am using SP2013 on-premise. On a list view all the columns' header come with a filter+sorter function. It is not useful on some columns (e.g. photo, which show a picture and no point to sort, and ...
0
votes
1answer
35 views

how do I filter a view in SharePoint based on last year?

I need to create a view with only last year, 2014, data showing. I tried creating calculated columns for start and end date and using less than start date and greater than end date filter in the ...
0
votes
0answers
67 views

Add filters under webpart.xml properties: <property name=“”

I have a webpart coded with XML, there I retrieve data from Announcements list. It was working fine without any filters. Now I want to filter by Expires date. I have added one line of xml. But it ...
0
votes
0answers
41 views

How do I filter my result set by user when querying a survey list?

I don't like the way SharePoint forces an error message on my users when they've already responded to a survey. My task is to check the survey first, to see if they've already responded and then ...
0
votes
1answer
60 views

2010: Query String URL Filter doesn't filter until postback

I have a Query String URL filter sending a value (ProjectID) to a task list which filters the tasks down to match the query string. On page load, however, all tasks are displayed, making it seem that ...
0
votes
1answer
123 views

How to create a display for last major version only

We are using a SP2013 site with some workflows and we need to display documents withe their last version only. Let's say we have 5 docs with minor versions (1.2, 2.6, 2.2, etc...) and we want to ...
0
votes
1answer
249 views

How do I use REST $filter with a “Hyperlink or Picture” type column?

The $filter method works perfectly on regular text columns, but I can't figure out how to use it with a "Hyperlink or Picture" type column. For example: ...
0
votes
0answers
13 views

WebPartPage and MultipleItemView

I have a list List1 that is references 1:1 to the Sharepoint users. I need to create a page which displays the data of the record of List1 based on the current user. I know that I could create a View ...
0
votes
0answers
16 views

use today as default filter in WebPart page

I've got a WebPart page with: 2 list view Web Parts with a date column a query string filter that looks for "meetingDay" and sends the value to the list view Web Parts So when I go to ...
0
votes
0answers
164 views

Multiple Column Lookup in SSRS expressions

Hi I am working in SSRS 2012. My dataset/table schema is as below. ID,Name,Age,Address In my report table this data set is the source. What I want to do is I want to filter my data set in ...
0
votes
0answers
27 views

“Get Filter Value From” prepends “id;#” to the value

I have two lists that are connected to each other. Tracking Numbers: Has one Shipping address Shipping Address: Has many Tracking number On the Tracking number edit form I would like to display ...
0
votes
1answer
38 views

Manipulate Filters in Javascript

Is there any code in JavaScript which allow to manipulate filter to a library webpart?
0
votes
0answers
53 views

Consumer Field Name - no parameters provided

I am trying to to filter my chart based on start and end dates but I the configure connection webpage dialog box does not provide the field names to choose from.
1
vote
0answers
446 views

Filter a CQWP on a Lookup Column

I'm creating a custom page layout that contains a CQWP that I'd like to display documents related to the page. The document library has a lookup column that relates to the page title in the Pages ...
0
votes
3answers
187 views

Document Library Not Filtering Columns

There is a document library which has over 5000 items, it has passed its item view threshold. The view was reduced to show items that met certain requirements. This view now shows less than 1000 ...
1
vote
0answers
28 views

Limit Dates available for selection and limit enteries displayed by those dates

I am creating a small timereporting list and would like to have the user select from a list of limited dates. The dates should be all the date for beginning of the week (i.e. 05/04/2015, 05/11/2015, ...
0
votes
1answer
46 views

Filter SharePoint List differently in context of logged in user

I have a list view with a filter matching according to a people picker column called Manager is equal to [Me] so that Managers see their own records. The creation of the records are initially done ...
0
votes
1answer
16 views

Need help with setting up a filter for a view (sharepoint UI only)

I need help setting up a and/or filter and I can't seem to get it right. Its based off dates. I am looking for the following: Between (StartDate-Status1 and EndDate-Status1) OR ...
0
votes
0answers
15 views

SharePoint List Filters search options

I am using SharePoint 2007 and want to know if it is possible to search on part of a value within the specified column I link to within the list. Currently it is set up to 'search on first name' ...
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 ...
0
votes
0answers
23 views

Display Active directory user Properties(name,mail) And filter through People picker value

I want to display AD user properties which filter through people picker value which I getting from the people picker control I show all user using this filter search.Filter = ...
0
votes
0answers
28 views

Create Hyperlink to pass filter parameters between pages to filter web parts

The setup is this: I have a web part page (my "Results" page), with a series of list web parts (i.e. different list views) on it. These web parts take filter from a SharePoint List Filter web part on ...
0
votes
1answer
24 views

Search a SharePoint 2010 List

Using out of the box functionality, I added a search web part and my list view below it on a page. Connected the two and I am able to search the list as needed. The problem is that the list already ...
0
votes
0answers
120 views

Filter view by hyperlink column

I'm using SharePoint 2013 and I have a library in which one column is of the type hyperlink. Now I have a view in which one of the columns to be displayed is the hyperlink, this one has the url and ...
1
vote
0answers
18 views

Linked webparts filter

I have a page with 2 linked webparts, actually 2 list views. (One view is simply sending a parameter to the other view). My problem is that when I use the list filter (by clicking on the view column) ...
0
votes
1answer
333 views

Dynamic filtering an XsltListViewWebPart

I want an XsltListViewWebPart filtered based on some custom metadata derived from the current user. Following Claudio Brotto’s article ...
1
vote
2answers
56 views

Save Choice Filter Selection

I have four lists on a web page that I want to be controlled by a choice filter web part. The four lists have a common column between them, so I want users to be able to select an item in the choice ...
1
vote
1answer
32 views

Need to show oldest 3 items in one webpart and the remaining items in another webpart

I have a scenario where I want to divide a list's items into 2 webpart views - one that shows only the x oldest items (people that should be seen next) and another list on the same page showing the ...
1
vote
1answer
48 views

Conditional List Filters

I'm having trouble figuring out a way to create a filter that I need for a list I've made. I need to filter a certain column based on the current user. For example, if the current user is "John ...
0
votes
1answer
208 views

Sharepoint 2013 - Search files into File Share (content source) with filtering by folders

I crawled content that is on stored on file server (File Share - content source in SharePoint Server) and i get the results in SharePoint search. Everything is fine but i need to have some kind of ...
0
votes
1answer
186 views

How to Connect a list from another Sharepoint Web Application

How Could I connect a SharePoint another list which is situated in another web application? A mast get another list from another web application, and give a filter to show only this elements, which ...
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 ...
0
votes
1answer
141 views

Open in explorer view to show a filtered view of the list or library

I am looking at a filtered view of my library on my site so I am only seeing certain items. When I click open in explorer, I see everything in the library and my filter is no longer applied. Is it ...
1
vote
0answers
278 views

Unable to filter Excel web access web part

I have an excel web app with a pivot table that's data comes from a powerpivot SQL data source. I am trying to filter this data via basic 'choice web part'. when applying the filter i get an error ...
1
vote
0answers
64 views

Filter [Me] doesn't work correct

We have a task list with a filtered view for the users. The filter is "assigned to = [me]". Normally it works fine, but now there is one users who doesn't see all of his tasks. So i checked the ...
0
votes
1answer
113 views

REST API get by author differences by platform

I find that when I want to retrieve custom list items by author (in this case, by the current user) I need to use a different query whether using SP2013 on premise or O365. I tried creating the same ...
0
votes
0answers
132 views

Show Filter Choices shows empty options in SharePoint 2010 List

We have SharePoint 2010 and there is a list that has 4600 items. When users try to filer a column, they get Show Filter Choices from the drop down menu: When they select Show Filter Choices They ...
0
votes
2answers
42 views

Refine search get aspx pages only based on tags

I have to search all the aspx pages in my site-collection based on tags. For example - Tag "finance" has been added to finReport.aspx and denialsReport.aspx. So when user search finanace, it should ...
0
votes
1answer
239 views

Filtering SharePoint List columns using a textbox (like filters in MS Excel)

I want to enable search on every column of a SharePoint List. It should work like filtering in Excel. User can type in the textbox and filter that column.
0
votes
0answers
44 views

Filter on Views don't work after update 2956175 is applied on SP2013 env

We have applied Filter on a task list view on the Assigned To column. This was working fine. Last friday we installed the Security patches available from Microsoft published on 3/10/15. Immediately ...
1
vote
3answers
773 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: ...
0
votes
1answer
43 views

How to filter item based on StartDate and ExpireDate?

I have an announcement list with StartDate (datetime with time) and EndDate (datetime with time). I am adding 15 future annoucements and i would like to automatically display item or items when start ...
0
votes
2answers
202 views

Filter by login user department on SharePoint

I need to create a new view on a custom list that filter only the items that are added (created) by the users department, so any user can view all other items that are added by the other members of ...