Thanks for the reply. I'll post the request, the datagrid and the current custom sorters I have now. I will also post a snippet example of what the returned XML would look like. One of the xml fields is called "isMine" which is "true" if the item is owned by the website owner, and "false" if the item is owned by another person. What I want is a checkbox that if clicked will display all the isMine=true items in a group first, then all the isMine=false items after that, yet still sort by price, quantity, whatever. So basically grouping the two types of results together while still sorting by the user selection of price or quantity etc. I found a tutorial online that talks about programmatically sorting by multiple fields but it seemed to only work on an ArrayCollection and threw an error when I tried to implement it with the XML results.
<!-- Data Request -->
<mx:HTTPService url="{siteURL}/includes/tnProxy.cfm" method="GET" id="ticketData" result="ticketContentHandler(event)" resultFormat="e4x">
<mx:request>
<proxyType>Tickets</proxyType>
<websiteConfigID>{configIDIN}</websiteConfigID>
<eventID>{eventIDIN}</eventID>
</mx:request>
</mx:HTTPService>
<!-- Sample XML -->
<?xml version="1.0" encoding="utf-8"?>
<ArrayOfTicketGroup>
<TicketGroup>
<ActualPrice>853.00</ActualPrice>
<PriceSort>853.0001</PriceSort>
<ID>669223682</ID>
<IsMine>false</IsMine>
<Row>12</Row>
<Section>BL 203</Section>
<ValidSplits>
<int>4</int>
<int>2</int>
</ValidSplits>
</TicketGroup>
<TicketGroup>
<ActualPrice>2073.00</ActualPrice>
<PriceSort>2073.0001</PriceSort>
<ID>669224623</ID>
<IsMine>true</IsMine>
<Row>17</Row>
<Section>224</Section>
<ValidSplits>
<int>4</int>
<int>2</int>
</ValidSplits>
</TicketGroup>
</ArrayOfTicketGroup>
<!-- Datagrid to display XML results -->
<mx:DataGrid id="ticketGrid" width="100%" height="100%" dataProvider="{tixXML}" rowHeight="40" wordWrap="true" resizableColumns="true" verticalAlign="middle" paddingBottom="2" paddingLeft="2" paddingRight="2" paddingTop="2" borderThickness="1" rollOverColor="#dbdcc9" selectionColor="#B5BFA7" textAlign="center" cornerRadius="5" borderStyle="solid" borderColor="#b7babc">
<mx:columns>
<mx:DataGridColumn width="75" dataField="Section" headerText="Sec" wordWrap="true" resizable="true" />
<mx:DataGridColumn width="60" dataField="Row" headerText="Row" wordWrap="true" resizable="true" />
<mx:DataGridColumn width="60" headerText="Quantity" resizable="false" sortCompareFunction="compareQuantity" itemRenderer="renderers.rend_Quantity"/>
<mx:DataGridColumn width="85" dataField="ActualPrice" headerText="Our Price" wordWrap="false" textAlign="center" resizable="true" sortCompareFunction="comparePrice" itemRenderer="renderers.rend_Price"/>
<mx:DataGridColumn width="55" textAlign="center" resizable="false" sortable="false" itemRenderer="renderers.rend_BuyButton"/>
</mx:columns>
</mx:DataGrid>
// custom sorter for sorting Actual Price numerically.
private function comparePrice(itemA:Object, itemB:Object):int
{
return ObjectUtil.numericCompare(itemA.PriceSort, itemB.PriceSort);
}
// custom sorter for sorting Quantity of tickets numerically.
private function compareQuantity(itemA:Object, itemB:Object):int
{
return ObjectUtil.numericCompare(itemA.ValidSplits.int[0], itemB.ValidSplits.int[0]);
}