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
1answer
760 views

REST API filter multi person/ group column by null

I have a multi person/ group column. I need to apply rest api filter on this column. I can filter it by values. eg: _api/Web/Lists/getbytitle('testList')/items?$filter=(Access/Id+eq+21) But when I ...
1
vote
1answer
97 views

Filter Sharepoint 2013

I have a customer who asked a very difficult requirement and do not know if possible. It uses excel but all migrated to sharepoint, and there is a filter in excel there is a text field to write and ...
1
vote
1answer
696 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
419 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 ...
1
vote
1answer
52 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
1answer
219 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, ...
1
vote
2answers
641 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 ...
1
vote
1answer
690 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 ...
1
vote
2answers
134 views

How to connect two lists and produce customized reports

I have two lists. The first list, 'Suppliers', is a list of suppliers with the various contact information. The second is 'Ratings' this contains a lookup of the supplier name and various number ...
1
vote
1answer
158 views

How do I set FilterOperator1 in the URL?

I know I can filter a SharePoint list by adding ?FilterField1=fieldname&FilterValue1=value to the URL. Microsoft's documentation also lists a property FilterOperator1 that you can use if you want ...
1
vote
1answer
305 views

Populate a Filter web part from a List item and execute

I have a Business Data Related List called Projects. It is connected to a Business Data Item, so it has the option to select an item (the two-way arrow next to an Item). From this List I need to pass ...
1
vote
2answers
1k views

XSLT filter for Yes/No Column/Field in SharePoint Custom List for SharePoint Designer DataView WebPart

I'm trying this with no luck: [@ActiveStatus='Yes'] also tried 1, '1', 'True' .. get no rows back.. If I remove the filter I get back all rows. full line in code view looks like this: ...
1
vote
1answer
242 views

How to set a value in a list based on the current filtered column value

I have edited my document set Welcome Page to include a web part of a "Notes" list. This list is filtered so that only notes pertaining to the currently viewed document set are visible. Question: ...
1
vote
2answers
401 views

Page Field Filter displaying 1;#ColumnName instead of ColumnName. Bug?

