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

learn more… | top users | synonyms (1)

1
vote
1answer
2k views

REST API filter multi person/ group column by null

I have a multi person/ group column. I need to apply rest api filter on this column. I can filter it by values. eg: _api/Web/Lists/getbytitle('testList')/items?$filter=(Access/Id+eq+21) But when I ...
1
vote
1answer
178 views

Filter Sharepoint 2013

I have a customer who asked a very difficult requirement and do not know if possible. It uses excel but all migrated to sharepoint, and there is a filter in excel there is a text field to write and ...
1
vote
1answer
1k views

Displaying Calculated Column hyperlinks as text in filter drop downs

I have a list which has employee IDs as a field. I then have a calculated column which takes this field and uses it to link to our company-wide employee directory. This means I can hide the employee ...
1
vote
2answers
940 views

Sort and Filter Rich Text

i have a sharepoint list with a few rich text columns but in the view the headlines of these doesnt have the button to sort or filter them like all other non rich text columns have. is there a way to ...
1
vote
1answer
162 views

Categories Dropdown Box (edititem.aspx)

I would like users to be able to select a pre-determined category from a dorpdown list rather than manually typing in their own category. The image below shows the current 'New Item' screen in ...
1
vote
1answer
827 views

Filter file types from list to NOT show certain file types

I have a document library list. Lots files, and a handful of file types. I know how to force a filter via the URL. Saw docx file. But right now, I have a need to show all files except docx, pptx, ...
1
vote
2answers
965 views

Document Library Filter

This may seem like a simple question, but I have spent hours trying to get this function to work properly. I have two data columns in a document library with a view titled "today". The idea is as ...
1
vote
1answer
1k views

Filter Sharepoint 2010 List with Duplicate Items

I have a list that is being used for document control. The list contains multiple items with the same Title as well as other columns. It also contains a manual revision column I would like to display ...
1
vote
1answer
982 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 ...
1
vote
2answers
160 views

How to connect two lists and produce customized reports

I have two lists. The first list, 'Suppliers', is a list of suppliers with the various contact information. The second is 'Ratings' this contains a lookup of the supplier name and various number ...
1
vote
1answer
492 views

Populate a Filter web part from a List item and execute

I have a Business Data Related List called Projects. It is connected to a Business Data Item, so it has the option to select an item (the two-way arrow next to an Item). From this List I need to pass ...
1
vote
1answer
407 views

How to set a value in a list based on the current filtered column value

I have edited my document set Welcome Page to include a web part of a "Notes" list. This list is filtered so that only notes pertaining to the currently viewed document set are visible. Question: ...
1
vote
2answers
752 views

Page Field Filter displaying 1;#ColumnName instead of ColumnName. Bug?

