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
1
vote
0answers
261 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
309 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 ...
1
vote
0answers
27 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, ...
2
votes
1answer
121 views

Custom Font Color for Completed Items in List

A part of my workflow writes the items over to another list where users can see their outstanding invoices that need approving. However, the workflow logic goes, the filter only proves false and the ...
3
votes
1answer
689 views

SharePoint REST filter items with multiselect field as null

I wanted to ignore items which have the multiselect field set to null. I used ne '' and ne null and none seems to work.
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
51 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
44 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 ...
3
votes
2answers
1k views

Show All Tasks Assigned to Me (including those assigned to Me and Multiple Users)

I have a Task List WP on my Site Page and I want it to show all Tasks Assigned to Me (my name is Jay Scott). This includes both of the following Tasks: TASK 1: Assigned to Me only, ex. 'Assigned to: ...
2
votes
1answer
2k views

Limit and filter List

I have a list with more then 100 rows, so I added limit to the url. I have two questions: How can I set it to not limit with no write a specific number (like 1000)? How can I add a filter to the ...
1
vote
1answer
59 views

warning while defining lookup to get single value from a list in workflow

While assigning value from another list to workflow variable with filter I get an error saying "The lookup that you defined is not guaranteed to return a single value. If more than one value is ...
1
vote
0answers
17 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 ...
0
votes
1answer
198 views

sharepoint search OR query with filter

I had the following query: https://[tenant].sharepoint.com/_api/search/query?querytext='Path:"https://one365dev1.sharepoint.com/teams/privegroep/Gedeelde%20%20documenten/*%22Isdocument=1"'&...
0
votes
3answers
82 views

filter list by one column using REST API

i want to filter a list by one spesific column. For exmple i want to see only when [City] = NYC. I tried something likr this: _api/Lists/getbytitle('EmployeeInfo')/items?$filter=City eq NYC But it'...
0
votes
0answers
80 views

SPGridView multi column filter issue

I have taken SPGridView Control and kept allow filtering as true. But I am not able to filter on more than one column. Any help would be appreciated Thanks
1
vote
0answers
120 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
234 views

SP 2013 : CQWP documents filter exclude/do not begin with

