Questions tagged [filter]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
163 views

Filter Dropdown values on List InfoPath

I have tried this example. https://social.technet.microsoft.com/wiki/contents/articles/32961.sharepoint-filter-dropdown-values-on-list-infopath-form-based-on-current-user.aspx But I came across with ...
2
votes
0answers
176 views

Filtered lookup based on lookup

My situation is this: I'm trying to set up a review site for the publishing house I'm working for. Basically, the editors should be able to pick reviewers for new books based on certain categories. ...
1
vote
1answer
128 views

Creating filtered lookup in SharePoint 2010 with InfoPath 2010

I have a requirement similar to this. https://www.sharepointusecases.com/2010/01/creating-filtered-lookups-in-sharepoint-2010-with-infopath-2010/ In my case Project field should be a text field and ...
1
vote
1answer
146 views

Creating a true master detail view using Search web parts

The requirements are: Search Result web part 1 shows all master elements ( e.g buildings ) , once a building is selected then Search Result web part 2 should show all equipment in that building. I ...
2
votes
1answer
310 views

Add filters/refiners to CQWP webpart

I am on SharePoint Online environment, As a high level summary, we currently have pages that use a PageQueryString as a filter for a CQWP. However, from the results that are displayed within the web ...
0
votes
1answer
547 views

Empty Filter Option display even no empty value exist

Empty Filter Option is showing in Person or Group column even when there is no empty value existing in the column. Is it normal behaviour?
0
votes
1answer
333 views

What are the limitations on a “single-line-of-text” column for sharepoint REST filters?

So, I am messing with my REST queries again, and was having some of these random errors. After some testing, it was determined that it appears that whenever a filter was applied to the title field, ...
0
votes
1answer
551 views

How to create a html form webpart filter for 2 list columns

I have a html form webpart (in the form of textbox input). I would like to filter 2 list columns using the same webpart: So instead of the usual filtering for 1 list column, this webpart will be used ...
0
votes
1answer
81 views

Filtering an asset library in Sharepoint 2010?

I've created an asset library with the headshots of several hundred of my company's employees. I want people to be able to search for the photos by last name and image type. I've added both of those ...
1
vote
2answers
860 views

Cannot filter in quick edit in Sharepoint 2013

I have a list which have a lot of data. I can filter list in standard view but when I use quick edit view, just some column can filtered. It's not display "show filter choice" when the column have too ...
1
vote
0answers
100 views

How can I change down arrow color in a filter header of a list

Hello, Above is the image of the header of a list that is filterable. List is a webpart in a sharepoint page. However the color scheme makes the down arrow barely visible. I cannot change the all ...
0
votes
1answer
263 views

SharePoint Online - filter lookup text field on new item form to current user

I have 2 lists: Traveler: Employee - Text (Ex:'Smith, John') Profile link - Url Travel Authorization Request: Traveling Employee - Lookup "Traverler:Employee" I need to apply a filter to the ...
0
votes
1answer
67 views

Textfilter with wildcards no results

I followed this tutorial SharePoint 2010 - Configure textFilter to but no matter what I search for (write a text, then press enter), I get no results. After a great deal of trial & error I can't ...
2
votes
0answers
57 views

Filtering a Web Part list using the current month viewed on a Calendar page

We have an Advertising Calendar which shows when our confirmed marketing events will happen. At the bottom of each month’s page, my boss would like a separate list web part that filters to show only ...
0
votes
1answer
28 views

How to creat view with special filter?

I would like to create a default, public view on a custom list, where the users have a default filter by creators, so everyone can see only the items what are created by him/her. So the filter should ...
1
vote
0answers
66 views

Get filtered projects list by applying filters on its fields SharePoint Online CSOM

How to get filtered projects list by applying filters on its fields SharePoint Online CSOM.(by using OData or something?) can it be possible using OData?
2
votes
1answer
250 views

Text Filter any List Column

When I add a text filter to a sharepoint page, it only gives me the option to connect the filter to a single column in a list webpart. How can I make the text filter operate like the OOB search bar ...
1
vote
1answer
355 views

