Tag Info

Hot answers tagged

6

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


4

Try using 1 for true, 0 for false. I was able to replicate your problem in SPO, but using 1/0 worked fine: /_api/web/lists/getbytitle('BtProjects')/items?$filter=Active eq 1


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.


2

Okay, I solved it. And you can't tell me it doesn't work, because I can see it with my own eyes :) So, that javascript you are running from that guy is unecessary, and it makes things more difficult that they should be. So you have three columns. One column has the status, one column determines the color, and the final column has the div tags. And it's ...


2

I found the answer to my problem. By default, grouped lists are set to be collapsed. If you change this to expanded by default, the list filters as expected. Another wonderful hidden feature of SharePoint maybe?


2

Tony, You can solve your task with ready-to-use solution from VirtoSoftware such as Virto Sharepoint Calendar. http://www.virtosoftware.com/products/collaboration/virto-calendar-for-microsoft-sharepoint There is also a free 30 days trial, so you can test everything.


2

Use double quotes to find exact phrases. If you want to learn about "AD.300" and don't want a bunch of results that include documents that include the word. This tells the search engine to find the exact phrase inside the quotes. Look about more nice tips about search ...


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

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


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


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


1

From: http://www.makdeniz.com/how-to-filter-sharepoint-2010-tasks-which-are-assigned-to-you-and-the-group-your-are-member-of/ Step 1: Open SharePoint designer then open site that you want to study. Select the task list or any list that you want to filter. When you select task list you will see a panel right site of designer called views. Then select the ...


1

Chris, Your impression is correct. If you index a column, filter on it, and if the results returned are less than or equal to the list view threshold (5000), then you will be able to see the results returned by the query. The only reasons I can think of for this not work would be: You are filtering on other columns that are not indexed. You are ...


1

You need to define a list view with a filter on the "claim completed" field. Create a new view or edit an existing view. Scroll down to the Filter section. In the dropdown "Show the items when column" select the "Claim completed" column. in the next dropdown select "is equal to" in the text box below type "no" Save the view. The view will now show ...


1

I'm assuming you're talking about using the FilterField and FilterValue query string parameters: You can filter on fields that are not displayed in the dataview. I would actually probably make a seperate querystring parameter for your data view in SP Designer, then you can use an OR condition in the list filter and not make any new fields (you also avoid ...



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