We’re rewarding the question askers & reputations are being recalculated! Read more.
10

According to Use OData query operations in SharePoint REST requests, Grouping is not supported. The solution, is to apply grouping for the JSON results returned from REST endpoint. Example Suppose the following function is used for getting list items via SharePoint REST API: function getListItems(url, listname, query, complete, failure) { $.ajax({ ...


5

Grouping by a Managed Metadata Column with "Allow multiple values" set to true is NOT possible (it just will not work properly anyway). If "Allow multiple values" is set to false, it works just fine. I just double-checked it:


4

You have misunderstanding of using CustomActionGroup. It uses for creating groups not in ribbon, but in sharepoint pages, for example in site settings. Chris O'Brien has written good blog posts about ribbon customization here. And if you have doubts how to create ribbon button or group, it is good idea to digg into cmdui.xml (this file contains definition ...


4

On OP:s request, this comment is now posted as an answer: The Grouping has really nothing to do with grouping the items, what it does is helping you get rid of search results that is essentially the same file, but that are retrieved from different locations. So it is a way of eliminating "Duplicates" in the search results


4

For other people who run into the issue of ordering Groups but do not want to add any other (visible)characters to the title here is a small tip. Add spaces! More than one space is not shown in HTML so adding multiple can be done without harming the layout of the lists in most places. Spaces will be sorted to the top, so the title with most spaces in the ...


4

Simplest possible solution is to include section number in group field: 1. Permissions 2. Requirements Problem is that you can apply sort on groups only on group field. So if you use number in front of group name you can get desired results.


4

I suppose you're looking for filter parameters. You can pass a value to a list view using parameters. In SharePoint Designer they have the ribbon button for managing the parameters: So, you should navigate to a list edit page in SharePoint Designer, select your view, and then, select the XsltListViewWebPart element which represents your view in the page ...


3

Use a calculated column and the Contains formula. Create a calculated column. Enter the Contains formula. Below is a template to get you started. Replace [ColumnName] with the name of your column and Text with the choice value from the column. Match the choice entry with the number you would like the entry be associated with for sorting. =IF([...


3

You could create a column that would represent all of your topics. This could be a choice column that you would use to edit the properties of the discussion. Then, you could create a view that groups all discussions based on their topic. You will have the same data all automatically categorized. For the hierarchy, a message can only be created when you ...


3

I know it's a relatively old post but, for anyone who's still looking for an answer on this, querying for both grouping and aggregations(Totals) is supported in REST. Following are the two links for both the operations: - SharePoint Grouping REST SharePoint Aggregation REST You can always pull the entire data and then apply your custom logic but there will ...


3

You can not do it with out the of the box code as the People and Groups information is stored in one field, and the grouping is by one field. You can not split that field with a Calculated Column Formula because Formulas can not not handle complex fields (like Person fields, Multiple choice columns) On SP2013 you could write CSR (Client Side Rendering) ...


3

This is how string based sorting works. To make it function numerically, either change your column to a number and sort ascending and it will work, or change your strings to 01, 02, 03, etc and it will sort properly.


3

By Default, items in a SharePoint list can't be grouped by a Choice field if it allows multiple selections (checkbox). http://blog-sharepoint.blogspot.in/2009/09/solved-cant-group-by-choice-column-in.html


3

I was having the same query which you have. But unfortunately i found that REST Service does not supports GROUP BY functionality as per this REST Service But not to worry, you can still achieve this just you need to do some extra stuffs. The methodology which i used was Get all data from REST Service. Created a function which do required GROUP BY operation....


2

It seems that it is a known issue, and a patch was released: http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/b30a9bc6-71ad-4558-a0ab-6c621c2e3330/ If you're looking for a workaround, instead of grouping you could use connected Web Parts and filtering.


2

I assume you mean grouping a search results by a managed property such as organisation or location, and these kind of things. That you have a result which displays content grouped by for instance location. If this is the case and you want to group result from a single query, you have to edit the web part and change the query. In the Web Part, click the Web ...


2

I have just managed to do something similar to what you were working on. Here is a link to my question where I have posted the working (so far) script. Do not apply CSR Override in QuickEdit Mode I thought it might still be relevant to you as it works in both MDS and non-MDS modes. Disclaimer What I have found that works for MDS so far (note that I am ...


2

You can add a script editor web part on the page (view) where you want it to be bold and then use CSS to style it any way you want. <style type="text/css"> .ms-gb { font-weight: bold; } </style>


2

I doubt that there is a direct way to achieve this. Read this Group by managed metadata column on stack exchange which deny the fact that a managed meta data column with multiple values allowed can be used in grouping a list. However if you are very keen on it, there is an article Grouping by a multi-value Managed Metadata Field using XSLT and a ...


2

This occurs when "Enable Asynchronous Update" is selected in the List View Web Part. Instead of editing the view of the Web Part, you need to edit the Web Part Properties. Under AJAX Options, uncheck this box: Once you do that, your Web Part will start behaving properly on the page:


2

The Pending (1 value) seems to have a trailing whitespace, while Pending(5 values) has not. Thus, the values are treated as different. If you change the value of that item to Pending (without whitespace), the grouping should work as expected.


2

You will need to use OR with IF in order to achieve this. It will be something like this: =IF( OR(Title="A" , OR(Title="B",Title="C")) ,"Team 1" ,IF( OR(Title="D" , OR(Title="E",Title="F")) ,"Team 2" ,IF( OR(Title="G" , OR(Title="H",Title="I")) ,"Team 3" ,""))) More details about IF, AND & ...


2

OOTB SharePoint supports only two level of grouping. However, there is a step by step guide http://www.dotnetsharepoint.com/2015/05/group-by-more-than-2-columns-sharepoint.html to achieve this. You need SharePoint Designer to implement the solution.


2

I don't think what you want to do can be achieved in SharePoint online. But it would be very easy to export the list to Excel and create a quick pivot table. Pull company name in the Row panel of the pivot table and again into the Values panel. Then sort by value.


1

Discovered that this is actually a subset of the problem with CSR not being rendered due to the Minimal Download Strategy. Turning off the feature or using RegisterModuleInit as described here will solve the problem. Register CSR-override on MDS enabled SharePoint 2013 site


1

There isn't a REST filter that I know of that will handle getting distinct or unique values. You'll need to do that in your success callback. Typically I do this by creating an array and looping through the results. I'll check if the item is in the array, if not I push it in, if so I don't do anything with it.


1

You can take a look at the View Element Schema https://msdn.microsoft.com/en-us/library/office/ms438338.aspx?f=255&MSPPError=-2147217396. Where you would need to change the list view "Scope" property to "Recursive" in order to get the desired result. SCOPE - Optional Text. Specifies the recursive scope for a view of a document library. Possible ...


1

if its possible for you to rename the status texts, you can prefix them with zeroes and so, to make alphanumeric sorting possible. Of course its not a nice solution in a production environment where people are allready using them, but if its under development it could be a solution.


1

Well the Status column is not of Number type, but of type Text. Hence SharePoint sorts it like text. For example, it is not easy to correctly sort "10a" in your snippet above


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