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

learn more… | top users | synonyms

1
vote
0answers
253 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 ...
1
vote
0answers
136 views

Current User Filter and List with Folder

I have some folders on the document library with office location in it. I created a page (list view webpart and current user filter) and used current user field property to match the folder name and ...
1
vote
1answer
485 views

How to filter a sharepoint list

I have a custom list called expenses. The list has fields such as user,date,amount etc. I want the user to be able to filter this list by amount e.g. add a dropdown above the list with a search ...
1
vote
1answer
223 views

SP 2010 REST $filter column

I'm trying to filter a list using the REST service. The column im trying to filter is the default column "Modified". My problem is: I can get all itens created today, but not only the items created ...
1
vote
2answers
214 views

Can i filter folders to show on different views

How can i make it so that certain folders appear on different views? ex: View 1 (Folder A, Document A1, Document A2, Document A3) View 2 (Folder B, Document B1, Document B2, Document B3) View 3 ...
1
vote
0answers
309 views

Custom filter provider web part and multiple values

I'm trying to build a custom filter provider that can detect the user language (the language selected in SharePoint by the user) and provide it as a filter. As a language can be represented in many ...
1
vote
0answers
26 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 ...
1
vote
1answer
3k views

How to add a custom filter for a chart?

I have a list which contains multiple columns. I have inserted the chart web part and it's showing the graph based on the column list. Now I want to add a custom drop down filter which contains column ...
1
vote
0answers
153 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
1answer
656 views

How can I Filter a Joined DVWP by [Current User] in Multi-User People/Groups field?

I have a joined DVWP. List A includes a "category" lookup field among other columns. List A includes the same "category" lookup field as well as a People/Groups field with multiple selections. I'd ...
1
vote
0answers
495 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
801 views

BDC List column picker filter - search/filter not working and exact entry says not found?

I'm working with MOSS 2007. Rephrasing the question. I have a BDC column to an external datasource in a custom list. Today searching and filtering is not in place and actually exact matches are not ...
1
vote
0answers
237 views

Filtering one List Part, by another Web Part, where the Second web part has a filtered View

I have one list, called "Company Reports" and another list "Companies" The Companies list has a field called Include(yes/no), and I have created a View which filters it to only show active companies. ...
1
vote
1answer
482 views

Display connection information within a ITransformableFilterValues web part

I created a filter web part by extending the ITransformableFilterValues interface, similar to this page: http://msdn.microsoft.com/en-us/library/ms499375(v=office.12).aspx. I want to mimic the ...
1
vote
0answers
141 views

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

I've got a BDC I generated with BDC Lighning 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 know ...
1
vote
2answers
913 views

SharePoint Designer: CurrentDate CAMLVariable is incorrect to compare to date column

I am creating a simple form by "Insert Data View" web part and filtering on the data source by date. Something like: Displays all the announcement items that have: "Expires" Greater Than Or Equal ...
1
vote
2answers
683 views

Seemingly random (non-alphabetical) ordering showing up in List column filter options?

I am using SharePoint 2007 (MOSS) and I have stumbled across a rather odd issue. I have a list that has a Lookup column to another list, which works fine. However, when viewing the list and trying to ...
1
vote
1answer
536 views

How to Group DVWP Rows by a Joined Source Field?

I have a joined data source of 2 sharepoint lists and am trying to group by category and setup conditional formatting, yadda yadda yadda, in a DVWP using various fields within these lists. I'm able ...
1
vote
0answers
212 views

Multiple filtering weblog categories [closed]

I am building a Sharepoint 2010 weblog where each post can have multiple categories. I would like to know how to filter the ones that contain two or more categories at the same time! E.g. if there ...
0
votes
3answers
3k views

REST service $filter Date column

Using the REST services, I'm trying to filter by the Created column, which is a Date data type. When trying to $filter on that column, I passed in the same date format that comes back in the JSON ...
0
votes
2answers
65 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 ...
0
votes
2answers
169 views

custom functionality on page

I'd like some advice on how to create the following: My customer has a SharePoint site with an order list on it (just a regular sharepoint list). The orders can have an attachment. On the main ...
0
votes
3answers
4k views

Dataview, filter to see “All items”

I have two dataviews in a page layout. The first one display all the categories of items, and then second one displays the items based on the selected category. It work find with filters and Query ...
0
votes
2answers
2k views

