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

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. ...


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

You can set Draft Item Security to Only users who can approve items (and the author of the item) in Versioning Settings of Document library. After the the user other than Other or Approver will be able to see the last pulished version only (i.e., 1.0,2.0,etc) Below is the screen shot after setting the option: Below is the screen shot with other user ...


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

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] ...


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

I'm working with DocSets and they are a "folder" type. I'm using url: webURL + "/_api/web/lists/getbytitle('" + listName + "')/items?$filter=FSObjType eq 1" and that is working just fine for me. Before I added that on it was giving me both the docsets and their contents (the contents have FSObjType of 0) and after I added the filter I only have the ...


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

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

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.


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

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: ...


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

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.


1

You can use Query String and multiple values filters and CSOM for create the choice filter. http://stackoverflow.com/questions/24702889/sharepoint-filtering-list-with-multiple-values-of-the-same-field http://sharepointificate.blogspot.com.ar/2012/12/filtering-listviews-with-url-query.html


1

Good grief, adding basic data should not be this confusing. By inserting the data view two different ways, I had two different results with missing options. One way that I added the data view resulted in a Xslt List View Web Part, another way resulted in a Data Form Web Part. The options for filtering would never show with the Xslt List View. The working ...


1

I think most obvious solution would be to set unique permissions on items in promoted links list. Of course you should create groups for HR, Finance, etc. You can also use AD groups for assigning permissions. Usually setting granular permissions isn't recommended for performance and manageability reasons. But I assume only a couple of items will be created ...


1

Well, it turns out, I was spelling aujourd'hui incorrectly! (Missed the u) So yes Eric, you do need to localize the filters and if you spell them correctly they work fine.


1

[Aujourd'hui] should do the trick. Or maybe [Aujourd’hui] (mind the apostroph character that may be the wrong in some versions of SP; the best approach would be to copy/paste the exact word from the description). However, this is only for entering a view condition from the UI, while the page is displayed in French. If it's about creating and running a CAML ...


1

Just create a view for this this


1

If you are creating a filtered view, yes you can filter by a date less than a certain date, so long as the column you are trying to filter on is a date column. This is standard SharePoint functionality dating back to 2003 at least.


1

under Advanced options in webpart options, you have at the bottom option named Target audience. you can look there and check if that can help you.



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