Questions tagged [filter]

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

Filter by
Sorted by
Tagged with
3
votes
0answers
192 views

Ribbon is disabled when I Filter an external list in SharePoint 2010

I created an external list in sharepoint 2010 (SP1) using SPD. The backend is sql server. The I added a wildcard filter on a column called Source_System (and a limit filter). The out of the box ...
3
votes
1answer
1k views

What is this URL list filter parameter?

I have a I am trying to build but I need to know what to populate in one of the parameters... For Example... AllItems.aspx?FilterField1=Client_x0020_Name&FilterValue1=44&FilterOp1=In&...
3
votes
0answers
967 views

Modify XsltListViewWebPart XmlDefinition property not works as expected, filtering

I have got list with subfolders. I would like filter list items in current subfolder using additional caml query. I would like to add filtering functionality by modifing caml query. I try to update ...
2
votes
3answers
11k views

Filter list view with url parameter. Strange behavior in Internet Explorer (SharePoint 2013)

I have a link opening the listview AllItems.aspx with specific filter parameter in the url which works fine. But if the user tries to change the filter of the prefiltered column, e.g. by selecting "...
2
votes
3answers
27k views

How to apply 2 different conditions in the filter of list?

I have two different conditions based on which I need to apply filter on the list data. The conditions are based on the user role and status column. I have applied the filter condition as : ...
2
votes
2answers
1k views

SharePoint 2013 REST API - Is it possible to filter list by rich text column?

I have an query: _api/web/lists/GetByTitle(<LIST_TITLE>)/items?$filter=substringof('fddffd',richTextColumn) And it doesn't work. This error occurs: The field 'text' of type 'Note' cannot be ...
2
votes
1answer
3k views

How do I use REST $filter with a “Hyperlink or Picture” type column?

The $filter method works perfectly on regular text columns, but I can't figure out how to use it with a "Hyperlink or Picture" type column. For example: /_api/web/lists/getbytitle('Sponsors')/items?$...
2
votes
2answers
188 views

Only show users filled in values in a Choice field

I have several libraries, containing each a Choice column with several standard values. To each value there is a view which filters on the particular value. The users can also specify there own ...
2
votes
3answers
578 views

How to filter a list by appended change date range of a specific column

What is the best solution to create a view having a filter on a column that has multiple change date? For example I want this to list items that have some modification on previous week
2
votes
3answers
426 views

Filter items with groups per user

I have a list of items where a field is a group of users. Is it possible to filter the list to that the person viewing the page will only see the items where he is a member of the users listed in the ...
2
votes
1answer
1k views

PowerApps Sort and Filter

I don't see a similar question based on a quick search, so I'll ask a newbie question about PowerApps: I have a SP Online list relating to incoming parts (raw materials) and I'm creating a new form ...
2
votes
1answer
2k views

Limit and filter List

I have a list with more then 100 rows, so I added limit to the url. I have two questions: How can I set it to not limit with no write a specific number (like 1000)? How can I add a filter to the ...
2
votes
1answer
4k views

Multi line text field in REST API filter url

I want to filter the field with data type Multi line text, but somehow am not able to filter that. I guess this didn't work as it contains html code within it, between the div tag my text appears. ...
2
votes
2answers
59 views

How do I create View/Filter to allow Teachers to see all Student assignments in a library, but the students to only be able to see their own?

So I use SharePoint in school for students turn in assignments and for teachers to grade them via Office 365. I have a SharePoint user group (Teachers) who need to see all the documents uploaded to ...
2
votes
2answers
275 views

Filtering in rest doesn't work

I want to do a simple task, which is to get all the items where the title contains some value. I searched and found the I must use substringof('value',Columnname). But still my rest query is not ...
2
votes
1answer
1k 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 ...
2
votes
2answers
2k 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 ...
2
votes
1answer
12k views

date filter of today in rest api

I have a caml query filter for one of my date-time field. <Leq> <FieldRef Name ='StartDate1' /> <Value Type ='DateTime'> <Today /> </Value> </Leq> Is ...
2
votes
3answers
3k 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: <xsl:...
2
votes
3answers
5k views

Filter List By User Group

I am running SharePoint Foundation on Windows 7. I am trying to filter a list based upon the user group a person may belong to. If the current user is member of the Division Managers group, then the ...
2
votes
2answers
27 views

List “filters pane” works fine for text STARTING WITH. But how to filter on text that CONTAIN words?

In Sharepoint 365 I created a list and by default you can filter with the filter pane. For instant I have a company colum and a company name in ABC International. I want to filter for all compies with ...
2
votes
1answer
72 views

SP2013 Custom List - Case Sensitive Filter with JQuery

Good Morning Friends; I am using a JQuery script to act as a filter on a custom list. The text in my custom list is all Uppercase. Currently the filter is case sensitive. I tried using text-...
2
votes
1answer
122 views

Custom Font Color for Completed Items in List

A part of my workflow writes the items over to another list where users can see their outstanding invoices that need approving. However, the workflow logic goes, the filter only proves false and the ...
2
votes
1answer
8k views

Filter SharePoint List based on value from another list

