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
2answers
86 views

SharePoint 2010 Rest API filter statement not working

I am trying to filter a rest query but can't seem to get it to work. During my testing, the following statement works (no filter, a alternate way to get the item I wanted): // sort the list desc and ...
0
votes
0answers
27 views

How to avoid large list error when modifying URL filtered view

I have run into a problem with SharePoint that is frustrating my users to no end. I have a large list (>5000 rows) that users can arrive at by clicking links formatted like this ...
1
vote
1answer
25 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 ...
0
votes
0answers
36 views

Filter list by Organisation Data

I have an approval process set up on SharePoint online for leave tracking which links into a list which has every employee and there leave balances. It all works nicely however I want line managers to ...
0
votes
0answers
42 views

Filter view by hyperlink column

I'm using SharePoint 2013 and I have a library in which one column is of the type hyperlink. Now I have a view in which one of the columns to be displayed is the hyperlink, this one has the url and ...
0
votes
0answers
54 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. ...
1
vote
0answers
26 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 ...
0
votes
0answers
46 views

Filter entries of Data View Web Part using Sharepoint Designer 2010

I am trying to set up a list of current birthdays on our Sharepoint Website which runs with Sharepoint Foundation 2010. So farI got: A list containing name, birthday(Date/Time) and two calculated ...
0
votes
3answers
245 views

Filtering REST call with lookup field

We have a column defined on a custom list that allows for multiple select of values from another custom list. The column on the list is call Panels. When I do a REST call against this list, I can ...
0
votes
3answers
76 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 ...
1
vote
1answer
86 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
48 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 ...
0
votes
0answers
9 views

Linked webparts, view 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) ...
0
votes
0answers
116 views

Customize drop down list with jquery

I'm using SharePoint 2010 and trying to limit the choices in SharePoint SpListFilterWebPart filter, using jquery. The filter has around 40 values to choose from (stored in SharePoint as list), but ...
0
votes
0answers
63 views

Filter search on multiple criteria

Is it possible to filter search to display results based on multiple search criteria. Like in the example image below If I would like the search result to show - Due Dates for 2/4/2013 and ...
0
votes
2answers
44 views

Problem with many $filter parameters

The query below returns a 404 error because there are two many $filter parameters. Can I increase the number of $filter parameters permitted? How can I improve this query? ...
1
vote
1answer
108 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 ...
0
votes
0answers
43 views

User Profile Department List View Filter?

Any UI Way filter by [MyDepartment]? That is current user's profiled Department? If not, any good jQuery implementation out there?
0
votes
0answers
25 views

SP2013 - Choice Filter web parts position different for other users?

I have a page with a couple of choice filters, connected to a doc lib through web part connection, and a Apply Filter webpart (with Remember my selection). The order of web parts on my computer looks ...
0
votes
1answer
155 views

Query String (URL) Filter for Search Result?

How to activate a Query String (URL) Filter for Search Result?
0
votes
0answers
20 views

Web Part Query String not showing on a standard Site Page (SharePoint 2010) in edit mode

I am trying to add a standard Query String filter to a SharePoint Site Page but the web part is not showing in edit mode, the code for the web part is present within the page when you edit it in HTML? ...
0
votes
1answer
32 views

SharePoint 2010: How to filter search results on a content type and a boolean column = true

I am using SharePoint2010. I have a search result webpart with a filter on a content type. I would like to append this filter with a boolean column = true. See below the current filter: ...
1
vote
1answer
37 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
93 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 = ...
0
votes
1answer
98 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
1answer
15 views

Am I setting this filter wrong?

I have a list that I want to filtered only to display items that contain area of midstate and midhudson. But for some reason when I add a record and choose the area NORTHEAST or CENTRAL it still ...
0
votes
0answers
35 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 ...
0
votes
0answers
16 views

Document center web part filters delayed

In my SharePoint Document Center. I have 2 web parts. One is suppose to filter the other. The problem I'm having is that the filter is always delayed by one click. Take a look at my pictures for a ...
0
votes
1answer
104 views

How do I format SharePoint Rest API Results?

How do I get my SharePoint Rest API Results to return like so: Title : FDA Project RioBravo Module: Primary Training Roles : Project Manager, Lead Agent versus the way this returns them like so: ...
0
votes
1answer
39 views

How to check if title contains character

how could i check for all titles that contains 3 characters that the user types in var query = $("#subSiteTitle").val(); The value that the user types in must be length >2 So if the user types for ...
0
votes
2answers
205 views

How do I use SharePoint Rest API to query list for a field resulting in one row of data?

I've been able to pull data for a specific list, but unable to filter it down to one item, where the Field called "File Name" equals drugdealers. Any assistance would be appreciated. <script ...
1
vote
0answers
58 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 ...
2
votes
1answer
61 views

How does SharePoint handle AND / OR view filtering?

Premise: For the example let's suppose I want to create a view that displays Pending items but filters out the Rejected. Since there are multiple approvers, both Col A and B must be used. When ...
0
votes
1answer
19 views

Create keyword link

I'm newbie in SharePoint development. I would like to ask, is it possible to create a link on SharePoint that will shows all document library and list based on the keyword just like label widget in ...
1
vote
0answers
73 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 ...
0
votes
1answer
81 views

Filtering a REST call with a View

I have a list in SharePoint I want to make a REST call to access it. I need to filter this list by an Alert Yes/No field. The field is called Alert and I try to filter it on "true" but the results ...
0
votes
1answer
58 views

Filtering Custom List Items

I created a custom list then I created a webpart for custom list. I edit settings of the webpart. I created a new filter for this list. I clicked the "Edit Page" then I selected webpart. I edited the ...
1
vote
1answer
760 views

Getting document name using REST (not title) while filtering document library

I am trying to filter through a list and return metadata of the documents in that filter. How do I return the name of a document from a document library using REST while being able to filter the ...
0
votes
3answers
587 views

Filtering Look up Columns with Javascript

I'm trying to find a way to dynamically filter a look up column on the new and edit forms in SharePoint 2013. I want to be able to get a value from the URL and use that to filter the look up ...
0
votes
1answer
47 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 ...
-1
votes
1answer
35 views

How to filter values in a doc library

I have a doc library with let say 200 documents and two category so if i in the first category that is called Doc category i choose Devices then i want in the next column that is called Category type ...
1
vote
3answers
333 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 ...
5
votes
3answers
3k views

REST with $filter for List Items in Sharepoint 2013

Sharepoint 2013, REST API, native C++ application: I want to get all Folder items from the list. Try /_api/Web/Lists(guid'GUID')/Items?$filter=FileSystemObjectType+eq+1 and get HTTP 400 Bed ...
0
votes
0answers
66 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
29 views

Filtering by column heading column causing error Cannot show the value of the filter

I have a list in sharepoint i have created three views which filters the items according to the year they were created. But when i am in the list and i want to filter with the column heading i get the ...
0
votes
1answer
39 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
1answer
55 views

SP13: Filtering Default Calendar Start and End Time

I am working off of a list from a calendar. Within the calendar list I am to filter all event columns except Start Time and End Time field. See image below for a visual example. Does anyone know ...
0
votes
0answers
14 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. ...
0
votes
0answers
227 views

Lookup Columns and Web Part Connections

I'm working on creating a Page Template which will display various content from different lists together based on a common lookup field which is in each list. I've created a new Content Type based ...
0
votes
0answers
46 views

Show blank list on No Item Exists error

I have two lists, one which contains project Issues and one which contains lower level actions. The Issues list has a column with a hyperlink that takes the user to the actions list and it passes 'ID' ...