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
0
votes
1answer
156 views

how do I filter a view in SharePoint based on last year?

I need to create a view with only last year, 2014, data showing. I tried creating calculated columns for start and end date and using less than start date and greater than end date filter in the view,...
0
votes
2answers
151 views

2010: Query String URL Filter doesn't filter until postback

I have a Query String URL filter sending a value (ProjectID) to a task list which filters the tasks down to match the query string. On page load, however, all tasks are displayed, making it seem that ...
0
votes
1answer
117 views

Filter SharePoint List differently in context of logged in user

I have a list view with a filter matching according to a people picker column called Manager is equal to [Me] so that Managers see their own records. The creation of the records are initially done ...
0
votes
1answer
30 views

Need help with setting up a filter for a view (sharepoint UI only)

I need help setting up a and/or filter and I can't seem to get it right. Its based off dates. I am looking for the following: Between (StartDate-Status1 and EndDate-Status1) OR Between ...
0
votes
1answer
45 views

Search a SharePoint 2010 List

Using out of the box functionality, I added a search web part and my list view below it on a page. Connected the two and I am able to search the list as needed. The problem is that the list already ...
0
votes
1answer
885 views

Sharepoint 2013 - Search files into File Share (content source) with filtering by folders

I crawled content that is on stored on file server (File Share - content source in SharePoint Server) and i get the results in SharePoint search. Everything is fine but i need to have some kind of ...
0
votes
1answer
936 views

How to Connect a list from another Sharepoint Web Application

How Could I connect a SharePoint another list which is situated in another web application? A mast get another list from another web application, and give a filter to show only this elements, which ...
0
votes
0answers
401 views

Show Filter Choices shows empty options in SharePoint 2010 List

We have SharePoint 2010 and there is a list that has 4600 items. When users try to filer a column, they get Show Filter Choices from the drop down menu: When they select Show Filter Choices They get ...
0
votes
2answers
331 views

Refine search get aspx pages only based on tags

I have to search all the aspx pages in my site-collection based on tags. For example - Tag "finance" has been added to finReport.aspx and denialsReport.aspx. So when user search finanace, it should ...
0
votes
0answers
667 views

Dynamic filter in list view -> Changing the operator

Very simple question, the list view dynamic filter (The one you see when you click on a column header), uses the OR operator for a multi-value field. However, I want to use the AND operator instead. ...
0
votes
3answers
862 views

Document Library Not Filtering Columns

There is a document library which has over 5000 items, it has passed its item view threshold. The view was reduced to show items that met certain requirements. This view now shows less than 1000 ...
0
votes
1answer
885 views

Filtering list view based on querystring using jQuery?

