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