Share on Google+Share on Google+

Sorting by multiple columns in AdvancedDataGrid in Flex4

Advertisement
In this example you can see how we can sort a AdvancedDataGrid control using multiple column .

Sorting by multiple columns in AdvancedDataGrid in Flex4:

In this example you can see how we can sort a AdvancedDataGrid control using multiple column . We will set a sortExpertMode property. It is a Boolean type. If it is false and you click on any column then it will be sort in ascending order after that you click on another column the AdvancedDataGrid will be sort by this column. If it is true then you can sort whole AdvancedDataGrid. You will click on one column then it will be sort by this column after that you will press ctrl key and you will choose a multiple column for sort a AdvancedDataGrid control.

Example:

<?xml version="1.0" encoding="utf-8"?>

<s:Application xmlns:fx="http://ns.adobe.com/mxml/2009"

xmlns:s="library://ns.adobe.com/flex/spark"

xmlns:mx="library://ns.adobe.com/flex/mx"

minWidth="955" minHeight="600">

<fx:Script>

<![CDATA[

import mx.collections.ArrayCollection;

[Bindable]

private var student:ArrayCollection = new ArrayCollection([

{Course:"Course", children: [

{CourseName:"B.Sc.", children:[

{Branch:"Physics", Girls:60, Boys:120, TotalStudent:180, PASSinper:98.0, FAILinper:2.0},

{Branch:"Chemistry", Girls:100, Boys:50, TotalStudent:150, PASSinper:97.0, FAILinper:3.0},

{Branch:"Mathematics", Girls:50, Boys:150, TotalStudent:200, PASSinper:98.5, FAILinper:1.5}]},

{CourseName:"B.tech.", children:[

{Branch:"CS", Girls: 45, Boys:75, TotalStudent:120, PASSinper:99.0, FAILinper:1.0},

{Branch:"IT", Girls: 55, Boys:65, TotalStudent:120, PASSinper:99.5, FAILinper:0.5},

{Branch:"EC", Girls: 25, Boys:95, TotalStudent:120, PASSinper:96.7, FAILinper:3.3},

{Branch:"EI", Girls: 40, Boys:80, TotalStudent:120, PASSinper:95, FAILinper:5},

{Branch:"Mechanical", Girls:10, Boys: 80, TotalStudent:90, PASSinper:97.5, FAILinper:2.5},

{Branch:"Civil", Girls: 15, Boys:45, TotalStudent:60, PASSinper:92, FAILinper:8}]},

{CourseName:"B.Pharma.", children:[

{Branch:"Pharmacy", Girls:70, Boys:130, TotalStudent:200, PASSinper:99.8, FAILinper:0.2}]},

{CourseName:"M.B.A.", children:[

{Branch:'HR', Girls:48, Boys:72, TotalStudent:120, PASSinper:100, FAILinper:0},

{Branch:'Finance', Girls:40, Boys:80, TotalStudent:120, PASSinper:85, FAILinper:15},

{Branch:'Marketing', Girls:20, Boys:100, TotalStudent:120, PASSinper:99, FAILinper:1},

{Branch:'IT & HR', Girls:30, Boys:90, TotalStudent:120, PASSinper:100, FAILinper:0}]},

{CourseName:"M.C.A.", children:[

{Branch:"Computer Science", Girls:30, Boys:90, TotalStudent: 120, PASSinper:99.1, FAILinper:0.9}]}

]}

]);

]]>

</fx:Script>

<s:Panel title="Sorting by multiple columns in AdvancedDataGrid" height="422" width="756">

<mx:AdvancedDataGrid

sortExpertMode="true"

height="363"

x="13" y="13"

width="730">

<mx:dataProvider>

<mx:HierarchicalData source="{student}"/>

</mx:dataProvider>

<mx:columns>

<mx:AdvancedDataGridColumn dataField="Course"/>

<mx:AdvancedDataGridColumn dataField="CourseName" headerText="CourseName"/>

<mx:AdvancedDataGridColumn dataField="Branch"/>

<mx:AdvancedDataGridColumn dataField="Girls"/>

<mx:AdvancedDataGridColumn dataField="Boys"/>

<mx:AdvancedDataGridColumn dataField="TotalStudent"/>

<mx:AdvancedDataGridColumn dataField="PASSinper"/>

<mx:AdvancedDataGridColumn dataField="FAILinper"/>

</mx:columns>

</mx:AdvancedDataGrid>

</s:Panel>

</s:Application>

Output:

Running Application:

To view this page ensure that Adobe Flash Player version 10.0.0 or greater is installed.

Download this code

Advertisements

Posted on: June 14, 2010 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Share this Tutorial Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.