Questions tagged [filter]

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

311 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
1answer
86 views

Problem with date range filter

I have implemented date range filter on my SharePoint 2016 list using date filter web part. The complete procedure you can find here But after this implementation my list search box vanished. Even ...
1
vote
0answers
62 views

I need to dynamically filter Sharepoint 2016 calendar. Is it possible?

I am using sharepoint calendar, but I am stuck at one scenario. I have Team column in my sharepoint list, I need to dynamically filter calendar view based on selection of values in Team dropdown list. ...
1
vote
1answer
51 views

local document link to sharepoint list

I have file a server with huge size (more than 50 TB). What my manager want is to create a search on these document from SharePoint with metadata filters (not content search). Basically what I am ...
1
vote
0answers
35 views

SharePoint 2016: filter on managed metadata column with AND operator

We are using SharePoint 2016 and have a document library with a multiple managed metadata column. In this document library we try sometimes to filter on this column. We can select 1 or more terms in ...
1
vote
0answers
170 views

Modern page: Show FILTER PANE in Library webpart. Possible?

I am using this modern "filter pane" in my library, but when I use a Document Library Webpart to show this library as part of a page, the filter pane is not present. How can I show the Filter Pane ...
1
vote
0answers
83 views

Filtering SharePoint List by Another SharePoint List

I've been searching the forums and doing research online with no luck- apologies if this has been answered before. I have a list with several thousand items in it. I often receive bulk update ...
1
vote
0answers
21 views

How to Get User-Generated Columns from Ajax

Is it possible to determine which columns in a SP List or document library were custom generated by the user? I'm essentially trying to recreate SharePoint's front end in my app, and I want to add ...
1
vote
1answer
40 views

List Filter in Look up

I have a list which contains a column for Name and a column for Department I'm building a secondary list which will contain two look up columns. These looks ups will display the Name column from the ...
1
vote
0answers
25 views

Linking to a webpage with a search function and auto filtering that function

In my company, there is a SharePoint site with a page with a search box on it. Underneath this box are two separate web parts, showing two separate lists. The user is asked to enter a value into the ...
1
vote
0answers
19 views

Sharepoint 2013 wiki template with web parts

We're on SP2013 site collection. I'd like to create a template for the 200 different profiles we have. Each profile consists of: 1. wiki for tables and unstructured data, 2. wiki columns (display on ...
1
vote
2answers
152 views

View filter on multiple AND/OR combinations

I'm trying to set up a view to filter on column Status (options are "WIP - Drafting", "Eng Check" and "Peer Check") and the name in columns "Drafter", "Eng" or "Peer". Any one of the engineers could ...
1
vote
1answer
220 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 ...
1
vote
2answers
1k 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
135 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 ...
1
vote
0answers
72 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?
1
vote
0answers
221 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
111 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. ...
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 ...
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 ...
1
vote
0answers
294 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
0answers
304 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
0answers
53 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 ...
1
vote
0answers
28 views

Filtering Many-to-Many-to-Many

What I Need: I'm trying to use OOTB features, with as little custom rendering / SPFx / customization as possible. I've got 3 list: Members, Classes and Sponsors. Each Member may be in many classes, ...
1
vote
0answers
27 views

Linking a form to a button

I have created a form in InfoPath that is stored on a SharePoint site. I have added cascading filters that filter the projects by using a SharePoint list as a data connection. What I want to do is ...
1
vote
0answers
53 views

Conditionally Filtered Autocomplete Script based on another Column in a Form (SPO)

I am using the script below to autopopulate a text column called 'RelatedPeople' (Both Internal and External Column Name). The script pulls from the 'Title' Column of the 'People' List. I was ...
1
vote
0answers
48 views

Date range filter in OOTB for SPListview

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
0answers
18 views

filter on specific field when completing task

i have a questions regarding filtering options. i have build a very usefull solution in SP, all based on knowage from this forum, but now I as stuck. i have created a list, with multiple recipients ...
1
vote
0answers
124 views

Connect SharePoint 2010 date filter web part

I have used the date filter web parts to filter the SharePoint list. Here filter is getting applied on change of date.. Can we add a button and run the filters only on button click? Can we change the ...
1
vote
1answer
473 views

filter list using SPServices

I have a list with the following fields (Title, Area, Zone, Reference, qtt). I created two "select" tags for the area and zone fields. I also created an "input" tag for filter field reference. I am ...
1
vote
1answer
73 views

Create REST call from search query

I have a search query web part that I am running that looks like the following. (path:"PATH TO FOLDER" AND ContentTypeId:0x0120D520*) This path contains links to document sets. I am trying to ...
1
vote
0answers
102 views

Filter styled list webpart using XSL stylesheet

So I have .css and .xsl code turning an out of the box SP calendar list into a pretty events list. I have a different image for each month and my code is long but works perfectly. I also have a ...
1
vote
0answers
151 views

SharePoint 2013 Foundation Sort Filters Values on Column

Problem I have a date field, where there are lot's of dates to filter by, but I would need, that they'd show in different order. Originally they are sorted oldest first, but I would need to turn it ...
1
vote
0answers
174 views

SharePoint 2013 - Column Filtering

I have a question about odd behaviour with column filtering on a List in SP2013. I have two columns in my list that I want to be able to do adhoc filtering on. Columns: Year: Managed Metadata type, ...
1
vote
0answers
65 views

Custom list view filter not working in mobile view

I had to filter sharepoint list view dynamically with n number of conditions so I have written the code in PageHead delegate control. Everything works fine on browser but when I try to check the same ...
1
vote
1answer
438 views

How to filter by content url in CQWP

I'm looking to filter items in a Content Query Webpart by URL, e.g. URL contains this particular string. URL is not available in the list of fields though. Specifying 'FilterField1="URL"' in the ...
1
vote
0answers
675 views

How to use wildcard filter url with a list webpart

So I've been using url to create custom filters. Users can so customize their filter trough a form and with javascript i'm updating the url so the list webpart is filtered. The only problem is in a ...
1
vote
0answers
27 views

Filtering on username doesn't give unique users

I have a list where I'm able to sort on different parameters. One such useful parameter is the currently logged in user, like a "My Tasks" kind of thing. But the problem is that if there's another ...
1
vote
1answer
431 views

Method to get list headers & filters via jQuery SPServices CAML GetListItems or similar?

Is there a method similar to GetListItems to grab the column headers and/or filters for a list? Or a way to use GetListItems to get that information?
1
vote
0answers
27 views

Lookup column that auto filters bases on site pages.

I'm building a form that surveys user's opinion of the page the page viewed by the user. I have a list with a lookup-column that gets the ID from site pages. I'm looking for the ID to be ...
1
vote
0answers
37 views

Expand Fields and Items in one call and filter the expanded

What i am trying to do is to get all lists and from all lists expand fields and items. Then filter some fields, and get all items (and not only first 100) /_api/Web/Lists?$select=Title, Id, Hidden&...
1
vote
2answers
3k views

SharePoint Calendar view with Query String Filter

I need to create two custom columns inside SharePoint Calendar List and I need to apply Filtering to calendar view with regards to custom columns for the users. I need to apply the same using default ...
1
vote
0answers
52 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
81 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
0answers
59 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
0answers
677 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
370 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 columns: ...
1
vote
0answers
128 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
0answers
55 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
101 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 ...
1
vote
1answer
234 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 ...