Questions tagged [filter]

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

304 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
58 views

How I create a View for more lists?

It is my first question and I a noob in Sharepoint but I get a task to set a view for a list. I explain the idea. Our company has a teamsite where we can see who have task and who do this task. Now ...
1
vote
0answers
83 views

Filtering Multi-Selection Lists

I am having trouble filtering a multi-selection list, and I think the problem is with the reference to the current item. I need a way to reference the item that the filter is being checked against (...
1
vote
0answers
201 views

InfoPath current() Function in Multi-Lists

When you call current() from a multi-selection list, where does it resolve to? I ask because I need to use it in a complicated filter to control what values are present in the list. Has anyone used ...
1
vote
0answers
117 views

Customize Filters in Document Library

We got several document libraries which has a column type. This like all other columns can be filtered by values that is inserted on the document library. In Type, we got file types like doc, docx, ...
1
vote
0answers
322 views

Sharepoint Webservice not filtering Data

Working Version Issue: I am querying SharePoint using SP CAML Query Helper. Using SPCQH I am able to retrieve one order. The query works. Once I add the query to my Biztalk solution the query below ...
1
vote
1answer
442 views

Filter a parent list by a particular child list item's lookup field value

I have two lists, Activities and Objectives. The Activities list has a multi-value lookup field that references the Objectives list. I am trying to create a filtered view on the Objectives list that, ...
1
vote
1answer
213 views

Looking for a customized filter webpart for sharepoint online

the filter webpart is too weak in sharepoint online. I am looking for a customized filter webpart for sharepoint online. I tried to find the vendors but they all can only run on server, not ...
1
vote
0answers
131 views

Sharepoint Dashboard Designer 2010 Filters and All Total Values

I have an Analytic Grid that has a column with values (for example) {Cat, Dog, Other}. Each of those items have a number associated with them. For example, cat is 10, dog is 10, and other is 2. In ...
1
vote
0answers
319 views

SharePoint Document Library Column Header filtering issue

I have a document library with close to 5000 docs. When signed in as a site collection admin, applying filtering via column header on a column that contains only 20 unique values works fine. However, ...
1
vote
0answers
196 views

Webpart Filter on Infopath Form Library

I have a webpart page that displays an infopath form, with the associated form library in list view next to the form. I'm trying to create a Sharepoint List filter webpart to show only forms with a ...
1
vote
0answers
516 views

How to copy Assigned to field from list A to List B on creation of item in List B?

Trying to solve a problem with moving data from one list to another. I have 2 lists. 1) a project list that contains Project info (project ID which is text, name, lots of details, and an "Assigned to"...
1
vote
0answers
179 views

Column filter values

When you view a list/library in SharePoint you have the ability to filter on a selected column. For instance, you have a column called "Food" and you may want to filter the results based on a value ...
1
vote
0answers
637 views

PageNumber-Fillter for Finder in .Net Assembly Connector

I'm currently trying to use an PageNumber-Filter for an Finder-Method in an .NET Assembly Connector. The relevant Part of the Method-Definition of the ReadList-Method looks the following. <Method ...
1
vote
1answer
595 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 ...
1
vote
0answers
171 views

BDC Lightning tool on MOSS 2007. Using BDC in Picker and filtering

I've got a BDC I generated with BDC Lightning BDC Man. I added a BDC column to a list and when I open the address book picker I get the first 200 entries but search/filter does not work. Anybody ...
1
vote
0answers
555 views

How do I change the date filter format in the Data View Web Part toolbar?

I have added a toolbar to the DVWP and enabled the Filter option. When I click on the filter, the Due Date field displays choices as Saturday, September 11, 2010. Within the DVWP I have the format set ...
1
vote
1answer
69 views

Need Help with SharePoint List view weird behavior?

I have a list in SharePoint online and I am trying to filter using the registration numbers and want to display all the registration numbers greater than 3000 (3001-3600) on a view. The total number ...
1
vote
2answers
81 views

Refine discussion list

I am using a Community site and I need to refine my discussion list. I added a column with multiple choice. I would like to add a combobox with the possibility to filter for that column. How can ...
0
votes
2answers
15 views

In SPO list why would FilterFieldX/FilterValueX work while FilterName/FilterMultiValue is ignored?

I am using a custom list with standard OOB AllItems.aspx view using the modern experience. (NOT a web-part, NOT the classic experience) When I filter using .../AllItems.aspx?FilterField1=...
0
votes
0answers
11 views

Filtering a list by input date between 'start date

I have a MeetingTopic list (things to discuss at a meeting), with a StartDate field and an EndDate field. I am trying to create a page that takes a date parameter (MeetingDate) and presents all topics ...
0
votes
2answers
21 views

SharePoint CSOM list group by and filter

I have a list with columns "fruit" and "ripeness". Using csom, how can I return "Banana" where Yellow count >= 3? ClientContext ctx = new ClientContext("https://sharepoint.blah.com"); List list = ctx....
0
votes
0answers
12 views

how can i filter a list in a view on a page without breaking pagination?

I have an app part placed on a page in which i want to filter the data in the list to show. The data needs to be filtered by multiple conditions. i have most of the filtering done, but filtering by ...
0
votes
1answer
21 views

How To Apply filter to List View Web Part based on content of Data View field

I am building a project management tool. the top of each project page shows a List View webpart which displays information about the project's current status. A second List View displays a Task List ...
0
votes
1answer
19 views

Use image icons to filter library view web part

We are on SharePoint O365. I have created a wiki page on a classic page setup. On that page I have placed several .gif images and the library view web part. What I'd like to do is filter the ...
0
votes
1answer
20 views

document-set filters?

I have a library with multiple document sets, each of which has custom metadata. I want to create a filter for use within doc-set A that filters on A's custom metadata, and a filter for use within doc-...
0
votes
1answer
26 views

Custom List Header Column Sort/Filter

I'm trying to re-format the sort/filter drop down box on the column header of a custom list (font-family, font-size, background etc). This appears to be possible by using the following rule in a ...
0
votes
0answers
22 views

Odd Behavior for Rest API lookup Column filtering

I've recently been working on a project requiring Rest Queries against a large SharePoint list (5000+ items) and ran into an interaction I can't quite find an explanation for. The scenario is that I ...
0
votes
0answers
19 views

SharePoint Refinement Filter Display One Column and Sort by Another Column

I have a refinement webpart on a search page with several refiners. The issue I am having is that I need to sort the refinement filters based on another column or some other way to perform a custom ...
0
votes
1answer
18 views

Filter Event Calendar by Column

I have a SharePoint calendar that I have added a drop down column called SalesAgent, which contain Sales Agent names that is selected when event created. Each agent has numerous events on a calendar. ...
0
votes
1answer
13 views

Creat a view with Sharepoint List: Sort by column then filter everything but the most recent

I have a list coming in from forms with a serial number and a date: [Serial Number] [date] a-6/10/19 a-6/12/12 a-2/4/14 b-3/2/15 b-4/1/12 I want to create a view where I only display the most recent ...
0
votes
2answers
38 views

Exporting a list to csv from a custom page

I have a custom page created to allow users to be able to select their own parameters to filter items in a list using web-parts (with help from SharePoint designer 2013). This filtered list needs to ...
0
votes
2answers
22 views

Turn Title bar filters on at all time

We have a number of custom lists, and on some of the larger ones the sidebar popping up is undesirable. We added Filter=1 to the links to the lists which turns on the filters at the top, which is ...
0
votes
0answers
11 views

Losing CQWP filter “Contains all of” when applied/saved

I've added a CQWP to a web part page. In the web part properties, the source is from a single list, and i'm trying to add additional filters. If the second or third additional filter is set to "...
0
votes
0answers
29 views

SharePoint - Infopath - Lookup Field - Filtering Out Items

I'm working with a SharePoint List (we'll call it List A) that has a lookup field to a second list (List B). List B has two fields: REPORT_NAME & RETIRED. RETIRED will either be blank or have an '...
0
votes
0answers
26 views