I have a Document Library with a column (we'll call it ColumnName) and a Web Parts Page with a value assigned for that column. On that page I have a list view displaying the Doc Library files and a ...
1
vote
1answer
252 views

How do i create a static text filter on a list webpart

I would like to use a constant as a text filter on a SharePoint list webpart. I can add a text filter and use it to filter the list successfully, but I don't want a control and I never want to change ...
1
vote
2answers
263 views

SP 2010 REST $filter column

I'm trying to filter a list using the REST service. The column im trying to filter is the default column "Modified". My problem is: I can get all itens created today, but not only the items created ...
1
vote
2answers
371 views

Filter Library with parameter

I am an intern at a company, so I am not completely sure about the structure of the servers etc. However, I have a library that I want to filter by the department that the currently logged on user is ...
1
vote
2answers
2k views

Sharepoint 2010: List view to always show last friday's data

I've been working on this issue forever now...Here's what I'm trying to do. I have a custom list where people add some info. I crated 2 views to view items added today and yesterday. Now I'm trying to ...
1
vote
2answers
473 views

Sharepoint Foundation search filter? (Exclude all but SP wiki 'x')

I've looked (unsuccessfully) for what others have done on this topic. Within our Sharepoint Foundation site we have multiple wikis and we'd like to use the Search feature to search content from only ...
1
vote
3answers
4k views

Page a list via A-Z

So I am trying to create an a to z directory from a list of items which should be an easy task and it is really, however, I am trying to find the most efficient way of doing it. So I was thinking use ...
1
vote
1answer
411 views

Turn filter on by default on a sharepoint view

I would like to filter a column defaultly on my SharePoint view, is it possible to do so ?
1
vote
2answers
2k views

How to filter column in chart web part?

I have a list with 3 columns, Month, volvo, benz. I have created a chart which contains 2 series, volvo and benz. It shows 2 series based on month, for example for jan, it shows value volvo & benz ...
1
vote
1answer
2k views

SharePoint - Showing folders in a filtered view

I have a library with a few folders in it, and the files in the folder have a "Status" property and an "Assigned To" field. I want to make a view with the following logic: If (Content Type == ...
1
vote
1answer
726 views

Need Filter to calendar list i.e for calendar.aspx page

For Calendar List - web part connections doesn't work and query string doesn't work. So I am out of options here. Can any one guide me to how to filter the calendar list data in calendar.aspx. I am ...
1
vote
1answer
913 views

Calendar DVWP to show only today with recurring and all day events

I got a interesting problem here. I developed a dashboard for one of our departments, they wanted a widget that shows only today's events. I have the DVWP in place, and filtering by a calculated ...
1
vote
2answers
1k views

spgridview clear filter programmatically

I have a textbox a button and a spgridview. When the button is clicked I will search SharePoint with the value in the textbox and bind it to the spgridview. (I'm using LingDataSource). After I filter ...
1
vote
1answer
744 views

How can I Filter a Joined DVWP by [Current User] in Multi-User People/Groups field?

I have a joined DVWP. List A includes a "category" lookup field among other columns. List A includes the same "category" lookup field as well as a People/Groups field with multiple selections. I'd ...
1
vote
1answer
123 views

Filtering List for “created by” of currently displayed user

Hey i'm trying to filter a list for the currently displayed user in the mysites. There is a list "projects" with all projects in it. If i navigate to some co-workers profile in the mysites he has a ...
1
vote
1answer
515 views

SharePoint Web Part Connections & Filters

I have a basic web part page with a number of webparts which use one identifier to filter a long list of results. The problem is there are about 25 records and it roams all the way down my page - is ...
1
vote
2answers
2k views

Programmatically filter document library view

I am starting a SharePoint application where I need to filter a document library dynamically when a user visits a page. Is this possible? If yes, how? Is it possible to have an application page with ...
1
vote
1answer
2k views

filter sharepoint 2007 search results by date range?

i want to filter the sharepoint2007 search results by given date range. I.e., With in a day With in a week With in a month With in a year Is it possible? If so, please help.
1
vote
1answer
2k views

How to retrieve User Information List data

I would like to filter a list based upon a user group that the user may belong to and a specific value found in the User Information List for that user. I tried doing this with CAML in SharePoint ...
1
vote
2answers
1k views

Filter WebPart where customer number = current document library name

I have a web part page in a document library (http://mysitecoll.com/subsite1/Cust001/cust001.aspx) I have added web part to display list from the top level. It works and displays all the items in a ...
1
vote
0answers
6 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
1answer
38 views

Issues with SPFilterDropdown in SPD2013

To start things, I have little knowledge beyond the basic concepts of SPD and being a newbie... What I want to accomplish is to only have certain values from another list show up in which their ...
1
vote
1answer
21 views

Filter a page's web-parts via URL

I made a page with multiple web-parts each a different list but contain a similar column. I would like to filter the web-parts via url. Something like: ...
1
vote
1answer
26 views

Datetime format when using $filter in ListData.svc

I'm using ListData.svc to retrieve items from a SharePoint 2013 calendar list. I have two jquery ui datepickers to select the date range. Values are read with the following: var s = ...
1
vote
0answers
26 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
41 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
3answers
152 views

Remember filter value using jquery and cookies

I am looking for a solution for the following problem: I have a large list that is related to a second list. The two list web parts are on one page, when you select an item in the first list, the ...
1
vote
0answers
40 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
1answer
32 views

SharePoint list to show all items, with the exception of closed/completed items that are older than a specific amount of time (e.g. 7 days)?

I am familiar with filtering the list to only show current items (not closed/completed), but is there a way to show all items except any that have been placed in closed/completed status more than 7 ...
1
vote
1answer
59 views

Sending user's input from JavaScript into date filter webpart

I want to do date filter for one field in my external list using calendar in order to hep user input date value. Since drop-down calendar in date filter web part doesn't work (i don't know why, when ...
1
vote
1answer
31 views

How do I filter a free text column in a MOSS 2007 list?

I want to add a filter to a list I have created. When I use a form filter I don't get the option of filtering by any of the columns that are multiline text columns. Basically I have an A-Z. The first ...
1
vote
0answers
106 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
53 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 ...
1
vote
0answers
180 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
45 views

Sharepoint 2010 metadata filters- Driving from a link or script

The "old style" list filters in Sharepoint List views (e.g. when the user clicks on a column to filter or sort on column values) use an http GET, so the filter paramaters are transmitted in the page ...
1
vote
0answers
53 views

How to filter listview using webpart?

We have a list view webpart on a page. I want to create a textbox webpart and pass data into the list view webpart and filter it based on this data. Is there OOTB method? Or do I develop a VS ...
1
vote
0answers
99 views

Creating a survey with a question being lookup column with filtering

So I need to create a survey on a monthly basis with just one question. Possible answers should be the values from a lookup column, but limited only to those from the previous (calendar) month. Is ...