Scenario: I have two lists. One tracking all the points an individual has amassed, another showing all the prizes that this person can win. I would like to display on one page, the total number of ...
2
votes
1answer
1k views

Is it possible to filter List View Webpart from URL?

I have a SharePoint list which I want to filter based on the query string parameter. I have applied the <parameterBindings> and when I pass query string parameter it works fine since the list is ...
2
votes
1answer
767 views

How can I filter a wiki web part by the title field of a list?

I'm trying to make a Wiki on SharePoint Online, where each page in the Wiki has a column called "Subject". The column type is Lookup, and it's linked to a list called "List of Wiki Subjects". The list ...
2
votes
1answer
106 views

Filtering a grouped list via the URL - Rows excluded from the filter showing if group contains filtered rows

I am attempting to filter a list that is grouped by a field using parameters in the URL. My url is ?FilterName=Status&FilterMultiValue=Approved;Review As far as I know, this should return the ...
2
votes
1answer
376 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) Edit ...
2
votes
1answer
422 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 ...
2
votes
1answer
8k views

Filtering data programmatically on SPView

I would like to know how can I filter information in SharePoint list (Library of documents) programmatically. I have tried 2 ways but they don't solve my problem: Using the string lsWebPart....
2
votes
2answers
936 views

MOSS 2007 - Filter calendar to display currently running event

I want to create a view for a calendar. The view must display only currently running events. Right now, I can create a view that filter on for daily event : I currently filter events with Start Date ...
2
votes
2answers
700 views

How to filter a list on SharePoint

I am using SharePoint Server 2007 Enterprise with Windows Server 2008 Enterprise, and I am using Publishing Portal Template. I am developing using VSTS 2008 + C# + .Net 3.5. I have defined a custom ...
2
votes
2answers
3k views

PowerApps: How to filter a people picker combobox?

I have a combobox in a powerapps form to select a user, works good. The filtering works as text is typed in, but initially it displays the full listing of users. Is there a way to show nothing until ...
2
votes
2answers
994 views

Filtering Calendar Items Using REST API

I'am trying to get calendar items and filtering by EventDate and EndDate fields using rest api. DateTime field filtering works fine on other lists but I can not filter calendar items by EventDate and ...
2
votes
1answer
393 views

Text Filter any List Column

When I add a text filter to a sharepoint page, it only gives me the option to connect the filter to a single column in a list webpart. How can I make the text filter operate like the OOB search bar ...
2
votes
2answers
842 views

REST - how to get item ID and document name while filtering by a Lookup field?

I am trying to query a document library via REST and get the item ID and the document name. The query needs to filter on a (single value) lookup field. Originally I was using a CAML query to do the ...
2
votes
1answer
1k views

Add a Filter for Date Range option in a list

Here is a little background on the task: My client has a sharepoint site that has a list of data. One of the columns or fields is a date field, this date is entered manually using MM/DD/YY Format. ...
2
votes
1answer
649 views

Multiple filters in a list

I am using SharePoint online and want to add multiple filters on the list without coding. To enable the user to use different filters on the list. For example choosing created between two dates and/or ...
2
votes
2answers
1k views

jQuery autocomplete with TextFilter and click not keeping selected data

How can I add autocomplete to a textfilter webpart which keeps the mouse selected value as the textbox value? With the current code user start typing then autocomplete list brings up but once he/she ...
2
votes
2answers
2k views

How to filter a list by hour

I am on SharePoint 2013 and do not have access to Designer, as a preface. I am trying to create a list view that filters items by whether or not they were added in the last hour. I had done this ...
2
votes
1answer
5k views

how to add a view filter to check if the login user is inside a group,same as for [Me]

I have added the following filter inside a view:- Which will filter if the “Assigned To” field equals the logn user. But now if the “assigned to” field contain a group which I belong to, then the ...
2
votes
2answers
3k 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 ...
2
votes
1answer
3k views

Current User Filter Web Part - Wildcard Filter from Multiple Names

I have a list view webpart which contains a field which is a list of users, semicolon delimited. The field is a single line text field. I then have a current user filter web part which filters list ...
2
votes
2answers
10k 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 ...
2
votes
1answer
2k 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 ...
2
votes
1answer
3k views

Custom List Filter - update list view only on second button click

What I try to do is making a simple list filter tool for SharePoint 2010 lists. What I have so far: I made a VisualWebPart (VWP) named "ListFilter", which should update the view of the list (see code ...
2
votes
2answers
424 views

Single Quote Issue While Filtering Records In SpGridview

In SpGridview single quote is breaking the filter expression as we are having filter format as "{1} like '{0}'",any idea how we can handle this situation.
2
votes
1answer
5k views

User Profile Synchronization - Filter by AD OU or DN attributes

I am attempting to filter out a subset of users in Active Directory from being pulled into the User Profile Service. The users need to be filtered by the Organizational Unit property (ou), which is ...
2
votes
2answers
3k 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 ?
2
votes
2answers
4k views

Disable filtering option on the list after the webpart page has loaded loaded completly

I am filtering a list by passing query string to a custom list http://TestSite/TestSubsite/Lists/TestList/allitems.aspx?FilterField1=FirstName &FilterValue1=Apelles This does the job of ...