This topic provides sample code for filtering details of the DataGrid.

<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" layout="absolute"
    creationComplete="initApp()">
  <mx:Script> 
    <![CDATA[ 
      import mx.charts.HitData; 
      import mx.controls.Alert; 
      import mx.collections.ArrayCollection; 
      public var grid1:ibiObject = new ibiObject(); 
      public var fex:String = "http://localhost:8080/ibi_apps/WFServlet
         ?IBIF_ex=xmltest"; 
      public function initApp():void 
      { 
        grid1.init(fex,dataReady); 
      }

      public function dataReady(grid:ibiObject,obj:*):void
      {  
        grid1.populateGrid(false); 
        regionList.dataProvider = grid1.getUniqueValues("REGION",true); 
        cityList.dataProvider = grid1.getUniqueValues("CITY",true); 
        load_main1(); 
      }
      public function load_main1():void 
      { 
        main1.dataProvider = grid1.prGridfiltered; 
      }

      public function updateRegionGrid():void 
      { 
        var selectedRegion:Array = new Array(); 
        var columnArray:Array = new Array(); 
        var filterOption:Array = new Array(); 
        columnArray.push("REGION"); 
        filterOption.push("EQ"); 
        selectedRegion.push([regionList.selectedItem.toString()]); 
        grid1.filter(columnArray, filterOption, selectedRegion , null, false); 
        load_main1(); 
        cityList.dataProvider = grid1.getUniqueValues("CITY",true); 
      }

      public function updateCityGrid():void 
      { 
        var selectedCity:Array = new Array(); 
        var columnArray:Array = new Array(); 
        var filterOption:Array = new Array(); 
        columnArray.push("CITY"); 
        filterOption.push("EQ"); 
        selectedCity.push([cityList.selectedItem.toString()]); 
        grid1.filter(columnArray, filterOption, selectedCity, null , false); 
        load_main1(); 
      } 
    ]]>
  </mx:Script>

  <mx:DataGrid x="10" y="22" width="281" height="156" id="main1">
    <mx:columns>
      <mx:DataGridColumn headerText="Region" dataField="REGION"/>
      <mx:DataGridColumn headerText="City" dataField="CITY"/>
      <mx:DataGridColumn headerText="Product" dataField="PRODUCT"/>
      <mx:DataGridColumn headerText="Sales" dataField="DOLLARS"/>
    </mx:columns> 
  </mx:DataGrid> 
  <mx:List x="10" y="199" id="regionList" change="updateRegionGrid()"
      height="101" width="129">
  </mx:List> 
  <mx:List x="156" y="199" id="cityList" change="updateCityGrid()"
      height="101" width="135">
  </mx:List>
</mx:Application>

WebFOCUS