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

Set default value of a filter (SharePoint Element)

i like to set the default value from my date filter webpart on my SharePoint Site to a calculated date. For example when i open the site, the date filter should have the date value from the current ...
0
votes
0answers
25 views

AD Username filter into List Items

I want to add Active Directory domain/username filter to a SharePoint list. ...
0
votes
1answer
19 views

How I can search the documents that have been filtered using the Metadata Navigation term inside my document library

I have document library inside my team site inside SP 2013, now I have enabled the metadata navigation site feature. which allow me to filter my documents using metadata navigation. But I am facing ...
6
votes
4answers
10k views

How can I filter a view using a blank multi-line field?

I have a multi-line text field and need to be able to show a view with only items where that field is blank (or functionally blank to a human looking at it). I've tried: field contains "" field ...
3
votes
4answers
5k 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 = ...
0
votes
0answers
15 views

Link to Filtered List in Site Page, then use header to filter again

I have a Site Page with a list embedded as a web part. The list has a unique view for this page. I want to create links to further filtered columns, creating an easier user experience. Example: I ...
0
votes
1answer
136 views

Filter sharepoint 2010 list view webpart with “date less than” condition

please help if it is possible to filter a sharepoint List View Webpart with a condition "date column less than selected date". With Data View web part it is possible. I also know that jQuery is ...
6
votes
2answers
6k views

Sharepoint Designer 2013, XSLT List View Options ribbon option is not showing

So I'm wondering if this is a bug or not. I have an ordinary Wiki Page, also tried making an Article Page. Once this page is made, I add an XsltListViewWebPart that points to a list, which is fine, ...
0
votes
0answers
39 views

Problems with Query Sting URL Filter when adding/editing Views

I have a page (A) containing multiple links with different query string URL's that are all directed to another page (B), where a query string filter web part takes the selected link's URL and passes ...
0
votes
0answers
11 views

Use next event in date list as filter for other lists in a WebPart page

This is what I am working with: a list of events, each having a date a list of topics, each topic having a date matching one from events a list of files, each file having a date matching one from ...
0
votes
2answers
74 views

External Content Type - SQL - Filters

I create a new external list via a new external content type SQL . I retreive my data and i can display it. BDC Service allows us to view 2000 items . 1st Issue: I can filtered through a ...
2
votes
0answers
129 views

How can I filter a List View in a Web Part page using AJAX so the entire page doesn't reload/refresh?

I have a Web Part page with a list view. I know how to use filter webparts that connect to the list view to filter the list. But those all reload/refresh the entire page. I was wondering if there is ...
0
votes
1answer
71 views

How to avoid large list error when modifying URL filtered view

I have run into a problem with SharePoint that is frustrating my users to no end. I have a large list (>5000 rows) that users can arrive at by clicking links formatted like this ...
0
votes
0answers
17 views

Duplicate a custom column with all content

first some background: I need to create a feature using xslt (for a Data Summary webpart) that filters for a column being empty; unfortunately this column is defined as multiple lines of text, ...
2
votes
2answers
310 views

jQuery autocomplete with TextFilter and click not keeping selected data

How can I add autocomplete to a textfilter webpart which keeps the mouse selected value as the textbox value? With the current code user start typing then autocomplete list brings up but once he/she ...
0
votes
1answer
85 views

How do I filter document library with url? [duplicate]

I'm attempting to filter a document library using the url I've attempted to do so using this mydomain.com/it/Shared%20Documents/Forms/AllItems.aspx?Filterfield1=name&filtervalue1=retirement ...
0
votes
2answers
2k views

Filter not working when I create custom view (screenshots attached)

I have a list named "Test". On this list I enabled approval workflow named "Test". If you take a look at screenshot below which shows "All Items" view you will see 3 items, 2 approved and 1 ...
0
votes
0answers
34 views

Is there anyway to filter document search results using REST?

I would like to have a page listing documents filtered by specific parameters such as contains text, contains tag, etc. I would like to make a query like this using a GET request sent from another ...
0
votes
1answer
23 views

Can I stop Filter Items from truncating on Column Filter Dropdown (…)

I have a Lookup field on a Library which is related to a List of Items. After these items reach a certain length, the items in the Filter Dropdown get truncated, and a '...' is added to the end of ...
6
votes
2answers
136 views

How to fix 5000 Limit for Views but without breaking Alerts

So recently I saw the infamous message about getting close to the 5,000 item limit. After spending a couple of days doing some testing, it seemed like the best option would be to simply Index the ...
0
votes
0answers
36 views

Sharepoint 2013 BI (Excel Services) - How to target the filter to a certain audience?

We have an environment that contains Windows 2012 Servers and an Active Directory, SQL Server 2012 and Sharepoint 2013 on Premises. Powerpivot has been configured and the Business Intelligence Center ...
0
votes
1answer
174 views

SharePoint/InfoPath 2010 – Filtering InfoPath form to show current user only

First post on here from a relatively novice user of SharePoint 2010! I am currently implementing an annual leave recording system for staff. I’ve created two lists to hold the data – a list for the ...
1
vote
1answer
44 views

List form or Infopath filtered choice column

I'm about to start building a custom list to capture a number of different query types. I was intending to do this with some custom Site Content Types but I've realized that I'm going to need to ...
0
votes
0answers
16 views

URL Filter doesn't work after InfoPath form submit

I have a URL Filter connected to an InfoPath form and then a list that displays the infomation from the form that is also connected to the filter. Currently the URL Filter is being used to set a ...
0
votes
0answers
12 views

Filter Blog Posts with text filter

I am trying to provide users with a free-form text field which they can use to filter blog posts. I believe the categories web-part is provided OOTB as a way to filter posts, but this does not really ...
9
votes
4answers
17k 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
1answer
137 views

More advanced logic while filtering a view? SP2013

I am attempting to filter a document library view in SP2013 but I have three things I need to filter on and I don't know if I can perform the logic desired. I want this view to only show documents ...
1
vote
1answer
155 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
vote
4answers
2k views

Filtering REST call with lookup field

We have a column defined on a custom list that allows for multiple select of values from another custom list. The column on the list is call Panels. When I do a REST call against this list, I can ...
0
votes
0answers
51 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 ...
2
votes
0answers
77 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 ...
0
votes
0answers
75 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
106 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
74 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 ...
3
votes
2answers
29k 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
65 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
359 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
88 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
206 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
437 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
44 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
81 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
62 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
64 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
219 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
371 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
17 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
235 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
44 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 ...