RE: [flexcoders] date sort

[Matt Chotin]

Yes, as I said the example was meant to get you part way, to get the sort to work in both directions you need to do more work that I don’t have time to write for you.  There are some sorting examples for different purposes on my blog at http://weblogs.macromedia.com/mchotin/archives/2004/04/large_data_sets_1.cfm that you may be able to use as a basis as well.   You are right that the sort acts as if it is sorting the strings instead of the underlying data.  This is one reason why you had to use the custom sort.  We are looking at making some of this more intuitive via a different mechanism in Flex 2.   Matt   From: flexcoders@yahoogroups.com [mailto:flexcoders@yahoogroups.com] On Behalf Of Nischal Pathania Sent: Thursday, October 13, 2005 2:44 AM To: flexcoders@yahoogroups.com Subject: RE: [flexcoders] date sort   Matt: I tried your example script but it works for only first click and sort data in ascending order. Any click after then produce no change to grid items. This script raises me another question to you, "feedbackCreationDate" is declared as Date data type which means the default ordering should work. If I remove sortGrid function on headerRelease and set sortOnHeaderRelease to true then it sort column as a String and not as a Date data type, which I expect to do so. By default date format in flex is <DOW> <MON> <DAY> <HOURS>:<MIN>:<SEC> GMT<TIMEDIFFERENCE> <YEAR> Therefore date column is sort on "day of week" which yields Friday date on top and Wednesday on bottom if we sort column on ascending. Regards, Nischal Pathania ________________________________________ From: flexcoders@yahoogroups.com [mailto:flexcoders@yahoogroups.com] On Behalf Of Matt Chotin Sent: Wednesday, October 12, 2005 19:21 To: flexcoders@yahoogroups.com Subject: RE: [flexcoders] date sort OK, the problem is that we end up executing the formatDate function and sorting those values instead of using your comparator functions on the fields as specified by the actual column.  Here's a small example that will get you part of the way.  You'll need to finish it out to get it sorting ascending and descending (for example the headerRelease functionality will need to be made more aware of what header you pressed to know if it should do anything). <mx:Application xmlns:mx="http://www.macromedia.com/2003/mxml" xmlns="*" initialize="setup()">             <mx:Script>             <![CDATA[             var dFormat:mx.formatters.DateFormatter;             function setup():Void             {                         dFormat = new mx.formatters.DateFormatter();                         var dp:Array = [];                         for (var i:Number=0; i < 1000; i++)                         {                                     dp.push({feedbackCreationDate: new Date(Math.round(Math.random() * 2006), Math.round(Math.random() * 12), Math.round(Math.random() * 31))});                                }                         dg.dataProvider = dp;             }                                     function sortGrid(a, b) {                   a = a.feedbackCreationDate.getTime();                   b = b.feedbackCreationDate.getTime();                   if (a == b)                         return 0;                   else if (a < b)                         return -1;                   else                         return 1;             }                         function formatDate(rowData):String      {                   return (dFormat.format(rowData.feedbackCreationDate));             }                         ]]>             </mx:Script>                         <mx:DataGrid id="dg" headerRelease="dg.dataProvider.sortItems(sortGrid)">               <mx:columns>                 <mx:Array>                   <mx:DataGridColumn columnName="feedbackCreationDate" headerText="Date" labelFunction="formatDate" sortOnHeaderRelease="false"                     />                 </mx:Array>               </mx:columns>             </mx:DataGrid>   </mx:Application> In answer to your second question there is currently not a way to remove the ordering once you start clicking on headers.  You would need to have a copy of the data in the original order and then re-assign the dataProvider to that copy. Matt ________________________________________ From: flexcoders@yahoogroups.com [mailto:flexcoders@yahoogroups.com] On Behalf Of Nischal Pathania Sent: Wednesday, October 12, 2005 9:01 AM To: flexcoders@yahoogroups.com Subject: RE: [flexcoders] date sort Everyone: I have used sortCompareFunction attribute of gridcolumn to resolve date sort issue in my application. Below is the part of my code ..... <mx:DataGridColumn headerText="Date" columnName="joinDate" width="100" sortCompareFunction="sortGrid" labelFunction="formatDate" /> ..... function sortGrid(a, b, index) {       if (a == b)             return 0;       else if (a < b)             return -1;       else             return 1; } function formatDate(rowData):String      {       var dFormat = new mx.formatters.DateFormatter();       return (dFormat.format(rowData.feedbackCreationDate)); } .... 1. But now I'm facing a performance issue. My application is populating 1000 records in the grid and when I click on the header to sort grid on date order then it hangs the application and throw script error "A script in this movie is causing Macromedia Flash Player 8 to run slowly. If continues to run, your computer may become unresponsive. Do you want to abort the script?" Same script works fine if I populate with less number of records, say 100, in grid but then this takes more then 10 secs to sort data. Do we have any solution to this issue? Also, if I remove labelFunction then script works fine for 1000 records but takes long time to order all data. 2. Is it possible to remove ordering from the grid and show default order list? Click one will sort data in ascending order, Click two will sort data in descending order and Click three will show the default order or remove ordering from the grid. Regards, Nischal Pathania ________________________________________ From: flexcoders@yahoogroups.com [mailto:flexcoders@yahoogroups.com] On Behalf Of Matt Chotin Sent: Tuesday, October 11, 2005 20:53 To: flexcoders@yahoogroups.com Subject: RE: [flexcoders] date sort sortCompareFunction is meant for you controlling the sort regardless of whether you had a cell renderer.  You just need the DataGridColumn.  In your case since the data is already formatted using the labelFunction you may want the sortCompareFunction to work on the unformatted value. ________________________________________ From: flexcoders@yahoogroups.com [mailto:flexcoders@yahoogroups.com] On Behalf Of [EMAIL PROTECTED] Sent: Friday, October 07, 2005 2:17 PM To: flexcoders@yahoogroups.com Subject: RE: [flexcoders] date sort Ya I have tried that but from I understand that only work when the date is from cell renderer. Mine is coming from a java object and is using label to format it. CONFIDENTIALITY STATEMENT - This message and any files or text attached to it are intended only for the recipients named above, and contain information that may be confidential or privileged.  If you are not an intended recipient, you must not read, copy, use, or disclose this communication.  Please also notify the sender by replying to this message, and then delete all copies of it from your system.  Thank you. "Matt Chotin" <[EMAIL PROTECTED]> Sent by: flexcoders@yahoogroups.com 10/05/2005 05:27 PM Please respond to flexcoders@yahoogroups.com To <flexcoders@yahoogroups.com> cc Subject RE: [flexcoders] date sort If it's not working by default you may want to look into the sortCompareFunction on DataGridColumn.   Matt   ________________________________________ From: flexcoders@yahoogroups.com [mailto:flexcoders@yahoogroups.com] On Behalf Of Joe Sent: Wednesday, October 05, 2005 2:33 PM To: flexcoders@yahoogroups.com Subject: [flexcoders] date sort   Is there a way to sort a date field in a data grid that is using a labelfunction to get the date value. I have read that it can be done when using a cell renderer, but I do not want to change the code. Can this be done? Thanks. -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com SPONSORED LINKS Web site design development Computer software development Software design and development Macromedia flex Software development best practice ________________________________________ YAHOO! GROUPS LINKS *  Visit your group "flexcoders" on the web.   *  To unsubscribe from this group, send an email to: [EMAIL PROTECTED]   *  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ________________________________________ -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com SPONSORED LINKS Web site design development Computer software development Software design and development Macromedia flex Software development best practice ________________________________________ YAHOO! GROUPS LINKS *  Visit your group "flexcoders" on the web.   *  To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]   *  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ________________________________________ -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com SPONSORED LINKS Web site design development Computer software development Software design and development Macromedia flex Software development best practice ________________________________________ YAHOO! GROUPS LINKS *  Visit your group "flexcoders" on the web.   *  To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]   *  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ________________________________________ -- Flexcoders Mailing List FAQ: http://groups.yahoo.com/group/flexcoders/files/flexcodersFAQ.txt Search Archives: http://www.mail-archive.com/flexcoders%40yahoogroups.com SPONSORED LINKS Web site design development Computer software development Software design and development Macromedia flex Software development best practice YAHOO! GROUPS LINKS  Visit your group "flexcoders" on the web.    To unsubscribe from this group, send an email to:  [EMAIL PROTECTED]    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.