OK, this was easier than anticipated. I didn't realise the DataGrid would
detect the sort on the ArrayCollection and update it's sort arrow based on this.
My code:
import mx.collections.Sort;
import mx.collections.SortField;
var s:Sort = new Sort();
s.fields = [new SortField("transaction_date",false,true)];
dataProvider.sort = s;
dataProvider.refresh();
Thanks for your advice. By the way, I don't really understand what you mean
about sorting dates as strings. When I load my data I create date objects from
my strings, and the datagrid/sort classes sort it all correctly. Although I do
understand your labelFunction point.
Cheers,
Adam
----- Original Message -----
From: iko_knyphausen
To: [email protected]
Sent: Saturday, March 03, 2007 9:52 AM
Subject: [flexcoders] Re: simulate datagrid header click, or set default sort
column
Yes, but you should provide for the sorting of these columns too,
otherwise your sort competes against the builtin...
Alternatively, you could detach your custom sort whenever a different
header is clicked (meaning resetting the sort property of the
collection) - but I think you can have much more control doing your own.
Also keep in mind, if you have any columns with calculated fields
(meaning the dataField value is different than what is displayed), you
may need a custom sort anyway (try sorting dates as strings... and you
see what I mean)
Iko
--- In [email protected], "Adam Royle" <[EMAIL PROTECTED]> wrote:
>
> OK, thanks for your response. Haven't tried this yet, but will do.
Just a quick question, if I use do the way you recommend with a custom
sort object, can the user still use the headers to change the sort
column/direction? This is what I want.
>
> Thanks,
> Adam
>
> ----- Original Message -----
> From: iko_knyphausen
> To: [email protected]
> Sent: Saturday, March 03, 2007 5:09 AM
> Subject: [flexcoders] Re: simulate datagrid header click, or set
default sort column
>
>
>
> BTW, I also fiddled with dispatching the HEADER_RELEASE event, before
I
> used a custom sort, and one problem is, that its behavior depends on
> whether the column to be sorted was the last sorted column or not. If
it
> was the previous sort column a header release event will reverse the
> sort order, if it was not the last column, it will reuse the same sort
> order that it had when it was last used - in some cases you may end up
> dispatching the header release twice, to get the desired sort order,
and
> you can see... this is not a good solution ;-)
>
> --- In [email protected], "iko_knyphausen" iko@ wrote:
> >
> >
> > I just went through the same exercise, and ended up using the
> > "recommended" method, which is creating your own Sort object...
> >
> > The basic working is to
> >
> > 1. take a collection (either arraycollection or xmllistcollection)
as
> > dataprovider
> > 2. define a Sort object for it (you do this by creating SortFields
and
> > putting them into the fields array of the Sort object)
> > 3. execute a Refresh on your collection
> >
> > If you trigger your sort via HeaderRelease events, you should call
> > preventDefault() in that handler so that only your sort gets
executed.
> >
> > You can find code samples if you look in the docs (the example I
used
> > was about sorting multiple columns at the same time)
> >
> > HTH
> > --- In [email protected], "Robert Chyko" rchyko@ wrote:
> > >
> > > One thing to look at would be dispatch a HEADER_RELEASE event on
the
> > > datagrid. Its not the most straightforward fix, and will take a
> little
> > > tweaking to get to work right, but it is doable.
> > >
> > >
> > >
> > >
> > > -----Original Message-----
> > > From: [email protected]
> > > [mailto:[EMAIL PROTECTED] On Behalf Of Adam Royle
> > > Sent: Thursday, March 01, 2007 8:09 PM
> > > To: [email protected]
> > > Subject: [flexcoders] simulate datagrid header click, or set
> > > default sort column
> > >
> > >
> > >
> > >
> > > Hi guys,
> > >
> > > This came up last week but no working response was given.
> > >
> > > I have my data sorted in a dataProvider, however whenever I add
> > > new data I add it to the end of the ArrayCollection. However this
> > means
> > > the datagrid is no longer sorted correctly.
> > >
> > > I wish I could execute the private method sortByColumn() that
> > > exists in the DataGrid class, but it's private!!
> > >
> > > Anyone with a solution? I have tried subclassing and also
> > > copying code directly, but the sortByColumn method uses private
> > > variables, so I'm stuck again.
> > >
> > > Can anyone suggest a solution to my problem?
> > >
> > > Cheers,
> > > Adam
> > >
> >
>
