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

learn more… | top users | synonyms (1)

1
vote
1answer
694 views

How do I use a javascript variable in the Filter Criteria for a DVWP?

I am converting some numbers using Javascript and need to filter a list using these conversions. I cannot do the conversions within SharePoint itself, so I had to use Designer and some Javascript. I ...
1
vote
3answers
62 views

Need to filter a list with 10+ criteria

Need to create a list filter with over 10 criteria. Research tells me that it can be done with a Data View web part but I have not found any instructions on how this is done.
1
vote
1answer
69 views

Multiple columns $filter in SP designer 2013 http web service call

How can I filter on multiple columns when making a web service call in a SP 2013 designer workflow? For example if this is the url for the service call then how is the $filter part different from what ...
1
vote
1answer
47 views

KeywordQuery filter by Start and End dates using Today

I have a KeywordQuery that I need to filter so the current date is between the Start Date and End Date. Today >= "Start Date" && Today < "End Date"
1
vote
1answer
31 views

How to implement user based views

I would like to have a team site that changes based on the user that is logged in. The team site is supposed to be a landing page for everyone in the company to start their day. How can I set it up ...
1
vote
1answer
30 views

SharePoint Online - Custom List - Permission on Based on Department Column

I have a custom list with 200 records/items and there is a column (lookup) with department names (about 20 department). I want to give access to number of items based on the department. A similar ...
1
vote
1answer
48 views

Any way to hide webpart from dashboard from particular user group?

I wan give user group permission on list view web part ,and I have sharePoint foundation version for example: all item of list don't wan a see by user it only show to hr group but user created item ...
1
vote
1answer
601 views

Configuring Connection from Sharepoint List Filter Web Part to List View Web Part

For some reason I can't get a selectable connection to pass the filter values to the list view web part. I select the web part to pass the filter values to, but then the Connection Box comes up empty ...
1
vote
1answer
49 views

Jquery datatable [duplicate]

I have a custom list with Employee Name, Approval Status, Created Date columns in it.I am using SharePoint 2010 version. I want to display the list items depending on one of the column "Approval ...
1
vote
1answer
32 views

Order of choices in filter drop-down

In a list, at the filter drop-down section, choices are in ascending order: Is it possible to display the choices in descending order? (It would be more comfortable because users usually choose the ...
1
vote
1answer
297 views

web api query with $filter return HRESULT : 0x80131904

I try to filter items using SP2013 web api such this request : _api/web/lists/getbytitle('Activity')/items?$filter=Mylookupfield eq 'SomeValue'. All works fine in my DEV machine but in the customer ...
1
vote
1answer
624 views

Filter contact list by current month

I have a list of employees with a birthday date/time field in the format of mm/dd/yyyy. I want to create a filter that will show me employees that are having a birthday in the current month. How ...
1
vote
1answer
1k views

Where is Query String (URL) Filter?

Based on the answers to a previous question I want to use the Query String (URL) Filter, but I don't see it on my site. Is there something I have to enable?
1
vote
1answer
79 views

Filter content on Userlanguage in SharePoint 2013

Is there any possibility to filter content with the actual selected language of the user? I've created a document library with metadata where I have filled up the language of the content. Now it ...
1
vote
2answers
902 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, ...
1
vote
1answer
543 views

Hide forms in SharePoint list where checkbox = checked

Ok. So the problem I have is: I have a SharePoint online form library which shows a list of warranty claims, the warranty claim form has a "Claim completed:" checkbox - and what I want to happen is ...
1
vote
1answer
2k 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
184 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
1k 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
1k 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
186 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
2answers
984 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
1k 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
1answer
1k views

Unable to create valid SPDataSource Select Command

I am to use SharePoint Designer, no custom c# code. I am currently using a SharePoint:SPDataSource on a DVWP to show a list. When the SelectCommand is blank, it works fine but I will need to create ...
1
vote
2answers
161 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
509 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
1answer
419 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
811 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
389 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
402 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
441 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
1answer
419 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 & ...
1
vote
2answers
613 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
1answer
996 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
1k 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
825 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
135 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
528 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
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
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
1answer
28 views

Can I filter a SharePoint Calendar? Is such a thing possible?

It strange that for something that sounds so simple and common, it is most likely impossible. When I first approached this request I never thought I'd end up here typing out my problem ... I added a ...
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
1answer
39 views

Filtering problem with data part in SharePoint Designer 2013

I am building a custom view based on a data source. Data source base on data from several libraries with the same content type structure. I can categorize and sort these data without problem, but when ...
1
vote
1answer
68 views

Query String (URL) Filter Web Part

I am developing a portal in SharePoint 2013 in which I am using Query String URL filter web part, the function of web part is to filter the web parts on the bases of years. I gave the default Year ...