0
votes
0answers
3 views

Pull items from a column in order to populate filter options?

I have a column, participants, which is capable of including any one of 250,000 people. I expect the column to only be populated with 10-15 different names, but as people will join and leave the team, ...
0
votes
0answers
15 views

SharePoint List Query Customisation

Is it possible to use SharePoint list query web part with parameters? So for example if I have a list which contains product codes, another column in the list will define whether each item is an ...
0
votes
2answers
34 views

Autopopulated list column with values from another column?

Please let me know if there is an easier way to do this.. I am attempting to perform an "OR" filter. I need to able to search a list by either the Title column or the Description column. I'm using ...
2
votes
1answer
16 views

Filtering a grouped list via the URL - Rows excluded from the filter showing if group contains filtered rows

I am attempting to filter a list that is grouped by a field using parameters in the URL. My url is ?FilterName=Status&FilterMultiValue=Approved;Review As far as I know, this should return the ...
0
votes
0answers
17 views

Total count of filtered list via webservices

In SharePoint 2013 I use a webservice to query a list: System.Xml.XmlNode node = myservice.GetListItems(listName, viewName, query, viewFields, rowLimit, queryOptions, null); I use CAML to apply ...
1
vote
1answer
24 views

How do I change the web adress of a list?

I deleted a default list view and the web adress didn't change with that. So now it search for List/Old.View.aspx even though Old.View doesn't exist. This makes the site unavailable. How do I point ...
0
votes
1answer
30 views

How do I use the filter web part to sort out specific types of data from a list?

I am creating a landing page and was wondering how the filters works. Specifically, I want lists to be filtered depending on the user's permissions. So a user with contribute permissions for group A ...
0
votes
0answers
20 views

Filter Current User - Me (hierarchy)

Is it possible to have a [ME] filter that allows anyone higher up in the user hierarchy to see items? For example I have the Team Leader who can visualize a list view in SharePoint, but I want that ...
0
votes
1answer
102 views

date filter of today in rest api

I have a caml query filter for one of my date-time field. <Leq> <FieldRef Name ='StartDate1' /> <Value Type ='DateTime'> <Today /> </Value> </Leq> Is ...
0
votes
1answer
91 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
1answer
118 views

Displaying Calculated Column hyperlinks as text in filter drop downs

I have a list which has employee IDs as a field. I then have a calculated column which takes this field and uses it to link to our company-wide employee directory. This means I can hide the employee ...
1
vote
2answers
150 views

Sort and Filter Rich Text

i have a sharepoint list with a few rich text columns but in the view the headlines of these doesnt have the button to sort or filter them like all other non rich text columns have. is there a way to ...
1
vote
0answers
26 views

Meta data navigation filter on custom page?

I have a public facing website were i want our customers to be able to browse all our support documents using the Meta data navigation filter, but i dont want them to access the real document page. Is ...
0
votes
1answer
83 views

Display list content in editable form, filter on [Current User]

I have been trying to develop a set of pages that each has a form on the page where the user can type a response to questions on each page, and the form is saved when they submit it. If the user ...
0
votes
1answer
140 views

How do I filter a Document Library based on the value of a column in a related List

I'm using SharePoint 2013 (Office 365). I have created a List to store details of our Projects. The Project list has a column which stores the current status of the project. This is a drop-down field ...
1
vote
0answers
115 views

how do I create search in sharepoint list edit form using infopath

I have a list called Tasks in sharepoint 2013 that has a number of lookup fields. It was initially created by exporting data,tables and relationships from Access 2013. The client wants to be able to ...
2
votes
2answers
3k views

How can I filter a SharePoint list based on a date column?

I have a column with "start date". I also have a column called "expire date". How can I make a filtered list so that it only shows items where the "start date" is equal or greater and equal or ...
1
vote
1answer
117 views

Passing employee id from AD to a SharePoint list

I have a property named EmployeeId in AD. UPS is configured and is getting all users EmployeeID from AD. I have made an external list. I want to pass logged in user's EmployeeID to that list so it ...
1
vote
1answer
61 views

How to get value of multiple list filter webparts

Related to the previous post about accessing a List Filter Web Part value How to get value of List Filter web part in Javascript? How do I get access to the value of multiple list filter web part ...
1
vote
1answer
271 views

Filter Sharepoint 2010 List with Duplicate Items

I have a list that is being used for document control. The list contains multiple items with the same Title as well as other columns. It also contains a manual revision column I would like to display ...
0
votes
0answers
68 views

List Filter - Show “(Empty)” value, not working

So i have a List Filter web part connected to a list in a web part page. Show "(Empty)" value is checked, but when I select it in the filter it sometimes doesn't work, and the list stays filtered. ...
0
votes
2answers
51 views

Looking up a list 2007 Sharepoint

I am trying to devlop a search function on a list. It is a parts list that has the following headings:- Stock Number, Name, Colloquial How can i search in any of the fields by partial parts of a ...
1
vote
1answer
410 views

Multiple filters on view not working

I have a list on which I am applying the following filter (on a view) but it is not working. if((workflow == 16 && status == published) || (workflow == 2 && status == expired)) ...
0
votes
1answer
482 views

Filter not working when I create custom view (screenshots attached)

I have a list named "Test". On this list I enabled approval workflow named "Test". If you take a look at screenshot below which shows "All Items" view you will see 3 items, 2 approved and 1 ...
0
votes
1answer
67 views

List filter error after migration from SharePoint 2007 to 2010

