Tag Info

Hot answers tagged

8

It does not seem possible to filter list items using FileSystemObjectType property in SharePoint 2013 REST. Option 1 But you could utilize the following REST query to return folders and associated list items: /_api/web/lists/Lists(guid'GUID')/rootFolder/Folders?$expand=ListItemAllFields JavaScript example var listTitle = "Documents"; var url = ...


3

How to retrieve document name using SharePoint REST Since FileRef contains file name, you could utilize the following query to return document names: Endpoint: /_api/web/lists/getByTitle('<list title>')/items?$select=FieldValuesAsText/FileRef&$expand=FieldValuesAsText Example Get documents (names) that have been created from 2014 year: ...


3

Since CSR is the default rendering mode in SharePoint 2013, I would recommend the following approach to manipulate form fields in New/Edit Form page. As an introductory please follow this article Introduction to Client Side Rendering in SharePoint 2013. Suppose a Tasks list that contains a Task Category lookup field. Then the following rendering template ...


3

The new page added in layouts folder "inplview.aspx". When paging, sorting or filtering happens there is an AJAX call to the inplview.aspx and it returns a JSON based result set. That is the rows of the defined list view webpart. The "inplview.aspx" generates the "inplviewhash" tag and appends it with "#" in url.


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


2

As indicated in the comment above, when the list has over 500 items for performance reasons some fields will not display the available values and display "Show Filter Choices" instead. If you wish you could try adding ?Filter=1 in the URL, which will show the available values by default. Not sure if it will work for you. If you are familiar and comfortable ...


2

You just need to do it the other way round. Make it: Approval Status is equal to rejected OR Approval Status is equal to pending AND Created by is equal to [Me] which gives you (a OR b) and c.


2

Try this https://mysite.com/site/_api/web/lists/GetByTitle('Posts')/items?$filter=Alert eq 1


2

The string 'Bus'does not contain the string 'Sub', so the filter for substringof should not return this in the result. If you need to return items that contains all the characters in any place in the title, you should split the query text (like 'sub') to characters ('s', 'u' and 'b') and filter the items by logical ORing the substringof expressions in the ...


2

I would recommend to replace REST query,utilize CAML query instead of filter query option as demonstrated below: Endpoint: POST /_api/web/lists/getbytitle('<list title>')/getitems { 'query' : { '__metadata': { 'type': 'SP.CamlQuery' }, 'ViewXml' : query } } where query: <View> <Query> ...


2

I'd probably create a column (Flagged of type Yes/No) in the list to act as a field to filter on versus ORing all that together. Tick all the boxes to Yes for those items and then it becomes something like: http://mysite/_api/web/lists/getbytitle('SomeList')/items?$filter=((Flagged eq true)&$orderby=Test_x0020_Date desc&$expand=AttachmentFiles& ...


2

As Pete M mentioned above you cannot filter directly on a multi-value lookup. The workaround to this is to use a CAML query via an HTTP POST. This does have the overhead of having to get the request digest, if the list doesn't have a large number of items, it may be best just to use client side filtering. var endPoint = ...


2

This error occurs since filter expression could not be applied for File Collection resource. From another hand, StudyId field is a property of List Item resource and not a File. Having said that, you could utilize the following query to return File with StudyId set to 123456: ...


2

It is not. Explorer opens up a connection to the library and you see everything that you can see based on your permissions (namely non-approvers not seeing drafts). The only way to filter it is to map that folder to a drive, search for whatever it is you want to filter by and then save that search in Explorer, but that won't be at the same level of ...


2

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

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

You don't need to reinvent the wheel I believe. From your requirement we can easily achieve using HTML Form webpart. And then connect it to a List View webpart for filtering. https://support.office.com/en-us/article/Use-the-HTML-Form-Web-Part-to-filter-and-display-data-in-another-Web-Part-860b681c-38ad-43ff-a036-a60868497ff7 The good thing about this ...


1

It isn't too difficult to create a Calculated Column which adds a KeyUp eventlistner to the existing Searchbox in a view; enabling filtering of items. This does not create a searchbox above all columns. Since the magic is in a Calculated Column for every listitem it is very easy to add filtering for additional Columns detailed steps at: ...


1

Display column in descending order: Go to List Settings Modify the View In Group By >> Select column & check Show groups in descending order


1

I can resolve the issue , the prod environment is an "fr" site collection so the query should be ($filtre=) at the place of ($filter=) just write filter with fr language.


1

For this you have to use Calculated column. Specify a column name (use like BirthdayThismonth) For type select “Calculated based on other columns” For the formula use =IF(MONTH([Today])=MONTH([birthday date]),"Yes","No") So now your column will contain either value Yes or No based on Calculated field. Now create a new view with filter where ...


1

This is the solution: ContentType="Project portal" and SRExperienceRecord="True"


1

drop the (1) in the url. You are querying just item number 1. If you want to limit to 1 item use top. url: "https://gumdropsgc.sharepoint.com/sites/Training/_api/web/lists/getbytitle('Modules')/items?$filter=File_x0020_Name Eq 'FDAAgents'&$top=1" Watch your results though. returning 1 item comes back differently than returning a set of items ...


1

The formula computation in your case will be - Rule 1 || (Rule 2 && Rule 3 && Rule 4) The conditions in operators are grouped such that the higher precedence is given to 'and' operator, followed by 'or'. You can also check in the CAML Designer how the query is formed to validate your desired result before creating a view filter.


1

Is your server's date correct? Maybe it's taking Yesterday's date as Today! If you have multiple server environment, check all the servers.


1

This is by design and I am not sure why they made it like that. There's a nice workaround with calculated columns that can query this column http://gunnarpeipman.com/2007/10/filtering-sharepoint-calendar-by-start-time/


1

Filter web parts require enabling SharePoint Enterprise site collection feature. That means this belongs to only enterprise SharePoint versions.


1

There are various options depending on the requirements and technical limitations. If you are able to put the language of the user in the URL you can use a filter webpart and connect it to the view web part. The view web part then filters the results based upon a value comming from the filter web part. Second option. In the SharePoint on premise version. ...


1

This blog will explain the how inplview parameter works in SharePoint 2013 Custom List View Web Part Refresh


1

After Ruslan Dayanov's hint I have now the answer for this case. Predefined filter parameter in the url should not set as valid query string parameter like AllItems.aspx?FilterField1=Topics&... because they will not be replaced while filtering via AJAX and always have a higher priority than the filter parameter, which are set by SharePoint logic and ...



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