Current filter:
                                You should refresh the page.
                                  • We are trying to group by an integer column value (Id), but display the grouping as text (Name). In this particular scenario, using a lookup value is not feasible, so we have achieved this functionality like so:

                                    [C#]
                                    @(Html.DevExtreme().DataGrid() .Columns(columns => { columns.AddFor(m => m.Id) .CalculateDisplayValue(nameof(ExampleModel.Name)) .GroupIndex(0); ... }) ... )

                                    However, when grouping by this column, if the "Name" property starts with a number, the grouped value will only display that number. For example, if the name were "123test", the grouped display value would be "123". This is not an issue when not grouped, or when the "Name" property value does not begin with a number.

                                • Nikolai (DevExpress Support) 12.16.2018

                                  Hi Jared,

                                  Would you please modify the https://codepen.io/anon/pen/pqbdJJ?&editable=true example to show the issue and send it back to us?

                                • Jared_19 12.17.2018

                                  Hi Nikolai,

                                  Please see https://codepen.io/anon/pen/BvzMdr?&editable=true for the issue. I made the changes to the "Company" group, and renamed "Super Mart of the West" to "123Super Mart of the West" to fit the reproduction steps I described above.

                                • Jared_19 01.02.2019

                                  Hi Nikolai,

                                  It's been a few weeks without a reply, just wondering if you've made any headway on this issue.

                                2 Solutions

                                Creation Date Importance Sort by

                                Fixed:

                                Hi Jared,

                                Please accept my sincere apologies for the delayed response. It appears that I forgot to post my comment.

                                To resolve the issue, set the column's dataType option to 'string'.

                                Thanks,
                                Alisher

                                • Jared_19 01.03.2019

                                  It seems to me that the real underlying issue here is that DevExtreme Widgets group based on Name values rather than underlying ID values. For example, if the items I were grouping by in the above example had duplicate Name values, they would be grouped together (regardless of whether or not they had different ID values).

                                • Jared_19 01.03.2019

                                  To elaborate on my previous comment, if these values weren't being used for the comparison, there would be no need for them to be parsed as int values (the data type of the display value would have no influence on the comparison/grouping).

                                  This is also causing issues elsewhere in our app, and has been a cause of concern for some time in using DevExtreme widgets.

                                • Alisher (DevExpress Support) 01.04.2019

                                  Hi Jared,

                                  >>It seems to me that the real underlying issue here is that DevExtreme Widgets group based on Name values rather than underlying ID values
                                  Yes, you are right. This specific is described in the calculateDisplayValue documentation article.
                                  It is however, strange, that during the comparison/grouping the type of the ID column is used instead of the type of a column specified in the calculateDisplayValue option. Please give me additional time to investigate the cause of this issue. I will update this ticket once I have any results.