Databases
StackOverflow2013
Postsdbo
POconvert remote object result to array collection in flex
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POconvert remote object result to array collection in flex
    text
    copied!<p>HI guys, im using zend_amf and flex. My problem is i have to populate my advance datagrid using array collection. this array collection have a children.</p> <p>example:</p> <pre><code> [Bindable] private var dpHierarchy:ArrayCollection = new ArrayCollection([ {trucks:"Truck", children: [ {trucks:"AMC841", total_trip:1, start_time:'3:46:40 AM'}, {trucks:"AMC841", total_trip:1, start_time:'3:46:40 AM'}]) ]}; </code></pre> <p>but the datasource of my datagrid should come from a database, how can i convert the result from remote object to array collection that has the same format like in my example, or any other way.</p> <p>here is my advance datagrid</p> <pre><code>&lt;mx:AdvancedDataGrid id="datagrid" width="500" height="200" lockedColumnCount="1" lockedRowCount="0" horizontalScrollPolicy="on" includeIn="loggedIn" x="67" y="131"&gt; &lt;mx:dataProvider&gt; &lt;mx:HierarchicalData id="dpHierarchytest" source="{dp}"/&gt; &lt;/mx:dataProvider&gt; &lt;mx:groupedColumns&gt; &lt;mx:AdvancedDataGridColumn dataField="trucks" headerText="Trucks"/&gt; &lt;mx:AdvancedDataGridColumn dataField="total_trip" headerText="Total Trip"/&gt; &lt;mx:AdvancedDataGridColumnGroup headerText="PRECOOLING"&gt; &lt;mx:AdvancedDataGridColumnGroup headerText="Before Loading"&gt; &lt;mx:AdvancedDataGridColumn dataField="start_time" headerText="Start Time"/&gt; &lt;mx:AdvancedDataGridColumn dataField="end_time" headerText="End Time"/&gt; &lt;mx:AdvancedDataGridColumn dataField="precooling_time" headerText="Precooling Time"/&gt; &lt;mx:AdvancedDataGridColumn dataField="precooling_temp" headerText="Precooling Temp"/&gt; &lt;/mx:AdvancedDataGridColumnGroup&gt; &lt;mx:AdvancedDataGridColumnGroup headerText="Before Dispatch"&gt; &lt;mx:AdvancedDataGridColumn dataField="bd_start_time" headerText="Start Time"/&gt; &lt;mx:AdvancedDataGridColumn dataField="bd_end_time" headerText="End Time"/&gt; &lt;mx:AdvancedDataGridColumn dataField="bd_precooling_time" headerText="Precooling Time"/&gt; &lt;mx:AdvancedDataGridColumn dataField="bd_precooling_temp" headerText="Precooling Temp"/&gt; &lt;/mx:AdvancedDataGridColumnGroup&gt; &lt;mx:AdvancedDataGridColumn dataField="remarks" headerText="Remarks"/&gt; &lt;/mx:AdvancedDataGridColumnGroup&gt; &lt;mx:AdvancedDataGridColumnGroup headerText="Temperature Compliance"&gt; &lt;mx:AdvancedDataGridColumn dataField="total_hit" headerText="Total Hit"/&gt; &lt;mx:AdvancedDataGridColumn dataField="total_miss" headerText="Total Miss"/&gt; &lt;mx:AdvancedDataGridColumn dataField="cold_chain_compliance" headerText="Cold Chain Compliance"/&gt; &lt;mx:AdvancedDataGridColumn dataField="average_temp" headerText="Average Temp"/&gt; &lt;/mx:AdvancedDataGridColumnGroup&gt; &lt;mx:AdvancedDataGridColumnGroup headerText="Productivity"&gt; &lt;mx:AdvancedDataGridColumn dataField="total_drop_points" headerText="Total Drop Points"/&gt; &lt;mx:AdvancedDataGridColumn dataField="total_delivery_time" headerText="Total Delivery Time"/&gt; &lt;mx:AdvancedDataGridColumn dataField="total_distance" headerText="Total Distance"/&gt; &lt;/mx:AdvancedDataGridColumnGroup&gt; &lt;mx:AdvancedDataGridColumnGroup headerText="Trip Exceptions"&gt; &lt;mx:AdvancedDataGridColumn dataField="total_doc" headerText="Total DOC"/&gt; &lt;mx:AdvancedDataGridColumn dataField="total_eng" headerText="Total ENG"/&gt; &lt;mx:AdvancedDataGridColumn dataField="total_fenv" headerText="Total FENV"/&gt; &lt;mx:AdvancedDataGridColumn dataField="average_speed" headerText="Average Speed"/&gt; &lt;/mx:AdvancedDataGridColumnGroup&gt; &lt;/mx:groupedColumns&gt; &lt;/mx:AdvancedDataGrid&gt; </code></pre> <p>Thanks, and i really need some help.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload