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

learn more… | top users | synonyms (1)

0
votes
1answer
94 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 http://my.farm.com/...
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 ...
0
votes
0answers
196 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
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
4answers
2k 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
296 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
298 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 ...
0
votes
0answers
16 views

Am i filtering correctly?

I am trying to make this view so that "Circuit Type" will only display records with HDSL in them and also "DLC/HUB Name" dosnt display N/As or blanks. I tried this but it didnt work.
0
votes
2answers
63 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? http://mysite/_api/web/...
1
vote
1answer
372 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
1answer
651 views

Query String (URL) Filter for Search Result?

How to activate a Query String (URL) Filter for Search Result?
0
votes
1answer
64 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
55 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: https://OurOrginizationSite.org/sites/...
1
vote
1answer
233 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 = moment(jQuery('....
0
votes
1answer
256 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
16 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 ...
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 ...
0
votes
2answers
359 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
61 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
2k 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 type="...
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 ...
2
votes
2answers
1k 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 ...
1
vote
1answer
40 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
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 ...
0
votes
1answer
229 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
70 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 ...
0
votes
2answers
128 views

How can I filter a list view to allow a supervisor to only see the items created by their direct reports?

I have a SharePoint 2010 list, and would like to create a view that would allow a supervisor to see items created by members of their team only. I have already created a view that filters Created By =...
1
vote
1answer
4k 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
2k 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 choices....
0
votes
1answer
212 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
46 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 ...
2
votes
3answers
803 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 ...
0
votes
0answers
527 views

Filtering items in list view using query string - FilterName & FilterMultiValue 32 values limit?

Basically what I am trying to do is to filter list view using query string parameters FilterName=ID & FilterMultiValue=1;2;3;... Let say we have list with default view. We want to filter items ...
1
vote
2answers
2k views

Filter lookup column based on another field value

Scenario: I have Tasks list with a (lookup) column Project. I have also a multivalue lookup column Predecessors pointing to the Tasks list itself. Question: Is it possible to filter available Tasks ...
10
votes
5answers
23k 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 request....
0
votes
0answers
150 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
289 views

FilterOp1 Not Working

In SP 2010, we could filter a list view through the query string by using FilterField1, FilterValue1 and FilterOp1, where FilterOp1 could be an operation like Eq and Neq. However, in SP 2013, I cannot ...
0
votes
1answer
66 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
134 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
39 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. I'...
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
1answer
109 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
2answers
967 views

How to create SPQuery by filtering date interval

I have a custom aspx form where I retrieve list items by filtering two values EventDate and EndDate. I have a realization but it returns nothing: DateTime eventDate = Convert.ToDateTime(properties....
1
vote
1answer
129 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
63 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
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?
0
votes
2answers
45 views

Alerts on Document Library filter by user

I copy folders and documents to a document library by code through a feature. I am trying to prevent alerts from being fired when the document library is populated. I tried setting the Filter ...
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 ...
0
votes
1answer
194 views

Due in next 90 days filter in a data view

I'm making data views and for a couple of them I want to filter to show any items that are due within the next x amount of days. My immediate thought was to filter by Current Date + 90. I've done ...