I have a Document Library with a column (we'll call it ColumnName) and a Web Parts Page with a value assigned for that column. On that page I have a list view displaying the Doc Library files and a ...
1
vote
1answer
375 views

How do i create a static text filter on a list webpart

I would like to use a constant as a text filter on a SharePoint list webpart. I can add a text filter and use it to filter the list successfully, but I don't want a control and I never want to change ...
1
vote
2answers
376 views

SP 2010 REST $filter column

I'm trying to filter a list using the REST service. The column im trying to filter is the default column "Modified". My problem is: I can get all itens created today, but not only the items created ...
1
vote
2answers
433 views

Filter Library with parameter

I am an intern at a company, so I am not completely sure about the structure of the servers etc. However, I have a library that I want to filter by the department that the currently logged on user is ...
1
vote
2answers
2k views

Sharepoint 2010: List view to always show last friday's data

I've been working on this issue forever now...Here's what I'm trying to do. I have a custom list where people add some info. I crated 2 views to view items added today and yesterday. Now I'm trying to ...
1
vote
1answer
413 views

Filter Data View with SOAP Query as Source

I am creating a printable company directory. I have a SOAP Service query that pulls everyone's data from the search service. The query returns all the results I want. I have enabled the "Sort & ...
1
vote
2answers
608 views

Sharepoint Foundation search filter? (Exclude all but SP wiki 'x')

I've looked (unsuccessfully) for what others have done on this topic. Within our Sharepoint Foundation site we have multiple wikis and we'd like to use the Search feature to search content from only ...
1
vote
1answer
982 views

Turn filter on by default on a sharepoint view

I would like to filter a column defaultly on my SharePoint view, is it possible to do so ?
1
vote
1answer
975 views

Need Filter to calendar list i.e for calendar.aspx page

For Calendar List - web part connections doesn't work and query string doesn't work. So I am out of options here. Can any one guide me to how to filter the calendar list data in calendar.aspx. I am ...
1
vote
1answer
1k views

Calendar DVWP to show only today with recurring and all day events

I got a interesting problem here. I developed a dashboard for one of our departments, they wanted a widget that shows only today's events. I have the DVWP in place, and filtering by a calculated ...
1
vote
2answers
1k views

spgridview clear filter programmatically

I have a textbox a button and a spgridview. When the button is clicked I will search SharePoint with the value in the textbox and bind it to the spgridview. (I'm using LingDataSource). After I filter ...
1
vote
1answer
816 views

How can I Filter a Joined DVWP by [Current User] in Multi-User People/Groups field?

I have a joined DVWP. List A includes a "category" lookup field among other columns. List A includes the same "category" lookup field as well as a People/Groups field with multiple selections. I'd ...
1
vote
1answer
133 views

Filtering List for “created by” of currently displayed user

Hey i'm trying to filter a list for the currently displayed user in the mysites. There is a list "projects" with all projects in it. If i navigate to some co-workers profile in the mysites he has a ...
1
vote
1answer
527 views

SharePoint Web Part Connections & Filters

I have a basic web part page with a number of webparts which use one identifier to filter a long list of results. The problem is there are about 25 records and it roams all the way down my page - is ...
1
vote
2answers
2k views

Programmatically filter document library view

I am starting a SharePoint application where I need to filter a document library dynamically when a user visits a page. Is this possible? If yes, how? Is it possible to have an application page with ...
1
vote
1answer
2k views

filter sharepoint 2007 search results by date range?

i want to filter the sharepoint2007 search results by given date range. I.e., With in a day With in a week With in a month With in a year Is it possible? If so, please help.
1
vote
2answers
1k views

Filter WebPart where customer number = current document library name

I have a web part page in a document library (http://mysitecoll.com/subsite1/Cust001/cust001.aspx) I have added web part to display list from the top level. It works and displays all the items in a ...
1
vote
0answers
19 views

how to show filter choices by default on lists

my list has 501 records and I was expecting that "Show filter choices" will be available on each drop down columns but it this didn't happen. when i try typing ?Filter=1 at the end of the URL, I see ...
1
vote
0answers
27 views

SharePoint 2010 CQWP crashes when filtering using “Me”

I am trying to use a CQWP to display recent documents that the user viewing the page has uploaded onto any site in a site collection. I set the List Type to "Document Library" I leave document type ...
1
vote
1answer
30 views

Filtering problem with data part in SharePoint Designer 2013

I am building a custom view based on a data source. Data source base on data from several libraries with the same content type structure. I can categorize and sort these data without problem, but when ...
1
vote
1answer
54 views

Query String (URL) Filter Web Part

I am developing a portal in SharePoint 2013 in which I am using Query String URL filter web part, the function of web part is to filter the web parts on the bases of years. I gave the default Year ...
1
vote
0answers
38 views

How to configure a Filter web part to filter two lists at the same time?

I have two list on the same page, they both have the same Column. I need to add a filter to sort these both lists at the same time via this same column.
1
vote
2answers
153 views

How to get specific sub sites Using Get-SPWeb object

In the code below i only want to get following 3 specific subsites using Get-SPWeb Object. which filter command is most appropriate to target only these 3 sites 1. ...
1
vote
0answers
47 views

SharePoint List filter web part - remember selection jQuery

I have a SharePoint list filter web part connected to other web parts which filters content based on the our clients names, everything it working great but I have one issues: When i select a client ...
1
vote
0answers
27 views

Cascading managed metadata columns

I have set up the following terms hierarchy in the Term Store: My Terms Departments Accounting Project Accounting Procurement Human Resources Payroll Recruiting I have then created two ...
1
vote
0answers
29 views

Combine JSLink of UserContextFilterWebPart and a XsltListViewWebPart

I have a WebPartPage which includes a XsltListViewWebPart and a UserContextFilterWebPart. In order to filter the results by the user office and 'connect' the two webparts, I added the parameter ...
1
vote
1answer
24 views

Disallow Manual Filtering

I'm using SharePoint 2010. I have a webpart page with a Choice Filter webpart and a list webpart connected to the filter. Everything is setup and functioning correctly. But... If the user manually ...
1
vote
1answer
140 views

Why doesn't FilterOp work with Inplview?

I am trying to pass a URL into a SharePoint listview with parameters for filtering. The FilterOp paramter doesn't work with inplview for me. If I pass the parameters in normal query string format ...
1
vote
0answers
31 views

SP2010 - How to stop a Jscript filtering folders

I'm on SP2010, managed by my company so unfortunately no access to server and can't add additional web parts. I previously had the need to build an A to Z filter in a library. I have used a Jscript ...
1
vote
0answers
37 views

Getting too many groups when sorting after grouping on spgridview?

When applying a sort on my spgridview after grouping, the sort does works but the groups are splited in many others labeled identically. For instance, if I have: group 1 4 2 group 2 3 group 3 ...
1
vote
1answer
48 views

How to filter on System.DateTime using FilteredDataSourcePropertyFormat?

I'm using an SPGridView that displays search results and it works perfectly. Sorting and filtering works fine as well unless for the DateTime Column. When I'm trying to filter by Date I have the ...
1
vote
0answers
16 views

Dynamically create metadata terms

Use case: SP List synced to Access database. Database gets data from an external app and updates list dynamically. The value in one field gets added to metadata term set. Users can search/filter the ...
1
vote
0answers
35 views

unable to use content query webpart to retrieve the list content (custom template) from subsites

I am unable to retrieve the list items via content query web part from all the sub sites of a custom list created with a template. This is a SharePoint online site collection and i have placed the web ...
1
vote
2answers
203 views

Update InfoPath form field value in SharePoint Online document library?

I have saved InfoPath Form in a Form Library & also saved field values in separate columns, now I have retrieved one record in InfoPath Form 2013. I'm trying to update Status columns value from ...
1
vote
0answers
42 views

Cascading SharePoint List Filter

I have a list in my sharepoint site that has two columns I want to filter by on a webpage. I want to have the first sharepoint list filter webpart to have the person select a Project Manager. Than I ...
1
vote
0answers
41 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 ...
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 ...
1
vote
1answer
174 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 ...