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
2answers
26 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 ...
1
vote
0answers
14 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
43 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
11 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, ...
1
vote
2answers
103 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
792 views

Unable to create valid SPDataSource Select Command

I am to use SharePoint Designer, no custom c# code. I am currently using a SharePoint:SPDataSource on a DVWP to show a list. When the SelectCommand is blank, it works fine but I will need to create ...
0
votes
1answer
28 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 ...
1
vote
0answers
17 views

Use people results to show only users having access to current site collection

We've an Office365 site with more than 30K people using it, and we are using people search to show these users. This shows all the users in the tenant. But we need to show only people having access to ...
0
votes
2answers
1k 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
24 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
11 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 ...
5
votes
2answers
51 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 ...
3
votes
1answer
964 views

BDC List column picker filter - search/filter not working and exact entry says not found?

I'm working with MOSS 2007. Rephrasing the question. I have a BDC column to an external datasource in a custom list. Today searching and filtering is not in place and actually exact matches are not ...
0
votes
0answers
21 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 ...
1
vote
1answer
835 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 ...
0
votes
1answer
27 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
555 views

Display connection information within a ITransformableFilterValues web part

I created a filter web part by extending the ITransformableFilterValues interface, similar to this page: MSDN. I want to mimic the Microsoft query string filter and display the connection information ...
2
votes
1answer
4k views

How to add a custom filter for a chart?

I have a list which contains multiple columns. I have inserted the chart web part and it's showing the graph based on the column list. Now I want to add a custom drop down filter which contains column ...
1
vote
1answer
31 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
12 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
2 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 ...
5
votes
4answers
5k 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
2k views

SP2010: Filter list in a WebPart by Contains not Equals (adding a wildcard)

This question isn't new here, but after reviewing existing posts I still need your advice. If I need to "search" list data using a wildcard, I have to modify the XSL code. A step-by-step instruction ...
0
votes
1answer
582 views

Grabbing a filter value via CEWP code behind

I have employed a Query String Filter to parse a value and send it to a chart web part. now I would like to use this value in a CEWP to provide an explaination/clarification for the chart, but the ...
0
votes
1answer
33 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
51 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 ...
0
votes
4answers
452 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 ...
5
votes
1answer
3k views

Filters on a large list exceeding throttle limit

On a SharePoint 2010 Server installation, I have a list with more than 5000 items. I created an indexed column and a view based on this column which is returning 100 items only, so far less than the ...
0
votes
0answers
17 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
65 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
20 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
16 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
1answer
2k views

Custom List Filter - update list view only on second button click

What I try to do is making a simple list filter tool for SharePoint 2010 lists. What I have so far: I made a VisualWebPart (VWP) named "ListFilter", which should update the view of the list (see code ...
0
votes
0answers
14 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
18k 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 ...
0
votes
0answers
65 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
32 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
63 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
51 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
39 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
2answers
177 views

Sharepoint 2013 CQWP - Filter by Approval Status

I'm kind of stuck in a Content by Query Webpart. (Yes, i'm aware i'm on 2013, and yes, i could use Content by Search WebPart, but this is a standard edition, so no, finally i can't use CSWP) I would ...
0
votes
1answer
91 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
26 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
2answers
1k 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
0answers
15 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
41 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
49 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
73 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 ...