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

learn more… | top users | synonyms

0
votes
3answers
53 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
27 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
31 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
31 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
688 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
83 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
179 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
183 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
878 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
906 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
443 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
275 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
753 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
632 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
21 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
48 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
47 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
40 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
196 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
47 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
47 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
124 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
762 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
250 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
465 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
83 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
506 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
93 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
482 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 ...
0
votes
2answers
134 views

Filters get removed from external list when document is deleted from XsltListViewWebPart on same webpage

I have a webpage on Sharepoint 2010 that has: 1) An external list 2) A webpart that has XsltListViewWebPart referring to a document library When a filter is applied to External list, it filters out ...
0
votes
1answer
40 views

Longest practical filter for an alert

Environment: SP2010 Enterprise SP1, Server/SQL 2008 R2, VS2012 When building alerts through object model, what is the longest or most complex CAML filter that can be applied to them? Can they be as ...
0
votes
1answer
2k views

How can I add button to ribbon that visible only for specific content type?

I have document library and i want to add button that will be visible only for my content type: <Elements xmlns="http://schemas.microsoft.com/sharepoint/"> <!-- Parent ContentType: ...
0
votes
1answer
920 views

Filter a DVWP based on currently logged in user

I have a sharepoint list which lists issues. There are 4 people(not fixed) from separate groups(say A,B,C and D) responsible for each issue. Now I've a requirement according to which, I'll have ...
0
votes
1answer
218 views

Filter XsltListViewWebPart using Choice Filter

I have put choice filter for filtering records in XsltListViewWebPart. but choice filter opens a popup box. and select one(it display like radio buttions with items) of item from it. I don't want ...
0
votes
1answer
377 views

Filter Parameter from Visual Web Part to XSLT or DataForm Web Part

I have a scenario where from Visual Web Part I need to send filter parameter to XSLTListView or DataForm Web Part on the same page! If I use Query String then I need to Response.Redirect and that will ...
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
2answers
765 views

Send Paramets from HTML form to DVWP via javascript

Good day! I have a DVWP. DVWP has parameters as query string "StartDate" and "DateEnd" and filters on datefield "Date" by parameters "StartDate" and "EndDate". Also I have form on the page with ...
0
votes
1answer
348 views

Filter Data View with SOAP Query as Source

I am creating a printable company directory. I have a SOAP Service query that pulls everyone's data from the search service. The query returns all the results I want. I have enabled the "Sort & ...
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 ...
0
votes
2answers
679 views

multi filter with URL values

I know that I can filter a single field with a single value using parameter passing to a view or a page. Something like: URL?FilterField1=ColumnName&FilterValue1=ValueToFilterOn My ...
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 ...
0
votes
1answer
262 views

SPGridview Filters date formatting issue

I have an issue with spgridview filters, in my grid view i have column that contains start date and i have to display date in "yyyy-MMM-dd" format, i am able to do this with the custom itemtemplate ...
0
votes
3answers
684 views

Is that possible to use != in query string?

I am filtering sharepoint list using query string for some reson i need to check condition like FieldValue!=Red is that possible to achive? Or still its limitation? ...