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
147 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
1k 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
1answer
550 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
263 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
4answers
4k 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
81 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
32 views

Problem with many $filter parameters

The query below returns a 404 error because there are two many $filter parameters. Can I increase the number of $filter parameters permitted? How can I improve this query? ...
0
votes
3answers
366 views

Filtering Look up Columns with Javascript

I'm trying to find a way to dynamically filter a look up column on the new and edit forms in SharePoint 2013. I want to be able to get a value from the URL and use that to filter the look up ...
0
votes
2answers
857 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
173 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
3answers
100 views

Filtering REST call with lookup field

We have a column defined on a custom list that allows for multiple select of values from another custom list. The column on the list is call Panels. When I do a REST call against this list, I can ...
0
votes
1answer
32 views

How to check if title contains character

how could i check for all titles that contains 3 characters that the user types in var query = $("#subSiteTitle").val(); The value that the user types in must be length >2 So if the user types for ...
0
votes
1answer
48 views

Filtering a REST call with a View

I have a list in SharePoint I want to make a REST call to access it. I need to filter this list by an Alert Yes/No field. The field is called Alert and I try to filter it on "true" but the results ...
0
votes
1answer
34 views

How to write a view filter to show all pages created by me and have either “Pending” or “Approved” statuses

I want to achieve this , to display all pages that are assigned to me and have either (Pending or approved) statuses. But when I define the following, It will show all the pages that are rejected ...
0
votes
1answer
866 views

View Month and Year of Group calendar

I have setup a group calendar using this article http://absolute-sharepoint.com/2014/06/create-color-coded-group-calendar-sharepoint-2013-step-step.html Now I see all the users in week view with all ...
0
votes
2answers
92 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
219 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
203 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
55 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
1k 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
963 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
476 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
1k 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
276 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
765 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
637 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
1answer
17 views

Open in explorer view to show a filtered view of the list or library

I am looking at a filtered view of my library on my site so I am only seeing certain items. When I click open in explorer, I see everything in the library and my filter is no longer applied. Is it ...
0
votes
1answer
21 views

Filtering SharePoint List columns using a textbox (like filters in MS Excel)

I want to enable search on every column of a SharePoint List. It should work like filtering in Excel. User can type in the textbox and filter that column.
0
votes
1answer
29 views

SharePoint 2010: How to filter search results on a content type and a boolean column = true

I am using SharePoint2010. I have a search result webpart with a filter on a content type. I would like to append this filter with a boolean column = true. See below the current filter: ...
0
votes
2answers
101 views

How do I use SharePoint Rest API to query list for a field resulting in one row of data?

I've been able to pull data for a specific list, but unable to filter it down to one item, where the Field called "File Name" equals drugdealers. Any assistance would be appreciated. <script ...
0
votes
1answer
54 views

Filtering Custom List Items

I created a custom list then I created a webpart for custom list. I edit settings of the webpart. I created a new filter for this list. I clicked the "Edit Page" then I selected webpart. I edited the ...
0
votes
1answer
46 views

SP13: Filtering Default Calendar Start and End Time

I am working off of a list from a calendar. Within the calendar list I am to filter all event columns except Start Time and End Time field. See image below for a visual example. Does anyone know ...
0
votes
2answers
270 views

How to use an index with list view threshold

I have a list with 20,000 records that I have been trying to deal with. Threshold is at the default 5k. I was under the impression that if I index a column, filter on it, and my results are under 5k, ...
0
votes
2answers
51 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
48 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
143 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
875 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
410 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
555 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 ...
0
votes
2answers
38 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
1k 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
5k views

Filter by column WebPart in SharePoint 2013

I'm in need of a column filter web part in SharePoint 2013, more specifically said i need the web part to bring content of a list, library or calender based on a column in this list, library or ...
0
votes
1answer
87 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
1k 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
529 views

Items in folder not showing after filtering

following situation... The goal: i have a document library with different Project folders. Within these folders are various project files (exel - word - pdf etc.) that belong to that specific ...
0
votes
1answer
98 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
2answers
532 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
1k 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 ...