Using multiple filters in a filter web part

I'm working on a filter web part inherited from another developer and it's the first time I've worked on them. It currently allows for a single filter and another filter needs to be added. Initial ...
0
votes
2answers
46 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 ...
0
votes
1answer
101 views

Filtered Lookup Field for more then one element

How could I do filtered lookup field for more then one element? I make for one Element by this link: http://howididit-sharepoint.blogspot.com/2012/04/filtering-lookup-columns.html But how could I ...
0
votes
1answer
120 views

Excluding specific files from Content Query

I have a content query web part that displays all the latest documents added to a site collection but there are one or two occasions where a file will be uploaded that the user doesn't want advertised ...
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 ...
0
votes
1answer
531 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
2answers
627 views

How to filter(search) a list

I'm not sure if this can be achieved with Filter or need to create a search function. I have a list with about 500 items with potential to grow to several thousand. I want to give user ability to ...
0
votes
1answer
306 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: ...
0
votes
2answers
975 views

How to add programmatically Sharepoint List Filter Wep Part?

I try to add Sharepoint List Filter Web Part to page. I'm not sure if it is Microsoft.SharePoint.Portal.WebControls.SpListFilterWebPart. How to add it to the page and configure? Update ...
0
votes
2answers
259 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 ...
0
votes
2answers
703 views

FullTextSearch: SPSiteDataQuery on each request vs. caching data and filter in code

I'm implementing a full text search on list contents. Is it more efficient to fire a SPSiteDataQuery on every request with a dynamically built CAML-Query, to filter the items? Or is it better to ...
0
votes
3answers
604 views

cascading filter in performance point server , sharepoint 2010

i need to create the cascading filter in performancepoint server. i dont know how can i do this.
0
votes
2answers
35 views

REST API OData Filter on Boolean not Working

When I perform a REST query to the following URL: _api/web/lists/getbytitle('BtProjects')/items?$filter=Active eq true I receive only the one item that has this field marked as false. I get the same ...
0
votes
2answers
36 views

How do I get a lookup column to filter in 2013?

I have data in page view that places the information for "project" in a lookup column. When I try to filter this column I get the error "this column cannot be filtered." How to I get this column to ...
0
votes
1answer
29 views

Use field in last item to filter the list view

I have a list which is updated about once a week with 50-100 new items through the use of Spreadsheet view and pasting from Excel. My problem is that I need to find what date when the list was last ...
0
votes
2answers
72 views

Multiple Filter Dropdowns on a webpart page

I am looking to set up three dropdowns at the top of a web part page that will allow the user to choose Week#, Region and Site in order to show a specific item (or items) from a Sharepoint custom list ...
0
votes
1answer
258 views

Filter Data View Webpart based on results of javascript query

I'm trying to dynamically filter the records that a Data View WebPart displays based on the return value of a javascript query. I would like some advice as to how I should do this or if it's even ...
0
votes
1answer
49 views

View filter settings: how to implement [TODAY] - 6 months

I am building a SharePoint 2013 portal. I have a custom list. On this list I try to modify the default view. I would like to change the filter settings. I would like to show only the items between ...
0
votes
1answer
181 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
2answers
270 views

The field 'Author' of type 'User' cannot be used in the query filter expression

I was making a rest api call with Odata filter author/id. I want to get survey responses of a particular user. ...
0
votes
2answers
36 views

How to change the text shown above filterwebparts in sharepoint?

I have some filter webparts in my site page. How to change or remove the text shown above the data filter webparts ? I have tried several ways, but its still showing the "FilterName" !! Any idea about ...
0
votes
1answer
897 views

Pass value via URL based on list filters

I have a list called "Stage", which has an Task list with a filter in the Displayform: If the user wants to add a new task to this specific item the newform for the Task appears. To be sure, the ...
0
votes
1answer
66 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
2answers
821 views

Filter one column with multiple value

Is it possible to filter one column with multiple values? It works in the Datasheet View but it doesen't work in the standard view. To add a new view with filtered values isn't an option.
0
votes
1answer
81 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
352 views

Filter Search Results Based On Link Clicked

I am using SharePoint 2013 and have links on the home page such as (Tax, Assurance, Advisory). Does anyone know how I can in SP 2013 use one search page but filter out the results depening on the link ...
0
votes
3answers
900 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 ...