Good morning ! I have a really big question, and I found absolutely no good answer to it. I have a SP2013 on premise. I need to display content only by using Content Query WP (my client does not have ...
1
vote
1answer
425 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
2answers
17k views

How to filter SharePoint list column with username of the current user

I need to pass the current user name in the filter for Contains condition - Whenever passing [Me] it gives error: Filter value is not a valid text string.
0
votes
1answer
40 views

Filter listview from fields in attached edit form

I have a browser enabled InfoPath edit form with a list view web-part placed underneath the form. The form and the view represent two different lists. I know OOB they can be connected using only one ...
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 ...
0
votes
2answers
55 views

Filter webpart and consumer web part

I have a Customer filter web part tie to a list. and It's working good. and I have a order list web part. The set up is working fine. However, is there a way not to display any order data from the ...
1
vote
0answers
95 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 ...
3
votes
1answer
63 views

Filter by URL - not parameter

I know how to use parameters in content query web parts. Is there any option to filter a list by the site URL only? Like if I am on /customers/customer1 I would like to see details for customer1. The ...
0
votes
1answer
36 views

Filter a document library for distinct file names with file date >= Prior Month end

File List: 20170320_My FileName.pdf 20170320_Another FileName.pdf 20170313_My FileName.pdf 20170313_Another FileName.pdf 20170306_My FileName.pdf 20170306_Another FileName.pdf 20170228_My FileName.pdf ...
0
votes
1answer
283 views

Filter Search source/results by list's choice column

Hello Sharepointers, I've created a Discussion List, with a choice column where users must specify either Internal or External (our discussions will either cover internal or external issues). When ...
0
votes
1answer
16 views

Library seach boxes not showing for some users

I have a sharepoint library which includes a filter/search box for each field. The search boxes were built by a 3rd party so I'm not sure how they are programmed. They are view specific. These boxes ...
2
votes
1answer
7k views

Filter SharePoint List based on value from another list

Scenario: I have two lists. One tracking all the points an individual has amassed, another showing all the prizes that this person can win. I would like to display on one page, the total number of ...
2
votes
0answers
152 views

Issue while filtering multiple columns if one of the fields is Indexed

I have a list in SharePoint 2016 with over 35k items and around 15 custom Fields. I have a view that displays only around 300 - 400 items. When users filter the view using the column filters, the ...
0
votes
1answer
12 views

Is there a way to make filtered tasks show up as originally created?

I am using SharePoint 2013. My question is about the filter view for task list items. I originally created the task items as follows Job Vacancies Resume Review Interviews Job Offers However, after ...
1
vote
1answer
583 views

Using a parent site calculated field as a lookup source

How can I achieve the following: I have a parent site with a Contacts List. There are columns for "First name" and "Last name", and I made a calculated column called "Full name" to display them both ...
2
votes
1answer
4k views

Multi line text field in REST API filter url

I want to filter the field with data type Multi line text, but somehow am not able to filter that. I guess this didn't work as it contains html code within it, between the div tag my text appears. ...
0
votes
2answers
412 views

Passing multiple queries from a Web Part in order to filter a view

I am aware that using URLs like http://site/Lists/MyList/AllItems.aspx?FilterField1=Title&FilterValue1=ExactTitle&FilterField2=Year&FilterValue2=ExactYear will display a filtered view ...
0
votes
1answer
229 views

Search 'refiner' on first letter of sitename

In our SharePoint Online tenant, we use multiple site collections for teams and other collaborations. We want to make those site collections available via a search page on a site in the root site ...
2
votes
2answers
790 views

REST - how to get item ID and document name while filtering by a Lookup field?

I am trying to query a document library via REST and get the item ID and the document name. The query needs to filter on a (single value) lookup field. Originally I was using a CAML query to do the ...
0
votes
1answer
47 views

filter in document library [me] does not work?

I have created a document library on my site. Now i want only the user to be able to view the documents that he/she have placed in this library. I thought i could use [Me] But it does not work. ...
2
votes
2answers
1k views

SharePoint 2013 REST API - Is it possible to filter list by rich text column?

I have an query: _api/web/lists/GetByTitle(<LIST_TITLE>)/items?$filter=substringof('fddffd',richTextColumn) And it doesn't work. This error occurs: The field 'text' of type 'Note' cannot be ...
1
vote
0answers
149 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 ...
3
votes
2answers
470 views

SharePoint Rest API URL to filter records from list

I have list called Users. In users list, column called Age of type Number. Using Rest API I'm trying to get users whose age is between 50 to 100. I need only the URL to filter these records.
1
vote
2answers
1k views

Filtered lookup column

i have two lists, list A creates events, list B creates reports based on events on list A. I currently have a lookup field (in list B) that pulls the event name from List A, that way they can select ...
0
votes
1answer
292 views

Filter [ME] is not working after migration from Domain A to Domain B. Working for user with entry in Only Domain B

I am the primary site collection administrator on my SharePoint 2013 environment. I have a task list with a filter view: "assigned to = [me]". My own tasks show fine when I am logged in. However ...
0
votes
1answer
292 views

Check if parameter contains column value in filter for data view web part

I am trying to filter a dataview webpart using a parameter ($Users) which is a string of usernames delimited by a semicolon (domain\user1;domain\user2;domain\user3;domain\user4). This string is ...
2
votes
1answer
1k views

How to create a view thats filter a group or person type field

I have a Person or Group field called Teachers that I created in Infopath. It can contain only one user for the current project and it's not a SharePoint Group. How I can create a view to filter the ...
0
votes
2answers
332 views

Removing Duplicate Item Entries on a Calendar SP 2010

My calendar is currently set up where it shows all new items added to the list for the past 30 days. This works perfectly for the function I need, however, the only problem is that it does not omit ...
2
votes
1answer
1k views

Add a Filter for Date Range option in a list

Here is a little background on the task: My client has a sharepoint site that has a list of data. One of the columns or fields is a date field, this date is entered manually using MM/DD/YY Format. ...
1
vote
1answer
36 views

List still nearing view threshold despite filter

We added a filter to our list to avoid reaching the view threshold (original question was here: SharePoint List View Filter display 1 week) but despite the filter being active (currently the view is ...
1
vote
1answer
8k views

SharePoint List View Filter display 1 week

Our list has a view threshold of 20,000 items, which we usually reach every 12-15 days. Right now it's at 17,456 items and the oldest items are from December 7. So I want to create a filter to display ...
0
votes
1answer
75 views

REST filter executes first part of filter

I am trying to make a filter with REST, the code executes only the first part of the filter, here's my query: http://site/_api/web/lists/getByTitle('Data')/items?$orderby Created desc&$filter=(...
1
vote
1answer
1k views

how to filter a list by current user DISPLAY NAME

Background infomation In my company's Sharepoint website, each user account included two account infomations: user ID (DomainName\StaffID) and Display Name (DepartmentID/StaffName). Now I need to ...