I have this problem after the migration from SharePoint 2007 to 2010 : When i try to filter a list from any site there's an Internet Explorer Javascript Error "_layouts/filter.aspx" permission denied ...
1
vote
2answers
115 views

How to connect two lists and produce customized reports

I have two lists. The first list, 'Suppliers', is a list of suppliers with the various contact information. The second is 'Ratings' this contains a lookup of the supplier name and various number ...
0
votes
1answer
65 views

Filter Lookup from another lookup

I have a list of projects. Inside the project list you can select a Client. I have a list of Clients. I have another list, a list of Contacts, they have a lookup column called Client to specify from ...
0
votes
0answers
162 views

List filter “Show Filter Choices” causes unexpected request timed out exception

According to this article: http://sharepoint.nauplius.net/2010/09/sharepoint-list-filter-problems-or-show-filter-choices/ When a list has more than 500 items, the filters automatically switch to ...
0
votes
1answer
295 views

Filter large SharePoint 2010 list by lookup column

I have a list with 10,000 items. The list view threshold is 5,000. The list has an indexed lookup column. There is a view that should return about 400 items: My Column (indexed) is not equal to ...
1
vote
0answers
40 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
1answer
98 views

How do I set FilterOperator1 in the URL?

I know I can filter a SharePoint list by adding ?FilterField1=fieldname&FilterValue1=value to the URL. Microsoft's documentation also lists a property FilterOperator1 that you can use if you want ...
0
votes
1answer
79 views

List view on subsites with filtered choice field

I have a site with a list of projects. I then have multiple subsites which represents all the companies. I need to have a page on each subsite that contains the projects list with a specific view. ...
0
votes
1answer
141 views

Filtering Web Part on Lookup Field with multiple values

I'm looking to be able to filter a web part to show multiples values, based on a field in another web part that contains multiple values. The scenario I'm testing is: In a school environment, the ...
0
votes
1answer
31 views

Can a calendar popup be added to a list's date filter instead of a list of text choices?

How would I replace the OOTB list date filter dropdown to be a calendar view instead? JQuery/Javascript solutions are feasible for me if it is indeed possible. So far looking at the page tags upon ...
0
votes
3answers
831 views

SharePoint 2007: Filter for current year

I have a list view web part and a field named [Year] set as a number. I am trying to filter to show this current year's items, given today's date. I tried the following filter but get Filter value is ...
0
votes
2answers
64 views

filter with url: should be very easy but doesn't seem to work?

This is really weird as it seems so simple to me, but just won't work. myserver/site/lists/ExampleList/AllItems.aspx?ID=133 isn't this the basic url filter to only show that item? it does work ...
1
vote
1answer
180 views

How do i create a static text filter on a list webpart

I would like to use a constant as a text filter on a SharePoint list webpart. I can add a text filter and use it to filter the list successfully, but I don't want a control and I never want to change ...
3
votes
1answer
1k views

Use one filter for multiple sharepoint lists

Can I define one list filter, and connect it to two lists on one web part page? I have two seperate lists on a page, both containing the 'author' column. Now, I want to add a filter to de page, so you ...
0
votes
1answer
1k 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 ...
1
vote
3answers
2k views

Filter one list depending on selection in another list

let's say I have one list with my company's departments and one list with all employees. My list of employees has a lookup field to select the department. Now I want to have one page with a list of ...
0
votes
1answer
286 views

Allow users to filter a list using text input on SharePoint Online

I have a requirement to allow users to filter a list by entering a search string. I've been following the guide here: ...
4
votes
2answers
3k views

Filter People and Group column using [Me]

Our list has a people and group column (called Users) which we want to filter using [Me]. It works when the field only contains individual users, but when the field contains a group (either SP group ...
0
votes
2answers
2k views

Add Listview of parent site list

i want to add a page where users can view and edit a list, problem is the list is not in the site but rather in its parent site. I also want to be able to filter the list so they can only see a items ...
0
votes
1answer
2k views

Query String, Can I show single item from a list using a query string?

Used this to pass a value to a form, but can I use a query string for a single list item ID, provide to users and have that filter a list for me? Or do I need some CQWP that takes a parameter from a ...
1
vote
0answers
25 views

Is that possible to filter and display the lookup values? [duplicate]

Possible Duplicate: How to make a filtered lookup field I am using project list lookup field in task list, so my project have # of items, but i need to restrict some of the project like if ...
0
votes
2answers
2k views

Filter list by multiple possible values

I want to filter list by multiple possible values of one specified field, how can i do this in code? I have following lists: Initiatives, Classes of Initiatives and Departments. I need to retrieve ...
1
vote
3answers
3k views

Page a list via A-Z

So I am trying to create an a to z directory from a list of items which should be an easy task and it is really, however, I am trying to find the most efficient way of doing it. So I was thinking use ...
1
vote
1answer
2k views

Filter Multiple connections List (no-code solution)

I have a mission to create a filter for any field of my list, there are many. The connection is just made in the first filter, I cannot connect more than once... I've searched for code which would ...
0
votes
2answers
4k views

How to apply 2 different conditions in the filter of list?

I have two different conditions based on which I need to apply filter on the list data. The conditions are based on the user role and status column. I have applied the filter condition as : ...
0
votes
2answers
256 views

increase List threshold or Custom Filter?

I have a list over 200,000 items in it. It's on normal threshold (2,000 items per view). Users want large threshold but there is price for that. SQL traveling/transaction, server overhead and the ...