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
1answer
7 views

How to change filter choices that appear on the drop down menu next to a list column?

I'm working with SharePoint 2010. I've created a calculated column B which displays bubble images of 2 colors based on the value of column A. Now, the issue is that on the list view, if an user clicks ...
0
votes
0answers
9 views

Strange ListView behavior using FilterLookupId in SP2013

As stated in this post, I have a problem on navigate between pages in filtered views when the filter includes FilterLookupId in order to refer to the id and not to the value of the field. Opening the ...
2
votes
1answer
1k 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
5 views

Get Blog Posts By Category (Filter blog post by PostCategoryId)

I Am trying to get filter blog post by category but get an error I suspect its because I am not using the PostCategoryId internal name? but i dont know how to find what this internal name is ...
10
votes
0answers
462 views

Page Layout html page field filter outside of web part zone

I have a page layout with some web parts outside of a webpart zone so that they are added to already created pages which use the page layout. I want to add a page field filter to the page as well ...
0
votes
1answer
16 views

Crawled/Mapped Properties w/SharePoint Online

I am trying to customize the People directory in my SharePoint Online Search Center. I have a few properties mapped to fields that sync from my company's active directory to Office 365, such as last ...
0
votes
1answer
27 views

View List with 2 filtering

I want to add 2 filtering a list. List item not to be shown after the Closing date List item not be shown till the Publish date reaches. I've added a Closing and Publish Date on my list. But not ...
1
vote
0answers
16 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 ...
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 ...
3
votes
1answer
29 views

Filter/Search specific fields in list

I have a custom list with two columns: Person Name Person Age I want to have a search/filter area where user can search by person name or age. Name search should not be exact match and must be like ...
0
votes
1answer
23 views

Adding filter manually to a DVWP using XSL

I have a 5 columns DVWP created using a linked data source (of 3 SP tables). The first 3 columns are from the first SP table, while the 4th and 5th column are from the remaining 2 SP tables. In the ...
2
votes
1answer
695 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
0answers
21 views

Filtering a lookup while getting around the over 5000 item limit in Sharepoint Online

I am tasked with fixing a lookup field for a SharePoint Online Site being used for Project Management. Two lists; Projects and Contacts. One of the fields in Projects is a lookup field to Contacts for ...
3
votes
1answer
626 views

What is this URL list filter parameter?

I have a I am trying to build but I need to know what to populate in one of the parameters... For Example... ...
1
vote
3answers
36 views

Need to filter a list with 10+ criteria

Need to create a list filter with over 10 criteria. Research tells me that it can be done with a Data View web part but I have not found any instructions on how this is done.
8
votes
2answers
5k 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
1answer
22 views

filtering webservice request with viewXml

Situation I have a Ajax query that gets all items from my list it gets all items (1000 ish) and the query alone takes about 1.3 seconds of the total load time of 1.5 seconds. Problem I know this ...
1
vote
1answer
2k views

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

If I need to "search" list data using a wildcard, I have to modify the XSL code. A step-by-step instruction for doing it in SP2007 has been provided at Can I Filter a List/Data View using Contains ...
1
vote
1answer
23 views

Multiple columns $filter in SP designer 2013 http web service call

How can I filter on multiple columns when making a web service call in a SP 2013 designer workflow? For example if this is the url for the service call then how is the $filter part different from what ...
0
votes
3answers
2k 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
1answer
569 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 ...
0
votes
1answer
870 views

Filter a List View based on data in another list

I'm looking for guidance on how to approach a problem. I have two lists, Goals and Tasks. Goals is a simple custom list with Name and People-Involved. Tasks is a task list with a lookup field to ...
1
vote
1answer
25 views

KeywordQuery filter by Start and End dates using Today

I have a KeywordQuery that I need to filter so the current date is between the Start Date and End Date. Today >= "Start Date" && Today < "End Date"
4
votes
2answers
5k 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
1k 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 ...
1
vote
0answers
40 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
3answers
705 views

Remember filter value using jquery and cookies

I am looking for a solution for the following problem: I have a large list that is related to a second list. The two list web parts are on one page, when you select an item in the first list, the ...
0
votes
0answers
19 views

Link on lookup field go to filtered list

I currently have a List A with a lookup column called "Category" that is using a list of categories in List B. The column is currently hyperlinked and when clicked it shows the item from List B. Is ...
2
votes
2answers
565 views

How does SharePoint handle AND / OR view filtering?

Premise: For the example let's suppose I want to create a view that displays Pending items but filters out the Rejected. Since there are multiple approvers, both Col A and B must be used. When ...
1
vote
1answer
24 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
42 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
1answer
30 views

How to implement user based views

I would like to have a team site that changes based on the user that is logged in. The team site is supposed to be a landing page for everyone in the company to start their day. How can I set it up ...
3
votes
1answer
37 views

List view filter

Can I filter my view to show only 5000 recent added/updated out of 6000 items? My list has more than 5000 items and I want to show only 5000 recent items.
0
votes
1answer
30 views

How do I add an 'Show All' Choice to a HTML Form Dropdown Filter (being sourced via SPServices GetListItems)

I'm trying to build a projects dashboard page of sorts, with HTML Form Filter Web Parts that will allow the user to select from filters, and have those filters connected to various document and list ...
0
votes
0answers
25 views

how to search, filter and retrieve 20k items in SharePoint

I have a lists containing 20k items.I want it to display it in a page and that page also contains filters just like in ecommerce site.I tried to retrieve the whole items at the beginning using rest ...
0
votes
0answers
35 views

SPGridView Filter one column with multiple values. Sharepoint 2013

When I click on the column header in SPGridView I can select only one value to filter by. Is there a way to be able to filter one column by more then one value? I know that changing the url from ...
1
vote
2answers
65 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. ...
0
votes
0answers
16 views

community home page filter

I have been recently introduced to SharePoint 2013. My first task is to create Community site with different category the link to the sub site is from the main page when clicked the forum list and ...
0
votes
0answers
25 views

Caml Query for dynamic SP custom list filter

Good day, I need to make a custom dropdown for filtering a list view. I made a dropdown by adding a content editor in the view and just added a <select> dropdown. Now when I open SPD and edit ...
1
vote
0answers
40 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 ...
0
votes
1answer
33 views

Filter Rest API AssignedToId

I've been trying to filters with rest API, but I seem to be struggeling with easy requests. So this one works without any problems ...
1
vote
0answers
21 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 ...
0
votes
1answer
15 views

Connect contact list to Outlook - A way to group contacts by column filtering?

Is there a way to have one contacts list - with a column that divides/filters contacts into groups (say A, B, C) that when you create a view for just Group A and connect to Outlook, it just syncs ...
0
votes
0answers
13 views

Multiple selections on filter web part

I have a text filter web part on my web part page which is connected to a list. I was trying to figure out if there was a way to pass multiple choices to my list using the filter. For example I am ...
1
vote
0answers
23 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
20 views

SharePoint Online - Custom List - Permission on Based on Department Column

I have a custom list with 200 records/items and there is a column (lookup) with department names (about 20 department). I want to give access to number of items based on the department. A similar ...
0
votes
3answers
2k 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. ...
2
votes
0answers
17 views

no items returned in a view with a filter on a calculated column

I'm having a strange issue and Google isn't helping me much in figuring out why. I have a custom list with 3 fields: Title Year calculated column =left([title], 4) single line of text Month ...
0
votes
1answer
46 views

How to apply a Date Filter on a list with JS

I have a Date Filter webpart connected to a List on page. I am setting the default value of the list with JQuery (it sets that value to the next Wednesday). Here's a jfiddle showing how we are ...
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 ...