[CLOSED] Store GroupField and GroupDir - group and order by one field, display another?

[zfreeman]

Within a store, is there a way to Group and Order by one value, but display another?

For example, I have this:

<ext:Store runat="server" GroupField="QuarterDescription" GroupDir="desc">

But what if I want to display QuarterDescription as my group header while grouping and ordering by the QuarterCode? The reason for this is that when descriptions are sorted in alphabetical order they look like this:
Autumn
Spring
Summer
Winter

But I need them in chronological order (which using codes behind the scenes would accomplish):
Autumn
Winter
Spring
Summer

[zfreeman]

Based on a few other posts, I tried some things but no luck.

I now have this for my group field:

<ext:ModelField Name="QuarterDescription">
       <CustomSortType Fn="switchQuarterDescToCode " />
</ext:ModelField>

and then this in my JavaScript at the top of the page:

var switchQuarterDescToCode = function (value, record) {
            return record.data["QuarterCode"];
        };

but there's no difference in the sorting.

These are the posts I referenced:
http://forums.ext.net/showthread.php...rbitrary-order
http://forums.ext.net/showthread.php...custom-sorting

[Daniil]

Hi @zfreeman,

What about remote grouping? I.e. grouping on server side. Here is an example.
http://forums.ext.net/showthread.php...l=1#post109465

[zfreeman]

This is something I thought about, but in my case, there's not a set group of values that are going to be used (like "Group A", "Group B", etc.). As the years go on, more quarters will be constantly added (and each quarter has a unique quarterID). I could use this style and pull out the year and order by that and then pull out the quarter and order by that, but I decided on a much simpler (and much more hackish) way of handling this.

I just inserted extra spaces in the descriptions between the year and the quarter... which, oddly enough, serves to change the order but then doesn't affect the display (as the browser doesn't acknowledge the additional spaces). So I just created a new attribute and changed the description this way:

    public string appliedForQuarterFormatted
    {
        get
        {
            string newQuarterDesc = appliedForQuarter;
            if (appliedForQuarter.Contains("Autumn"))
                newQuarterDesc = appliedForQuarter.Insert(9, "   ");
            if (appliedForQuarter.Contains("Winter"))
                newQuarterDesc = appliedForQuarter.Insert(9, "  ");
            if (appliedForQuarter.Contains("Spring"))
                newQuarterDesc = appliedForQuarter.Insert(9, " ");
            if (appliedForQuarter.Contains("Summer"))
                newQuarterDesc = appliedForQuarter.Insert(9, "");
            return newQuarterDesc;
        }
    }

You can close this one.

[Daniil]

A solution doesn't look robust... Are you sure it won't break at some point?

If you have any doubts, please post a full test case to reproduce the initial problem. We would be happy to investigate.