Using Sharepoint 2010 Content Editor Web Parts (some links dynamically created) List View Web Part Ability to add additional software or packages to the system extremely limited (so would prefer ...
0
votes
2answers
424 views

How can I filter a list view to allow a supervisor to only see the items created by their direct reports?

I have a SharePoint 2010 list, and would like to create a view that would allow a supervisor to see items created by members of their team only. I have already created a view that filters Created By =...
0
votes
1answer
1k views

Filter SharePoint lists by a Person or People Picker

How can I create a web part page, where the search web part is a "peoplepicker" like control which then filters 3 SharePoint lists below it on the "CreatedBy" column. Scenario: Find all entries made ...
0
votes
0answers
1k views

Filtering items in list view using query string - FilterName & FilterMultiValue 32 values limit?

Basically what I am trying to do is to filter list view using query string parameters FilterName=ID & FilterMultiValue=1;2;3;... Let say we have list with default view. We want to filter items ...
0
votes
0answers
365 views

Async Refresh LVWP on load with HTML Form Param

I have a List View WebPart that I need to asynchronously take a parameter from an HTML form WebPart and update the LVWP. I have some odd behavior happen when I attempt this. I have Async Load, Update, ...
0
votes
0answers
551 views

FilterOp1 Not Working

In SP 2010, we could filter a list view through the query string by using FilterField1, FilterValue1 and FilterOp1, where FilterOp1 could be an operation like Eq and Neq. However, in SP 2013, I cannot ...
0
votes
1answer
108 views

Filtering a SharePoint list

I have 2 lists and 2 pages. The first one lets call it System contains 2 columns, Name and Action. The Action column is a URL that redirects to the second page. The second one lets call it ...
0
votes
0answers
66 views

Filter WebCollection using a List of Urls

I have a List that holds the URLs of the Subsites I want to retrieve. I need to use that as a filter (optimize the query) so when I query the SharePoint it only returns the webs I want to work with. I'...
0
votes
2answers
104 views

Alerts on Document Library filter by user

I copy folders and documents to a document library by code through a feature. I am trying to prevent alerts from being fired when the document library is populated. I tried setting the Filter ...
0
votes
0answers
102 views

Filter BCS Data by Users AD Group

I'd like to know if it is possible (and if so, how) to filter the BCS data results by the AD group a user belongs to. For example. User A belongs to AD group 'group1'. In the external data that ...
0
votes
3answers
3k views

Filter a List View based on data in another list

I'm looking for guidance on how to approach a problem. I have two lists, Goals and Tasks. Goals is a simple custom list with Name and People-Involved. Tasks is a task list with a lookup field to ...
0
votes
2answers
224 views

Overcome List View Threshold with OR filter?

I have a list that multiple different people of different roles have to use. There are "submitters", "targets" and "managers" (specifically called "Created By", "Assigned To" and "DM", erspectively, ...
0
votes
1answer
185 views

Lookup list filter only future events

I have a task list that assigns tasks to specific future events. The custom task has a lookup column that is based on an events calendar. Is there any way I can cleanup this lookup list to only show ...
0
votes
0answers
18 views

List - Filter at beginning

All, I have a Person list with Status column (Active/Inactive). Is there a way when user clicks on Person list, it just displays Active Person only? Can we make the Filer of Status Column chooses ...
0
votes
0answers
227 views

using SpListFilterWebPart in sharepoint 2013

I want to use SpListFilterWebPart in allitems.aspx view in my share point 2013 and I do it with share point designer 2013 but I can't see SpListFilterWebPart in my page view Why it happened?
0
votes
0answers
1k views

How to get “SQL Server Analysis Services Filter” to work?

In an SharePoint 2013 BI Portal I am using two Report Services Report Web Parts with a common data source (.rsds file). Reports work fine and I want to filter the data of one report (or both reports ...
0
votes
1answer
180 views

How can I build some search criteria with 9 fields

I am using SharePoint 2010. I have created a Document Library. In this document library I am using some custom content type with 9 fields. I would like to make some search page where it is possible to ...
0
votes
1answer
272 views

Sharepoint filtered drop down list depending on group

I want to filter a drop down list within a list, depending on which group the user is bound to. Let's say that one group is called "green". The drop down list will originally have all different types ...
0
votes
0answers
48 views

List Item Filtering for Adminsitrators

I have a list that I'm querying using RESTful uris like so: http://site/_api/lists/getByTitle('Links')/items Each item in the list has individual permissions applied to it (both users, and groups) ...
0
votes
0answers
99 views

Sharepoint 2013: can a page automatically filter content based on credentials?

Is there a way for Sharepoint 2013 to display only certain data on a page based on the credentials of the person logged in? To clarify: My project Director wants to visit a page and automatically ...
0
votes
1answer
107 views

Filter lists based on user permissions

I am following this guide to help me solve my problem. However, it is causing issues when I try to save the edited code in SharePoint Designer. I would greatly appreciate If someone could help me ...
0
votes
1answer
115 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
1answer
266 views

ListView creation on server, retain sorting, paging, search - which control to use?

I want to create a list view from code behind so that I can control it's item collection through CAML easily (plus several conditions that would be much too hard to do in javascript). I tried using ...
0
votes
1answer
242 views

Textfilter webpart doesn't send empty parameter but parameter with previously searched word to external listview

My Filter in BCS is named 'FirstName'. Default view has following: <Method Name="GetEmloyees"> <Filter Name="FirstName" Value="{Param1}" /> </Method> <ParameterBindings> &...
0
votes
1answer
745 views

Imported Excel Spreadsheet not Filtering Column

I am uploading an excel template to the SharePoint site. I have 8 different metrics and want to add a filter to a specific column.SharePoint automatically adds the filter option to certain columns, ...
0
votes
0answers
640 views

Filtering on managed metadata columns in the insert link from SharePoint view throws invalid viewstate error

I've seen this error before in SharePoint 2010 and now in SharePoint 2013 (w/SP1), and it should be pretty straightforward to reproduce using the following steps: Create a document library Add one or ...
0
votes
1answer
453 views

SharePoint 2010 Data View Joined Subview Filter Empty Rows

I've got two lists. I've created a dataview webpart and have created a joined subview. The data that is presented is correct. In the below example, there would be a match for all items with the ...
0
votes
0answers
49 views

Column header filter works when logged in, but not on public site

I've created a public site. It includes a document library (of conference white papers). I've added lookup columns from custom lists for the conferences the paper was presented at and the categories ...
0
votes
1answer
173 views

How can I get filter values from a COLUMN rather than a ROW?

I have two list web parts on my page. The first list has two columns: user name and ROLE. A user can be listed more than once if they have multiple roles. The view used returns only the roles for ...
0
votes
0answers
86 views

External Content Type grab last rows of SQL table instead of first

I'm working with a limit filter on an external content type that grabs the first 1000 rows of my table. Is it possible to instead grab the LAST 1000 rows?
0
votes
0answers
286 views

Programmatically updated SPList view filter is showing <!#Render Error--> in the view Moss 2007

Am appending a filter condition to a particular view alertview.Query = viewQuery.ToString(); alertview.ParentList.ParentWeb.AllowUnsafeUpdates = true; alertview.Update(); alertview.ParentList.Update(...
0
votes
1answer
142 views

Store Query String for Filter WebPart in Session or like

With String accountName = this.Context.Request.QueryString["accountname"].ToString(); im getting the needed value for the filter webpart on my ListWebPart. If im paging my List, the url changes and i ...
0
votes
1answer
67 views

InfoPath Filtering

I am working on a form for a SharePoint list called Scheduling, to be used for scheduling assets. The problem I am looking at now involves filtering the options in a multiple-selection list. I would ...
0
votes
1answer
66 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
1answer
471 views

Regarding Filter on a List

on a list on Filter section i.e. 'show items only when following is true' is limited to only 10 conditions only and I have 25 conditions/rules to apply (due to lot of users) so that I can create a ...
0
votes
1answer
411 views

XSLT Filter list items in DFWP by Current Date & Time

I have a list with the fields "Effective" and "Expires". Both fields are Date and Time data types. I want to show the list items where the current date/time is greater than Effective and less than ...
0
votes
1answer
657 views

Getting Filtered results by Date column from a list with BCS and SharePoint 2010 JavaScript Client Object Model

I'm trying to get the filtered results by a column type DateTime from a list filled with BCS using JavaScript. I've tried everything to get those results with query like: "<Where>" + "<...
0
votes
1answer
138 views

COMException due to WebPart Connection while trying to Filter provider list web part

In SharePoint 2010 I see the following symptoms: We have three lists, looking up to one another in a chain. Sample: Vendors [30] as root; Projects [100], Looking up to Vendor; Deliverables [500],...
0
votes
1answer
84 views

Send dvt_curselkey values between 2 pages

I have list (Plans of subdivisions) which I filter by several parameters (Division, year, quartal). I do this through multiple dvwp connections. So there is a parameter dvt.curselkey for each dvwp, ...