Marcello,
Seems this one might be working as you expected (?)
-- in the script of the dataGrid: -------
local hcColumn,theColumn
-------
on mouseDown
put the dgHeaderControl of the mouseControl into hcColumn
if hcColumn is not empty then
put the dgColumn of the target into theColumn
if theColumn is "date" then
dispatch "sortByColumn" to the target with "date"
wait 1 sec
set the dgColumnSortDirection["number"] of the target to
"ascending" -- may be not necessary
dispatch "sortByColumn" to the target with "number"
end if
end if
end mouseDown
----------
best
André
Le 22 avr. 10 à 11:38, Marcello Bertoli a écrit :
Hi Andre,
thank you very much for your answer. I tried your code but it
doesn't do the job. It is like pushing the column header of the
datagrid two times (first the number one and the the date one).
My data come from a sql base so I can (as Steven said) make the
query do the work of the multiple sorting before loading into the
datagrid but I'm scared about performances when it comes to manage
hundreds of thousands of data. In this scenario I need to retrieve
data from the sql base and then populate the datagrid every time I
need to sort the rows without the data I already have in the
datagrid. This means more traffic over the network and multiple
populations of the datagrid...
Best regards
Marcello
On 21/apr/2010, at 19.33, Andre.Bisseret wrote:
I think yes! Assuming for instance you want the dates sorted from
the oldest down to the more recent
and then, for each date, the numbers should be sorted from the
smaller down to the greater
you should sort the numbers column first then the dates' column.
Something like that:
on mouseUp
##setting the sort type value for each column
set the dgColumnSortType["date"] of grp "datagrid 1" to "system
dateTime"
set the dgColumnSortType["number"] of grp "datagrid 1" to "numeric"
set the dgColumnSortType["title"] of grp "datagrid 1" to text
## making sure the two columns will have the same sortDirection if
necessary
set the dgColumnSortDirection["date"] of grp "datagrid 1" to
"ascending"
set the dgColumnSortDirection["number"] of grp "datagrid 1" to
"ascending"
## sort "number" first then "date"
dispatch "sortByColumn" to grp "datagrid 1" with "number"
dispatch "sortByColumn" to grp "datagrid 1" with "date"
end mouseUp
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
