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

learn more… | top users | synonyms (1)

5
votes
0answers
345 views

SharePoint 2013 REST expand and filter issue

I've been using REST for a lot of tasks, and with the recently added $batch endpoint, it's more fun than ever. There is one thing bugging me though, and I'd like to share it with you, perhaps someone ...
4
votes
0answers
481 views

Filter by calculated column with rest api in Sharepoint 2013?

Apparently you can't filter by calculated column with Sharepoint 2013 rest api? The calculated column in question returns a string. http://site/_api/web/lists/getbytitle('TestList')/items?$filter=...
3
votes
0answers
164 views

Ribbon is disabled when I Filter an external list in SharePoint 2010

I created an external list in sharepoint 2010 (SP1) using SPD. The backend is sql server. The I added a wildcard filter on a column called Source_System (and a limit filter). The out of the box ...
3
votes
0answers
358 views

How to filter a paged and sorted external list

I have succesfully implented an external content type with a read list method, which can sort and page through the external data. The external content type has 4 filters (two limit and two wildcard) ...
3
votes
0answers
496 views

Query string filter on an InfoPath lookup field

I am trying to use a query string filter to filter data on an InfoPath form using this guide. The column that I'm trying to filter is a lookup field and it is not available in the list of Consumer ...
2
votes
0answers
19 views

no items returned in a view with a filter on a calculated column

I'm having a strange issue and Google isn't helping me much in figuring out why. I have a custom list with 3 fields: Title Year calculated column =left([title], 4) single line of text Month ...
2
votes
0answers
25 views

Filter web part list from URL parameter

I want to have a site template, that has a central web part list on it (I managed to make this, using SharePoint Designer. Added a Data-View) which is filtered by some data from the URL, or from a ...
2
votes
0answers
27 views

SharePoint 2010, filter Document Set in URL

I'm trying to filter a document set in SharePoint 2010. For example, the URL to the main document library is #1) http://uat/sites/dps/doc/Forms/folders.aspx I would access a document set like this ...
2
votes
0answers
173 views

How can I filter a List View in a Web Part page using AJAX so the entire page doesn't reload/refresh?

I have a Web Part page with a list view. I know how to use filter webparts that connect to the list view to filter the list. But those all reload/refresh the entire page. I was wondering if there is ...
2
votes
0answers
77 views

How to create multiple operator options in one filter, and how to add “contain” filter in external content type?

I'm creating external content type from SQL server to business data list. I would like to create a read list operator based on search stored procedure. I noticed in creating filter table, there's no "...
2
votes
0answers
289 views

Filter.aspx and GetDistinctValues

We found an issue, that filters on columns are stop working. Error message is: Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the ...
2
votes
0answers
95 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 ...
2
votes
0answers
228 views

Filter a connected list- How to show all by default?

I have two lists embedded as individual webparts on my SP2010 page. The two lists are connected so that the first list can act as a filter for the second one- there is a column which is common between ...
2
votes
0answers
805 views

Modify XsltListViewWebPart XmlDefinition property not works as expected, filtering

I have got list with subfolders. I would like filter list items in current subfolder using additional caml query. I would like to add filtering functionality by modifing caml query. I try to update ...
2
votes
0answers
328 views

Filtering LookupMulti by FilterMultiValue SP2010

I can't filter LookupMulti's column using FilterMultiValue. My Url contain this fragment FilterName=Tags&FilterMultiValue=Flower;Sword Three is nothing, apart correlation ID. I found in ...
2
votes
0answers
476 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 ...
2
votes
0answers
244 views

DVWP ASP.NET Filter for all pages

I have created a drop down along with DVWP as described in http://social.technet.microsoft.com/Forums/en-US/sharepointcustomization/thread/949d4443-58a4-464b-9603-e4c280740650. However I see one ...
2
votes
0answers
1k views

SP2010: Strange Content Query Web Part Behavior - Inconsistent results between users

