Bad sorting with grouping

[Tomas Turek]

Hi,

I´m trying to create DataGrid in XAML (i use xamarin.forms - with your component 16.4.0.53). I have 3 columns (DateTime, Date, Value). Example: 2019-02-15 23:15:10.111, 2019-02-15 00:00:00.000, "value text"

I need implement all this parameters:

 - group by: Date (only date without show time)  - i need format: 'dd.MM.yyyy' with sort descending

 - sort by: DateTime descending

 - show column: Time (HH:mm:ss) and Value

I attach a picture with wrong sort of groups (groups are not descending by date)

How to do it?

Next question: how to translate or change string 'Items'

Can you help me or provide any sample? Thx

My code: 

                <syncfusion:SfDataGrid x:Name="DataGridAlarms" ColumnSizer="Star" AutoGenerateColumns="False" RowHeight="25" SelectionMode="Single" AutoExpandGroups="False" AllowGroupExpandCollapse="True" QueryRowHeight="DataGridAlarms_QueryRowHeight">

                    <!--Grouping->

                    <syncfusion:SfDataGrid.GroupColumnDescriptions>

                        <syncfusion:GroupColumnDescription  ColumnName="Date"  />

                    </syncfusion:SfDataGrid.GroupColumnDescriptions>

                    <syncfusion:SfDataGrid.Columns x:TypeArguments="syncfusion:Columns">

                        <syncfusion:GridDateTimeColumn MappingName="Date" HeaderText="Date" Format="dd.MM.yyyy" IsHidden="True" GroupMode="Display" SortMode="Value" AllowSorting="True" >

                        </syncfusion:GridDateTimeColumn>

                        <syncfusion:GridDateTimeColumn MappingName="DateTime" Format="HH:mm:ss" HeaderText="Time" AllowSorting="True"Width="65" >

                        </syncfusion:GridDateTimeColumn>

       

                        <syncfusion:GridTextColumn MappingName="Text" HeaderText="Value" AllowSorting="True">

                        </syncfusion:GridTextColumn>

                    </syncfusion:SfDataGrid.Columns>

                    <!--Sorting->

                    <syncfusion:SfDataGrid.SortColumnDescriptions>

                        <syncfusion:SortColumnDescription ColumnName="DateTime" SortDirection="Descending" />

                    </syncfusion:SfDataGrid.SortColumnDescriptions>

                </syncfusion:SfDataGrid>

Attachment: DataGrid_c372c3f7.zip

[Subburaj Pandian Veluchamy]

Hi Tomas, 

  

Thank you for contacting Syncfusion support. 

  

Query 1: Group column in descending order. 

  

Based on the provided information, we checked your requirement “How to sort the grouped column in descending” in default grouped column will be sorted in ascending format. If you want to sort the grouped column in descending order you have add that column in DataGrid sort Description as in the following code example. 

  

 

<sfgrid:SortColumnDescription ColumnName="Date" SortDirection="Descending" /> 

  

We have attached the sample for your reference. 

  

Sample link : http://www.syncfusion.com/downloads/support/forum/142702/ze/Sample-943977192 

  

Query 2: How to translate or change string 'Items' 

We are unable understand your query clearly, can you provide more details about this query to provide you the better solution. 

 

Regards,
Subburaj Pandian V   

 

 

[Tomas Turek]

Hi, 

Thank you for quick reply with a sample.

1) I tried your code, but if I changed items (change date and datetime range to a longer period) the groups are still not descending by date (only descending by start numbers). I added sample and picture(1 and 2).

Descending groups by date working only if I use - [GroupMode="Value"] (not Display) - but if I do it, groups contain unwanted time "0:00:00" (picture 3)

2) Translate word 'items' in grouping - I want to change this word (I want to translate it to another language)

Example:

Current: Date : 21.10.2019 - 2 Items

I want: Date : 21.10.2019 - 2 Položky (Záznamy,...)

Attachment: Samples_2019_02_19_6a1e2175.zip

[Subburaj Pandian Veluchamy]

Hi Tomas, 

  

Thank you for the update. 

  

Query 1: Need to display Date alone in caption summary row and Group mode  

We have checked your query and created a sample based on your requirement. In that we have displayed Date alone without time in caption summary row and used Group Mode as value and we have achieved this requirement using Custom aggregate in summary row.  

 

Please find the sample by the following link,  

  

Sample Link:  http://www.syncfusion.com/downloads/support/forum/142702/ze/DataGrid-988883444 

  

Please refer the following UG for more details to customizes summary row, 

 

UG Link: https://help.syncfusion.com/xamarin/sfdatagrid/summary#implementing-custom-aggregate  

  

Query 2:  Regarding localization of string “Items”. 

  

Please translate the word Items based on the language and Concat or append the string with Summary Title. 

  

[C#] 

string translate = "Items"; 

GridSummaryRow summaryRow = new GridSummaryRow(); 

summaryRow.Title = "Date : {CaptionSummary} " + translate; 

summaryRow.ShowSummaryInRow = true; 

summaryRow.SummaryColumns.Add(new GridSummaryColumn 

{ 

    Name = "CaptionSummary", 

    CustomAggregate = new CustomAggregate(), 

    MappingName = "Date", 

    Format = "{Date}", 

    SummaryType = Syncfusion.Data.SummaryType.Custom 

}); 

dataGrid.CaptionSummaryRow = summaryRow; 

  

Please let us know, if you need further assistance on this.  

 

Regards,
Subburaj Pandian V  

[Tomas Turek]

Thank you very much. Now everything works perfectly.

[Subburaj Pandian Veluchamy]

Hi Tomas, 

 

Thank you for the update. We are happy that the given solution meets your requirement. 

 

Please get in touch with us if you would require any further assistance. 

  

Regards,
Subburaj Pandian V