Tagged Questions

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
0answers
54 views

Modifying CAML to filter by passed parameter

I have a list which contains a column called "Actual Start Date". I want to filter this list at the users command to only select the date they have selected. I have created a parameter called "Start" ...
1
vote
1answer
398 views

Displaying Calculated Column hyperlinks as text in filter drop downs

I have a list which has employee IDs as a field. I then have a calculated column which takes this field and uses it to link to our company-wide employee directory. This means I can hide the employee ...
1
vote
2answers
626 views

Filtering List using CAML query and Binding it to dropdown in C#

I have the following code which retrieves all items from list "Employee Info" and bind it to Dropdown list EmployeeDD. if (!Page.IsPostBack) { DataSet ds = new ...
0
votes
0answers
26 views

Filter based on User and another attribute of User

I have an Infoshare library in which I collect: Project name, Site, Status, Owner. I have multiple users from different sites that will have access to this database and I would like to show them ...
2
votes
0answers
121 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 ...
0
votes
1answer
52 views

Connection Formula - Current and Previous Member

I am using SharePoint 2013 and PerformancePoint Dashboard Designer 2013. I have a Filter and a Chart in a Dashboard Page. When I select a member in a Filter, I want the Chart to display data for ...
0
votes
0answers
159 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 ...
1
vote
1answer
68 views

Filter XSLT ListView with metadats as tags

My goals A documents library has a Metadata column. In a webpart page, user selects (through select2) several metadatas as tags. the tag(s) (one or many) are sent to a XSLT ListView XSLT ...
0
votes
0answers
108 views

Export to Excel ignoring filters

I understand that when we use the Export to Excel button in the ribbon bar, what we get is an IQY file containing a query for OWSSVR. I am trying to filter the data returned by OWSSVR. When I go to ...
0
votes
0answers
26 views

Target filtered list results at individuals (not groups)

I am using several Content Query WebParts to filter rows in a list by various criteria. I wanted to use Audience Targeting with the respective CQWP's to display them certain individual users (but not ...
1
vote
2answers
242 views

Sort and Filter Rich Text

i have a sharepoint list with a few rich text columns but in the view the headlines of these doesnt have the button to sort or filter them like all other non rich text columns have. is there a way to ...
2
votes
0answers
38 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 ...
1
vote
0answers
34 views

Documents inside a folder not showing when a filter is applied in query string?

I create a webpart to show the Document List on a certain page, and then I applied a filter on a column content to show only certain documents. But in that way the folder structure is lost and all ...
1
vote
1answer
47 views

Categories Dropdown Box (edititem.aspx)

I would like users to be able to select a pre-determined category from a dorpdown list rather than manually typing in their own category. The image below shows the current 'New Item' screen in ...
1
vote
0answers
103 views

Losing Filter When Paging Back From Second Page

I have a list view of a task list with filters creating subsets of tasks (Archived, Constructing, Defect, Stabilizing, etc.). The default view has a limit that will return 100 items at a time when ...
1
vote
0answers
216 views

Multiple filter value webpart connection problem

We currently try to connect a custom webpart with a list view webpart. The aim is to send multiple filter values to the list view. The problem we have is that the list view does only use the FIRST ...
1
vote
0answers
21 views

Create Connection beetween TextFilter and List

I have created a text filter webpart on my page and a list webpart app on the same page. If I edit the filter webpart it says that the filter is not connected and I should open the webpart editing ...
1
vote
0answers
62 views

Date range filter without SPD or Infopath

I am having a very difficult time trying to figure out how to create a page in SP2010 Enterprise that displays list items based on a user selected date range and status field is "approved" . ...
0
votes
1answer
116 views

Display list content in editable form, filter on [Current User]

I have been trying to develop a set of pages that each has a form on the page where the user can type a response to questions on each page, and the form is saved when they submit it. If the user ...
1
vote
2answers
1k views

Checked null with dateTime in REST API SharePoint

I want to get all article pages which Article Date is not null. so I have try to do by this way. var ArticlePageContentTypeID = ...
2
votes
1answer
1k views

Filters on a large list exceeding throttle limit

On a SharePoint 2010 Server installation, I have a list with more than 5000 items. I created an indexed column and a view based on this column which is returning 100 items only, so far less than the ...
4
votes
1answer
210 views

How to filter the timeline

I was just wondering if there is a way to filter the timeline web part, so that it does not show completed tasks for instance? I have tried adding a filter to the task list that the timeline belongs ...
0
votes
1answer
102 views

Filter file types from list to NOT show certain file types

I have a document library list. Lots files, and a handful of file types. I know how to force a filter via the URL. Saw docx file. But right now, I have a need to show all files except docx, pptx, ...
0
votes
0answers
94 views

reload objectdatasource for paging spgridview

I'm developing a search result in an spgridview loaded with objectdatasource. The issue is the Location object authorize's only 250 ItemsPerPage in this property. My spgridview is set to allow paging ...
0
votes
1answer
144 views

Autocomplete Text Filter Webpart

So I have to setup a text filter that is connected to a big list of names. Is it possible to configure some kind of autocomplete on this text filter to help users?
0
votes
0answers
19 views

Dynamically filter items in calendar [duplicate]

I've got a list used to hold items for appointments. It looks like this: The column I'm mainly interested in is the location. It doesn't have a fixed set of possible values. When showing the same ...
0
votes
0answers
46 views

Chart WP does not follow List WP when using Text Filter WP; X & Y field choices

Two questions if anyone can help. I searched and tried everything. SP2010 (1) I cannot get a Chart WP to reflect a List WP that is filtered by a Text or Choice Filter WP. The Chart WP DOES change ...
0
votes
1answer
284 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 ...
3
votes
2answers
2k views

Filter a Multiple Selection List Box in Sharepoint

I have what I thought a simple problem, but can't seem to find any solutions that work or exist in SharePoint 2013. I have a multiple selection list box in an InfoPath 2010 form. This box defines the ...
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 ...
1
vote
2answers
3k views

Trying to open a SharePoint List item in Modal Dialog in Sharepoint 2013 Office 365 (online)

Sorry for the long post. This has been killing me. I had this script working perfectly fine in SharePoint 2010 (online) and basically i have a source custom list (list A) with a hyperlink column and a ...
1
vote
0answers
125 views

how do I create search in sharepoint list edit form using infopath

I have a list called Tasks in sharepoint 2013 that has a number of lookup fields. It was initially created by exporting data,tables and relationships from Access 2013. The client wants to be able to ...
0
votes
1answer
194 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
28 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
85 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 ...
2
votes
1answer
144 views

“Save List as Template” losing Filter web parts but leaving false connections?

My InfoPath form web part remembers some false connections from the past, and cannot take any new connections after Save List as Template. What I did is this: Customize Form in browser (SP2013) ...
1
vote
0answers
45 views

Send filter from Scorecard to Analytic Grid

The figure has an Analytic Grid at the bottom. It has a measure called [Application Count]. And it has a dimension named [Day Bucket]. At the top is scorecard. It has several calculated measures. ...
1
vote
0answers
208 views

SharePoint 2010 Data view web part filter values show all items when page loads

I prepared the data form web part with data source as SQL table on the page. On the same page, I created another list view webpart which contains items as parameters to filter SQL data through ...
0
votes
1answer
123 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 ...
2
votes
2answers
6k views

How can I filter a SharePoint list based on a date column?

I have a column with "start date". I also have a column called "expire date". How can I make a filtered list so that it only shows items where the "start date" is equal or greater and equal or ...
2
votes
1answer
608 views

Filtering datasheet view in Sharepoint 2010

I want to create a filter on Multiline Text Column inside a Datasheet View by means of out of the box features. Is it possible to provision such a feature so that when I click on the dropdown on such ...
0
votes
0answers
85 views

Wrong date representation on Russian site while filtering by date range using Date Filter Web Part (?)

I want to create date range filtering on my event list. For that I use the following article: List filtering by date range. I was able to follow all the article and connected Date Filter Web Part with ...
0
votes
0answers
236 views

Ways of implementing data range filtering on event list

I have to implement filtering of my event list on several columns like EventType, Organisator and so on. All the columns filtering work well using OOB filtering by pressing on the header of the ...
1
vote
2answers
557 views

Document Library Filter

This may seem like a simple question, but I have spent hours trying to get this function to work properly. I have two data columns in a document library with a view titled "today". The idea is as ...
0
votes
0answers
45 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?
2
votes
1answer
130 views

[Today]-15 filter not working on external list

I have an external list which is getting data from SQL Server. The table structure is as follows: Name InsertDate Where InsertDate is the date when record was inserted. I am trying to show only ...
0
votes
0answers
50 views

datasheet view showing duplicates only one time

Is there a way to show sort/filter a column, e.g. Assigned to to only show one time? For example John Doe John Doe Mark Miller James Bond Now I want to filter the datasheet view to only show: ...
1
vote
1answer
158 views

Passing employee id from AD to a SharePoint list

I have a property named EmployeeId in AD. UPS is configured and is getting all users EmployeeID from AD. I have made an external list. I want to pass logged in user's EmployeeID to that list so it ...
1
vote
1answer
77 views

How to get value of multiple list filter webparts

Related to the previous post about accessing a List Filter Web Part value How to get value of List Filter web part in Javascript? How do I get access to the value of multiple list filter web part ...
1
vote
1answer
515 views

Filter Sharepoint 2010 List with Duplicate Items

I have a list that is being used for document control. The list contains multiple items with the same Title as well as other columns. It also contains a manual revision column I would like to display ...