I'm experiencing some very strange behavior with a content query web part. The web part uses no customised XSL, and is a simple query of "All sites in this site collection, from a Document Library, ...
2
votes
0answers
777 views

Filtering a XsltListViewWebPart that has "Send Row of Data To“ connection doesn’t work?

Filtering of a XsltListViewWebPart is absolutely no problem when you change the webPart.XmlDefinition property like this: var xml = new XmlDocument(); xml.LoadXml(...
2
votes
0answers
263 views

Business Data Connector List Column not working BDC XML Definition

I have a BDC connected to a SQL Table with 2500 Rows. I'm able to add a Business Data List WP to a page and point it to the BDC source and it look fine except for limited number of Rows. However, if I ...
1
vote
0answers
12 views

Lookup column that auto filters bases on site pages.

I'm building a form that surveys user's opinion of the page the page viewed by the user. I have a list with a lookup-column that gets the ID from site pages. I'm looking for the ID to be ...
1
vote
0answers
28 views

Expand Fields and Items in one call and filter the expanded

What i am trying to do is to get all lists and from all lists expand fields and items. Then filter some fields, and get all items (and not only first 100) /_api/Web/Lists?$select=Title, Id, Hidden&...
1
vote
0answers
23 views

how to show filter choices by default on lists

my list has 501 records and I was expecting that "Show filter choices" will be available on each drop down columns but it this didn't happen. when i try typing ?Filter=1 at the end of the URL, I see ...
1
vote
0answers
28 views

SharePoint 2010 CQWP crashes when filtering using “Me”

I am trying to use a CQWP to display recent documents that the user viewing the page has uploaded onto any site in a site collection. I set the List Type to "Document Library" I leave document type ...
1
vote
0answers
39 views

How to configure a Filter web part to filter two lists at the same time?

I have two list on the same page, they both have the same Column. I need to add a filter to sort these both lists at the same time via this same column.
1
vote
0answers
82 views

SharePoint List filter web part - remember selection jQuery

I have a SharePoint list filter web part connected to other web parts which filters content based on the our clients names, everything it working great but I have one issues: When i select a client ...
1
vote
0answers
33 views

Cascading managed metadata columns

I have set up the following terms hierarchy in the Term Store: My Terms Departments Accounting Project Accounting Procurement Human Resources Payroll Recruiting I have then created two ...
1
vote
0answers
40 views

Combine JSLink of UserContextFilterWebPart and a XsltListViewWebPart

I have a WebPartPage which includes a XsltListViewWebPart and a UserContextFilterWebPart. In order to filter the results by the user office and 'connect' the two webparts, I added the parameter <...
1
vote
0answers
31 views

SP2010 - How to stop a Jscript filtering folders

I'm on SP2010, managed by my company so unfortunately no access to server and can't add additional web parts. I previously had the need to build an A to Z filter in a library. I have used a Jscript ...
1
vote
0answers
49 views

Getting too many groups when sorting after grouping on spgridview?

When applying a sort on my spgridview after grouping, the sort does works but the groups are splited in many others labeled identically. For instance, if I have: group 1 4 2 group 2 3 group 3 ...
1
vote
0answers
18 views

Dynamically create metadata terms

Use case: SP List synced to Access database. Database gets data from an external app and updates list dynamically. The value in one field gets added to metadata term set. Users can search/filter the ...
1
vote
0answers
38 views

unable to use content query webpart to retrieve the list content (custom template) from subsites

I am unable to retrieve the list items via content query web part from all the sub sites of a custom list created with a template. This is a SharePoint online site collection and i have placed the web ...
1
vote
0answers
46 views

Cascading SharePoint List Filter

I have a list in my sharepoint site that has two columns I want to filter by on a webpage. I want to have the first sharepoint list filter webpart to have the person select a Project Manager. Than I ...
1
vote
0answers
49 views

Use people results to show only users having access to current site collection

We've an Office365 site with more than 30K people using it, and we are using people search to show these users. This shows all the users in the tenant. But we need to show only people having access to ...
1
vote
0answers
107 views

Merging multiple form libraries into a single view

I currently have two separate form libraries: one old one, and one new one. All new forms go into the new one, but the old library still has active forms in it. We created a page with filtered views ...
1
vote
0answers
100 views

View with `Current User Filter` doesn't work

I have a View of a List which uses the Office value of the UserProfile to filter the items, using a UserFilter Webpart and adding the Parameterbinding it works: <WebPartPages:XsltListViewWebPart .....
1
vote
0answers
32 views

Limit Dates available for selection and limit enteries displayed by those dates

I am creating a small timereporting list and would like to have the user select from a list of limited dates. The dates should be all the date for beginning of the week (i.e. 05/04/2015, 05/11/2015, ...
1
vote
0answers
76 views

Filter [Me] doesn't work correct

We have a task list with a filtered view for the users. The filter is "assigned to = [me]". Normally it works fine, but now there is one users who doesn't see all of his tasks. So i checked the ...
1
vote
0answers
368 views

Unable to filter Excel web access web part

I have an excel web app with a pivot table that's data comes from a powerpivot SQL data source. I am trying to filter this data via basic 'choice web part'. when applying the filter i get an error ...
1
vote
0answers
20 views

Linked webparts filter

I have a page with 2 linked webparts, actually 2 list views. (One view is simply sending a parameter to the other view). My problem is that when I use the list filter (by clicking on the view column) ...
1
vote
0answers
59 views

Select Default Filter in BDCM File

When working with Business Connectivity Services (BCS) and Business Data Connectivity Model (BDCM) files, does anyone know in the code where to set the "default" Filter and hide the option? Right ...
1
vote
0answers
108 views

I have a list built on external content using bdc with a custom filter, I get the data but not the filter

SPD 2013, SP Enterprise 2013, SQL 2008 So I have a BDC connector setup with a SQL backend, I then built a Exernal Content List off that. I then inserted a content control webpart and inserted some ...
1
vote
0answers
129 views

Filtering list with managed metadata field dose not work in iFrame

I am working on a publishing site. As required, a view of pages library needs to be displayed on a page. The view contains a managed metadata field. If access the page directly, the view can be ...
1
vote
0answers
134 views

Odata Queries and Date Fields

I have a calculated field that contains the logic if(date) {Yes;} else {No;} This works fine for the column's calculation, but I either need to get the result of the calculated field or need to ...
1
vote
0answers
48 views

SP 2013 : Specific item in a lookup field cannot be filtered

the list A has a lookup field connected to list B in field Title. One of the items in list B has title "CCAA". On A/ViewAllitems, i can filter in column lookup:listB:Title for every item, except for ...
1
vote
0answers
255 views

When I click on the library setting “Metadata navigation settings” or “Per-location view settings ” got the error: Object reference not set to an

I am using sp2010. I have a document library with documents. I have 3 managed metadata columns in this library. When I go to the library settings and click on the option "Metadata navigation settings" ...
1
vote
0answers
78 views

Filtering list based on user preferences

On SharePoint I have 3 lists created. The 1st list contains 2 columns: user's unique ID and user's name. The 2nd list contains 2 columns: user's ID and a multiple choice of preferences of TYPES/...
1
vote
0answers
2k 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 ...
1
vote
0answers
328 views

External List filtering using Web Part Connections (send filter value to)

I have an external list (WCF) and I would like to have another web part that searches 1 or more columns on the list (e.g. Product Title, and Product Status etc) I'm using SP2013, guess it would be ...
1
vote
0answers
276 views

Export filtered list to Excel in SharePoint 2013

I have a question about Excel export. I saw a bunch of negative answers on that, but not recent ones. In SharePoint 2013, is there still no out of the box solution to export a filtered list in Excel ? ...