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
10 views

Custom column doesn't show up under Page Fields in SPD toolbox

I have a presumably an easy question than a harder question: I've setup a custom column (called "mycolumn") that is a choice type with several values you can select. I associated the column with my ...
0
votes
0answers
15 views

Merging multiple form libraries into a single view

I currently have two separate form libraries: one old one, and one new one. All new forms go into the new one, but the old library still has active forms in it. We created a page with filtered views ...
0
votes
0answers
9 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
9 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
0answers
61 views

How to create multiple operator options in one filter, and how to add “contain” filter in external content type?

I'm creating external content type from SQL server to business data list. I would like to create a read list operator based on search stored procedure. I noticed in creating filter table, there's no ...
1
vote
1answer
47 views

Have a webpart in a Page layout get filter value from column value

I'm new with SharePoint but I feel like I'm catching on pretty well. I'm creating a new page layout and I plan to put a list webpart in the right column. The list webpart will be filtered using the ...
-1
votes
0answers
33 views

How to get all users filtered by role in CSOM Sharepoint 2013?

In my SP2013 environment I want to write javascript code that uses CSOM (client object model) and retrieve all users, but filtered by role. Does anyone know how to do this? I found this Get all users ...
0
votes
0answers
36 views

SharePoint 2013 Date Range Filter on list using FilterFields and FilterOps

I am working on a project in SharePoint 2013. Currently I am trying to implement list view filtering using OOTB QueryString parameters. I have found the following params have been working a treat ...
1
vote
1answer
30 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 ...
1
vote
0answers
44 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
47 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
35 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
60 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
19 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
20 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
13 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
26 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
38 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
46 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 ...
1
vote
1answer
34 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 ...
0
votes
0answers
10 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
17 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
12 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
26 views

Manipulate Filters in Javascript

Is there any code in JavaScript which allow to manipulate filter to a library webpart?
-1
votes
1answer
21 views

Filter list based on week day

My list has a column of weekday: title weekday itemA 1 itemB 2 itemC 3 itemD 4 itemE 5 itemF 6 itemG 7 How can I filter a sharepoint 2013 list Item based on the day of the ...
0
votes
0answers
25 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
14 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
25 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
15 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
11 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
202 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
15 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
9 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
23 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 ...
1
vote
2answers
39 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
21 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
33 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
112 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
106 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
1answer
42 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
33 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 ...
0
votes
1answer
45 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
49 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
0answers
58 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 ...
1
vote
0answers
137 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 ...
0
votes
1answer
49 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
2answers
35 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
69 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.
1
vote
3answers
150 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: ...