Hot answers tagged

5

There are no other options as such. but you can use calculated columns as an alternate solution which will have most of the excel based features.


4

Trick is to attach a JavaScript keyup event to the existing Searchbox for every ListItem (in this case above the Searchbox in the DOM, because events bubble up anyway) Each script can check against any content you can reference in a Calculated Column... that means no enumerables like Person fields or Multiple Select Choices. If you stuff it all in a ...


4

Simply showing a List/Library in batches or using group by still causes SharePoint to query for all records in that List/Library. Using a column index with a view and a filter based on the index is a requirement to stay under the LVT. And in this case, the filter must return less records than the LVT is set to (5K by default). If you were using SharePoint ...


3

One way to deal with the issue is by utilizing the content by search and filters/refiners. You can also create a result source which retrieves the indexed results from the specified list. If your columns in a list were created as a site column, it will automatically have crawled properties. You can use 'RefinableString' property and map your indexed crawled ...


3

Yes you can. Just go to modify view page, and add the filters like this: closing date is greater than or equal to [Today] publish date is less than or equal to [Today]


3

As far as I know, you can not use &. You have to use and or or inside the filter. So try using something like that: /_api/web/lists/getbytitle('Students')/items?$select=Title,ZIP&$filter=((ZIP eq 12345) or (ZIP eq 22222)) I always use brackets because of the readability, but you can also use it without brackets. items?$select=Title,ZIP&$...


3

At least I typed my own text LOL In the Filter settings of a View you can only use [Today] as is, you can do simple +- calculations but you can not use Functions. So you need to add two Calculated Columns calculating january1st =DATE(Year([YourDate),1,1) and december31st =DATE(Year([YourDate),12,13) and then compare in your View Filter if [Today] ...


3

You can do it this way: The problem is that you have to specify the year as well. My example filters the items that are created between 1st and 31st of May, 2016


3

Using JSOM you can find the current user login and create the View URL dynamically. var clientContext = new SP.ClientContext.get_current(); var oWeb = clientContext.get_web(); var currentUser = oWeb.get_currentUser(); clientContext.load(currentUser); clientContext.executeQueryAsync(function() { //currentUser.get_loginName(); //currentUser.get_id(); }...


2

The View Filter can not do (x OR y) AND z it does: x OR y AND z So you have to move part of the logic into a Boolean type Calculated Column DocumentTypeFilter =OR( [DocumentType]="Dashboard" , [DocumentType]="Supporting Detail" ) And use DocumentTypeFilter=True in the View Filter You can not use [Today] in a Calculated Column, because those ...


2

To return files use: _api/web/lists/getbytitle('Documents')/items?$filter=startswith(ContentTypeId, '0x0101') To return folders use: _api/web/lists/getbytitle('Documents')/items?$filter=startswith(ContentTypeId, '0x0120') I have tested this against SP2013 Online (O365), it should work against SP2010 as well. This works against all child content types as ...


2

Not sure about OOTB Chart Web Part. But it is possible with a 3rd party web part, Plumsail Dashboard Designer. You can find a sample with filtering on their demo site.


2

You should select the view as "Full list view" in view section. This enable all the collumn in the list. Hope this help. Below is the screen shot


2

Folders are also counted as Items and as such filter rules also apply to them. Since the folder does not have the user on the column it is not showing it to them. What you can do is add another filter (using OR) and set the logic to show content type Folder. This means it will show ALL folders as well as all items that have the user = Work Allocated


2

You're writing it wrong. You need to use $filter= to filter results.


2

Okay somehow the solution for this problem was pretty simple. One just has to click into the "empty box" -> "Web Part properties" appear in the top tool bar. When one is editing these properties, the Web Part automatically appears after saving it.


2

An alternate way from Gintas's answer is: You can create one calculated column with return type of Number and apply this formula =TEXT([DateField];"mmmm"). Then in a view you can see new column with month values. Then from modify this view, you can filter the view by using this calculated column and your desired month name. You can filter the view using ...


2

Use a Query String (URL) filter. Pass the parameters from your link and connect the filter to each web part.


2

Make it a boolean. Tested it out on my end and this is what worked. sitecollection/_vti_bin/ListData.svc/TestList?$filter=IsNum eq true


2

You could use Audience Targeting on the List View Web Parts. For instance for the default LVWP for your document library, set its target audience to be the Teachers group. Then add another LVWP for the same document library to the same page, set its target audience to be the Students group, set up a view for that LVWP that filters by Created by = [Me], and ...


1

No, if you put HTML inside a Calculated Column (and set the datatype to anything but single-line of text to output the HTML) the bare HTML code itself will be displayed in the filter choices. Only in the View is the HTML code not escaped; it will appear as bare HTML on Forms, in Alert emails and more places. A way too complex workaround is to add ...


1

Create a calculated column to sumarize criteria and then filter with this new column. Perhaps you need to create one or two calculated column. You do need code or sharepoint designer for this solution.


1

Use the AND operator to join the filters https://mydomain.sharepoint.com/mysite/_api/web/lists/GetByTitle('MyList')/items?$filter=Column1 eq 1 AND Column2 eq 2 AND Column3 eq 3


1

I think there are four issues with what you are trying: Your managed property names cannot have spaces in them, i.e. presuming start date and end date are your list columns, you need to find the names of managed properties associated with them. So your query might become like this: Today >= "StartDate" && Today < "EndDate" You will need ...


1

For each web part on the page, set the view and filter whichever field is relevant equal to [Me]. So for example, for the document library, set the home page view to Created By = [Me]. Then set the property bar (or your own link in a content edit web part) to take them to the full document library with a default view that isn't filtered.


1

This will sound crazy, but change it to filter on "AssignedTo" but keep "AssignedToId" in the select: http://myserver/_api/web/lists/getbytitle%28'Tickets'%29/items?$select=AssignedToId&$filter=AssignedTo eq 1 The other way to do it would be to use the $expand param: http://myserver/_api/web/lists/getbytitle%28'Tickets'%29/items?$expand=AssignedTo/Id&...


1

Filters aren't true security as you note. You could add folders to the list and secure the folders, then only the users who have access to the folders would see the information below. Item level permission performance scales horribly and is a pain to maintain.


1

Index on the Calculated column is not supported. As an workaround you can create a view and filter it by as per date. But it is required extra efforts. Check this for more information: Manage large lists and libraries Or SETUP DAILY TIME WINDOW FOR LARGE QUERIES This could be a great option if you can limit large queries to only be executed during ...


1

Here the steps I tried: Add a calender to your page (I picked the name Calendar) Create a new column I picked the name Persons with the following settings. (Attendees was in my case already in use, because it belongs to the default columns) Then I created a new view Took the calendar view And here are the filter options: Then ...


1

I created a calculated column. The formula checked for the differing states of status and gave only two outputs, incomplete and complete. Then used the calculated column in the Filter Choice. This worked for me but will have limited usage.



Only top voted, non community-wiki answers of a minimum length are eligible