SharePoint Designer CALL HTTP filter by choice field

In SharePoint Designer, CALL HTTP web service, is there a difference between filtering by single line of text vs. choice? I'm trying to filter the columns [ScheduleType] and [AccountStatus], which ...
0
votes
1answer
130 views

Is inplview.aspx api based on search in SharePoint Online?

I want to filter a large library in SharePoint Online using columns headers filters on managed metadata fields. I know it's also possible to use Managed Metadata Navigation in classic mode, but users ...
1
vote
0answers
216 views

Sharepoint Calendar View Filter - Show items in current year

I have events on my calendar that have Start Time dates in 2016, 2017, and 2018. I have a calculated formula on my Calendar list named Year Calculated Event - Current. The formula is =YEAR([Start ...
1
vote
1answer
81 views

How do i dynamically load a large list based on a filter?

I have written some javascript that generates a link with filters for a list of items. It has a couple of drop downs to choose certain filter values. This is all good until the list reaches 5k items. ...
0
votes
2answers
71 views

filter Document library based on metadata

Using SP-2016 I have a document library with 10K+ document and 12 metadata fields which is lookup columns from different different lists. to search specific genre of records, I want to filters that ...
1
vote
2answers
50 views

Display filtered list by category

The current script creates a table showing all Items from the list. e.g. In my list there is a column named 'Category' with 'Cats' and 'Dogs'. What I want to achieve is to FILTER and ONLY display '...
0
votes
1answer
84 views

Is there a way to set a default value for my Metadata Navigation and Filtering's Key Filters fields

I have a wiki pages library inside my SP on-premises 2013. And I have enabled the "Metadata Navigation and Filtering" site feature. Then i went to my pages library setting >> Metadata navigation ...
1
vote
1answer
1k views

SharePoint 2013 REST API Filter hidden Fields

I have a little Problem. I'm trying to do the following. There is a Field on SharePoint List items called HasUniqueRoleAssignments that is hidden on a standard REST call. If I put it in the select ...
3
votes
0answers
105 views

Construct CAML Query from ListView Filter URL-Params in SP2013

Im trying to construct a CAML query from the current Listview filter settings. I dont know in prior how many filters the user may set. My goal is to create a CAML query which has the exact same ...
0
votes
1answer
55 views

Filtered Lookup on Created By

I have two lists. First one is a Projects List and Second List has a lookup column to the First list. I want the lookup column on Second list to show only the Projects filtered by the column "Created ...
0
votes
1answer
13 views

How to create advanced fileters?

My users want to see how many items are created in 2016 in a list, but in the default filter they can add filter only day by day. Is there a way to make possible to add start and end date for the ...
0
votes
1answer
477 views

Filter Web Part - option “send all parameters” doesn't work

I am using Query String (URL) Filter Web Part for filtering items in list view. I followed offical guide where they are using multiple parameters for filters: Status=Elite&Status=Preferred In my ...
0
votes
1answer
87 views

Filter/Cascade list elements with a 'yes', 'no' and 'both' possibility

I have this field in my French-Canadian ParentList: 'Gender', with 'Male' and 'Female' as choices. I have another field in this French-Canadian ParentList: 'Position', which is a look-up field to a ...
0
votes
3answers
369 views

SharePoint - Calculated column filter shows formula instead of values

The List in the view displays calculated column values correctly, but when I filter the same column it shows the formula instead of values. How can I resolve this to show calculated values in the ...
0
votes
1answer
66 views

Hide list items based on results from another list (limited options)

Team, I have a very restricted Sharepoint environment; no access to designer no access to Filter webparts workflows limited to (1) Approval (2) Collect Feedback (3) Collect Signatures (4) Three-...
1
vote
1answer
261 views

My SharePoint Online Alert is sending an alert based on anything in the list, not the filtered items

I have a List with a one filtered view. I set an Alert on the list, hoping that the email would only show the items that pass the filter. But everything in the List is showing up in the email. Is ...
1
vote
0answers
32 views

Create a Key Filter from an External Data column

I'm currently creating a Document management system in On-prem SP 2013 to store documents with specific meta data terms so the document library is easily searchable/filtered. We have an external DB ...
0
votes
1answer
839 views

How can i filter the items in a lookup column within a document library based on values in another column

I want to know if it is possible to restrict the items in a lookup column of a document library based on another, related field in a separate table. We have a document library for each job site. We ...
3
votes
1answer
43 views

Holiday System - Show all team holidays to a manager

I'm currently building an automated holiday system for the company intranet. The issue I'm having is trying to find a way of managers to view their team members holidays in a calendar list. The only ...
-1
votes
4answers
772 views

pros and cons of using using the “FilterField1” & “FilterValue1” appraoch to build an advance search and filtering for my document library

I am working on a sharepoint farm 2013 on-premises. and i am searching for an appraoch which can allow me to build an advance search and filtering for my document library. currently my document ...
1
vote
2answers
348 views

SharePoint Foundation 2013: Is it possible to dynamically filter document libraries?

I'm developing a website and, as part of the specifications, I need to have a number of documents in a central document library, then only display a subset of them to the user at any one time ...
0
votes
0answers
335 views

Filter Custom List/ Document Library display via JQuery Rest Api

I tried using Api rest to filter the Custom list / Document Library display via jQuery , the script is working but the display of the list is not changing. Am i missing something? Thanks! function ...
1
vote
0answers
256 views

Custom predecessors column in custom list

I have a list of tasks, custom list template not task list, where I have lookup column on another list Projects, so my tasks are grouped by that lookup column, by Projects. I added predecessors ...
1
vote
1answer
338 views

Filter a list based on two due date columns

We have a list in SharePoint 2013, which we want to filter based on two date columns. The due dates refer to two different tasks. We want to see only elements with due date within the next 7 days og ...
0
votes
1answer
1k views

InfoPath and SharePoint - Filtering lookups

I have three SharePoint lists based on the below examples:- ListCountry CountryName : Single Line of Text ListCity CityName : Single Line of Text RelatedCountry : Lookup [ListCountry:CoutnryName] ...
2
votes
2answers
150 views

Only show users filled in values in a Choice field

I have several libraries, containing each a Choice column with several standard values. To each value there is a view which filters on the particular value. The users can also specify there own ...
3
votes
2answers
771 views

SharePoint Online Image library with metadata collumns

I am experiencing an issue with metadata. I have an Image Library that has around 8000 files. I had uploaded them with metadata for some custom collumns. I did create a few views filtering with that ...
3
votes
2answers
101 views

SharePoint list filter web part disappears once I add it to my wiki page

I don't know why SharePoint list filter web part doesn't show on the page once I add it. I opened web part in maintenance view and it is there, but not showing on the page. I appreciate the help.
3
votes
1answer
2k views

Filter Hyperlink field url using SharePoint REST API

I want to filter Hyperlink filed URL using REST API in SharePoint 2013. My URL is like below is working fine https://<siteurl>/_api/Web/Lists/GetByTitle('Pages')/items?$select=NavigateURL/Url ...
0
votes
1answer
53 views

Choice Filter returns no results for calculated column

I'm trying to implement a Choice Filter Web App to filter the shown list entries based on the selection within the Choice Filter. My list contains the column Product Version which is of the form XX....
1
vote
0answers
254 views

Avoid threshold limit with view using “Or condition” on person columns

Here is my issue: I have a sharepoint 2013 list with more than 5 000 items inside. In order to avoid threshold limit I indexed several columns and created views using these columns. Most of the views ...
1
vote
2answers
303 views

Item Level Permissions and Lookup Columns

I'm trying to build a simple Garage Management System to see what spot someone is assigned. So I have the following lists: Garages Levels Spots Spots has a lookup column to Levels, Levels has a ...
1
vote
0answers
52 views

Server error “/” in the application SharePoint 2010 when filter option is clicked in list

Have an error with a user on SharePoint, when user clicks on the filter options on SharePoint 2010 list the error below appears, it is not consistent but does happen regularly. Any ideas? Thank you ...