Filter Secondary data source based on two filter values - Infopath

I have fields 'Project Description' and 'Stage' in my secondary data source and also 'ProjDesc' field in my main data connection. I am trying to filter my secondary data source when 'ProjDesc = ...
0
votes
0answers
17 views

Filter not working in List created from template

We use a list template to create new Lists in our SharePoint 2013 environment. Everything works, but when we try to filter 2 values from one column all elements are displayed again (see screenshots). ...
0
votes
0answers
18 views

Filtering a List View with multiple conditions

I have a view I am editing in SP Designer 2013 and I keep getting a "Cannot complete this action. Please try again.Correlation ID:d47ecb9e-10f2-a0dd-4e30-aaddb657494b" error. My desired filter: (a &...
0
votes
0answers
67 views

Filter File types from Folders/Files

I am able to pull in the data I need with using part of this sEndPoint Main folder I'm pulling from: https://company.sharepoint/sites/Site/_api/Web/GetFolderByServerRelativeUrl('Folder Name')? ...
0
votes
0answers
93 views

Filtering view and workflows for lookup columns

I have 2 lists with the following columns: List A - "Status" (choice column)/"Name"(Single line)/"ReqNr(Number)" List B - "StatusNameReq"(Lookupcolumn based on the columns in List A) Now, I want to ...
0
votes
0answers
264 views

Quick Chart Web Part - Data From SharePoint List Confusion

In SharePoint Online, I can't seem to get my quick charts to work or display the data I would like. The Column that has data to display option seems to just grab columns with numerical values. Is ...
0
votes
1answer
62 views

Search SiteGroups API not working when case sensitive

I'm using the API to search for sitegroups as below: "/_api/web/SiteGroups?$orderby 'Title'&$select=Id,Title,LoginName" + skiptop + "&$filter=startswith(Title,'" + value + "')" However, I ...
0
votes
0answers
10 views

“Shaded” Custom List View Class?

Good Afternoon; I am using JQuery to filter a Contact List. The code I am using is attached below. This code works with the default view, however does not work with Shaded View. Does anyone know ...
0
votes
0answers
15 views

Sharepoint Dataview URL Filtering and “Day 1” not working, other “Day n” works

We have a SharePoint site with a DataView. We are filtering the list by a field. The field is a Choice Field with the options "Day 1, Day 2, Day 3". When we put in SitePages/Next%20Month-End.aspx?...
0
votes
1answer
227 views

SPO modern list view with multiple filters not filtering list

I have run into an issue where I create a view with the filters in the image below (the list is a modern list in SPO converted over from 13' to SPO by share gate). The issue is that I continue to see ...
0
votes
1answer
44 views

SharePoint Task List filters

I want to add filter on a workflow task list if the task is duplicated (same title with different ID) to show one item per task (show only the most recent one). How to achieve this?
0
votes
2answers
52 views

Filtering List Data

I have a small requirement where in i want to filter the list data based on some columns but i cannot wrap my head around the Rest Api Query. So, i want to filter data based on few columns which are ...
0
votes
1answer
18 views

In SharePoint Online, is it possible to filter a standard View based on the documents that specific group(s)/user(s) have been granted access to?

I'll be creating sensitive financial documents for 20 locations worldwide. I'll stop inheriting permissions and granting permissions at the file level. I would like the permissions I grant for each ...
0
votes
1answer
23 views

Auto assigning from one list to another

I'm trying to set up a reservation for cars in my agency. I would like to try to auto-assign these cars based on what is entered from another screen. Once I find an available car, based on that ...
0
votes
1answer
65 views

Calculating the GROUP BY total in a SharePoint Column

I am trying to do something here, which I do not know if it is possible. I have a custom list in SharePoint 2010 where the "Course" name is unique. I am using "Group By" in the view which shows me ...
0
votes
1answer
19 views

Sharepoint online filter list not showing

I'm on SharePoint online and I have a list that a web part is calling from. I saved each group into a different view but when it comes up on the web part it is still showing "all" instead of the view ...