Sort Array in datagrid

[nrutter]

How do you sort an array in your datagrid? I always want to be able to sort my
array by an instance number. If you add a new instance I want it to resort the
array. For example if I ad a product to instance one then add an instance to
instance two...then go back and add one to the first instance it would be
ordered like this..... 1 , 2 , 1. I always want it to sort like this 1 , 1, 2.
How do I do this?

[javamonjoe]

Is there a problem with the sortCompareFunction attribute of the column? If you require a custom sort routine you may define one there.

[nrutter]

Okay so how do I use that function to sort my column? That is what I don't understand how to do?

[javamonjoe]

Use the sort object to provide the initial sort. Other sorts may be chosen by the user at runtime.

[javamonjoe]

I'm sorry, but I wasn't clear. Use the sort object to sort your dataProvider for the initial sort.

[nrutter]

Can you show an example of this I still don't understand what you mean?

[javamonjoe]

Something like the following:

var myData : ArrayCollection = getMyData();
var sort:Sort = new Sort();
myData.sort = sort;
myData.refresh();

myDataGrid.dataProvider = myData;

You will have to manipulate the sort object and its fields to satisfy the
particular needs you have, but that is the basic idea.

[nrutter]

So where in there do you actually specify what column you are sorting by?

[javamonjoe]

Check out the sort object and use the SortFields object in tandem. Time to do a little reading now.

[nrutter]

I have been reading all day on how to do this. Thanks.

[bitwyse]

Here is a bit of code that might help . . .


var sortFields : Sort = new Sort();
var sortField1 : SortField = new SortField( "sfWeekEndingDate", true,
true, false );
var sortField2 : SortField = new SortField( "sfDateSubmitted", true,
false, false );

sortFields.fields = [ sortField1, sortField2 ];
model.asUpdates.arrayOfASUpdateVOs.sort = sortFields;
model.asUpdates.arrayOfASUpdateVOs.refresh();