A filter in SharePoint usually refers to a mechanism that limits the items displayed by the criteria provided.

learn more… | top users | synonyms (1)

6
votes
2answers
162 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
2answers
105 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 ...
0
votes
0answers
40 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
254 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 ...
2
votes
2answers
387 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 ...
1
vote
1answer
45 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
18 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
20 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 ...
0
votes
1answer
225 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
0answers
107 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 ...
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 "...
1
vote
1answer
208 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
1answer
596 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
73 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 account(...
4
votes
0answers
482 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. http://site/_api/web/lists/getbytitle('TestList')/items?$filter=...
1
vote
0answers
100 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
294 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
561 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
50 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 view,...
0
votes
1answer
71 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
374 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
538 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: /_api/web/lists/getbytitle('Sponsors')/items?$...
1
vote
1answer
604 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
1answer
47 views

Manipulate Filters in Javascript

Is there any code in JavaScript which allow to manipulate filter to a library webpart?
1
vote
0answers
32 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
62 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 ...
1
vote
2answers
2k 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
1answer
27 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
87 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
44 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
76 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 Doe",...
0
votes
1answer
319 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
600 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 http://blog.claudiobrotto.com/2012/extending-base-xslt-web-parts-...
1
vote
1answer
49 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
359 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
272 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
76 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
177 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
368 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
211 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
73 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
348 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
1k 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: http://test-site/_api/...
0
votes
3answers
3k views

Filter current month in list

I have single text for Month. I want to create View with filter with Month. Example :Month is equal to the current month formula is =MONTH([Today]) But it is not working.
1
vote
3answers
703 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 ...
1
vote
0answers
20 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
57 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
332 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 ...
0
votes
2answers
269 views

SharePoint 2010 Rest API filter statement not working

I am trying to filter a rest query but can't seem to get it to work. During my testing, the following statement works (no filter, a alternate way to get the item I wanted): // sort the list desc and ...