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

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


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


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

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

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

If you have a SharePoint task list where the task is assigned to a SharePoint group, you may notice that the My Task list does not show tasks even if you are a member of the group of which the task is assigned. Fortunately, there is a simple fix. It does require SharePoint Designer though. Open SharePoint Designer and then open the My Tasks view of 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

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

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

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


1

Finally I found the solution, it was with the _doPostBack function. It should be removed and then handled with help of two functions: • $('input[id^=' + controlID + ']').autocomplete({... • $('input[id^=' + controlID + ']').keypress(function(e){... The correct code is then: <script> $(document).ready(function(){ var itemSource = []; var ...


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

[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

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

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

You've ran into this problem 3 hours before me going by the time of your post. Apparently one of the issues is that in IE11 you have to turn on compatibility mode. Once I did that it worked, and then I had to select "Get filter values" rather than parameters in order to get the list of filter options. I hope that helps!


1

It is a limitation in SharePoint 2013 REST filter. You need to use CAML query along with REST. url: "/_api/web/lists/getbytitle('Sponsors')/getitems" method: "POST", body: "{ 'query' : {'__metadata': { 'type': 'SP.CamlQuery' }, "ViewXml": "<View><Query><Where><BeginsWith><FieldRef Name='URL'/><Value ...


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

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

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

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

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

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

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

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

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

Re the problem raised by lwbecker2, so long as you have an additional lookup column that is based on the full lookup list (ie not the 'filtered' column) then you will be able to still see the original department in the linked list. For example, Department linking to the column ActiveTitle will be blank but Department:Title will still have the original ...


1

You mention jQuery, but it can be done without. SharePoint 2013 has its own subset of jQuery called mQuery So a (rather brute) method is to replace all html inside the TH tags with its own label (from the A tag) EnsureScriptFunc('mQuery.js', 'm$', function() { m$('[id^=diidSort]').forEach(function(tag){ if(tag.tagName==='A'){ ...


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



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