11

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

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


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

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

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

I found the answer here. It uses hooking into ProcessImn SharePoint function which supposedly gets called on expanding any group according to the answer. I modified my code as below and it is now working SP.SOD.executeFunc("clienttemplates.js", "SPClientTemplates", function() { callColorCodingOnGroupExpand(); SPClientTemplates.TemplateManager....


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.


2

I have tried this on my tenant and found some strange behavior. Below is a workaround you could try: Step 1: When you group by 'Status' but do not include it as part of the displayed view columns the user will not be able to drag and drop. In the below image, the library view is grouped by 'Status' but it is not part of the actual list view columns. It did ...


1

if you are using any JS Library (jQuery, in this case) to group, I recommend you to use underscore.js or agile.js. underscore.js (http://underscorejs.org/#groupBy) //group by an enumerated property _.groupBy(response,"enumerablePropertyYouWantToGroup") //group by a nested property var groupped = _.groupBy( response, function(group){ ...


1

I may not fully understand what you are trying to achieve. You want to display a 100x100 thumbnail of the Image in a Document Library and the image name is in the Title field? You can achieve this with a Calculated Column (set to datatype=Number): ="<IMG height=""100px"" width= ""100px"" src=""" &[Title] &""">" datatype Number wil be output ...


1

SharePoint:ListViewByQuery might do the trick. I found this example: https://social.msdn.microsoft.com/Forums/sharepoint/en-US/906a43a4-2724-45de-b1ab-285f64229e83/multi-level-grouping-in-spgridview-programmatically <SharePoint:ListViewByQuery ID="CustomersListViewByQuery" runat="server" Width="700px" /> In Code behind SPList oList = web.GetList("...


1

The view you are currently using is corrupted. This might have happened because of editing in designer or something else. Create a new view based on the existing view and delete the existing view.


1

If you make the manager field required, then when uploading the file, they get redirected to the Editform.aspx page where they can supply this information. If they bulk upload or use windows explorer, they bypass this though.


1

If you have a list and group by is applied on Category. The resultant OOB SharePoint list view already shows the data in a manner described by you. However if you really want to create a gridview of your own then you can achieve the task using ASP.NET Gridview/Repeater but in that case you need lot of customization in your code. You may go for some third ...


1

When you say you want it grouped, I suspect you mean you want something like IEnumerable<IGrouping<something, SPListItem>>? I don't think that SPQuery can do this by itself (CAML support this because of visual aspects I think), but what benefit do you get from using CAML for this? Wouldn't ordering/sorting them in the CAML query result in the ...


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.


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