topic Re: Filling Datagrid with FeatureSet Values. in ArcGIS API for Flex Questions

Filling Datagrid with FeatureSet Values.

EvelynHernandez — Fri, 21 Feb 2014 14:02:55 GMT

Hey guys im trapped in this.
I want to fill a datagrid with values obtained from a featureset but i dont know how to get the parameters to put each one in the column that i want. Also the datagrid it is empty !!

Thanks for all the help.

//the Grid.  <mx:DataGrid  id="gridEquipos" x="2" y="5" width="100%" height="100%" visible="true" editable="false" dragEnabled="true" dropEnabled="true" dataProvider="{listaEquipos}" itemClick="gridEquipos_itemClickHandler(event)">                                                <mx:columns>                                                                <mx:DataGridColumn headerText="Código Equipo / Medidor" dataField="id_eq" id="IDEquipo"/>                                                                <mx:DataGridColumn headerText="Cant. Luminarias" dataField="cantLum" id="CantLuminarias"/>                                                                <mx:DataGridColumn headerText="Cant. Tramos" dataField="cantTram" id="CantTramos"/>                                                                <mx:DataGridColumn headerText="Tipo Conexión" dataField="tipoConn" id="TipoConexion"/>                                                                <mx:DataGridColumn headerText="NIS Cliente" dataField="nisClie" id="NisCliente"/>                                                                <mx:DataGridColumn headerText="??lt. Fact." dataField="observ" id="ultimaFacturacion"/>                                                </mx:columns>                                </mx:DataGrid>     //Filling grid function                 protected function gridEquipos_itemClickHandler(event:ListEvent):void                                                {                                                                   gridEquipoxTramo();                                                                var seleccionado:String = new String;                                                                seleccionado = gridEquipos.selectedItem.toString();                                                                acPolyline.removeAll();                                                                var queryTaskEquipoSelected:QueryTask = new QueryTask();                                                                queryTaskEquipoSelected.url = "http://gisred.chilquinta.cl:5555/arcgis/rest/services/AP_Municipal/AP_LA_CRUZ/MapServer/5";                                                                queryTaskEquipoSelected.useAMF = false;                                                                var queryEquipoSelected:Query = new Query();                                                                queryEquipoSelected.outFields = ["*"];                                                                queryEquipoSelected.returnGeometry = true;                                                                                                                                queryEquipoSelected.where = "ARCGIS.DBO.MEDIDORES_AP_006.id_medidor=" + seleccionado;                                                                queryEquipoSelected.spatialRelationship ="esriSpatialRelIntersects";                                                                queryEquipoSelected.outSpatialReference = myMap.spatialReference;                                                                queryTaskEquipoSelected.execute(queryEquipoSelected, new AsyncResponder(onResult, onFault));                                                                listaEquipos.removeAll();                                                                                                                                                                                                                                                function onResult(featureSet:FeatureSet, token:Object = null):void                                                                {                                                                               try{                                                                                               for each (var myGraphic:Graphic in featureSet.features)                                                                                               {                                                                                                                                                                                                                                 myGraphic.symbol=slsFind;                                                                                               //            myGraphic.symbol= infoButton;                                                                                               //            infoB=seleccionado;                                                                                                               graphicsLayer.add(myGraphic);                                                                                                                acPolyline.addItem(graphicsLayer);                                                                                                               myMap.zoomTo(featureSet.features[0].geometry);                                                                                                                                                                  myMap.level = 16;                                                                                               }                                                                                                                                                                              }catch(err:Error){                                                                                               Alert.show("no se pudo cargar el tramo");                                                                               }                                                                                                                                               }                                                                                                                                function onFault(info:Object, token:Object = null):void                                                                {                                                                                  Alert.show("id de equipo no encontrada");                                                                }                                                }

Re: Filling Datagrid with FeatureSet Values.

RobertScheitlin__GISP — Fri, 10 Dec 2021 20:45:01 GMT

Evelyn,

It should be as simple as:

function onResult(featureSet:FeatureSet, token:Object = null):void
  {
    try{
      listaEquipos = new ArrayCollection(featureSet.attributes);
      for each (var myGraphic:Graphic in featureSet.features)
      {   
        myGraphic.symbol=slsFind;
        //myGraphic.symbol= infoButton;
        //infoB=seleccionado;
        graphicsLayer.add(myGraphic); 
        acPolyline.addItem(graphicsLayer);
        myMap.zoomTo(featureSet.features[0].geometry);                                                   
        myMap.level = 16;
      }
    }catch(err:Error){
      Alert.show("no se pudo cargar el tramo");
    }
  }

Re: Filling Datagrid with FeatureSet Values.

EvelynHernandez — Fri, 10 Dec 2021 20:45:04 GMT

rscheitlin,

Ok i did this , how u said

protected function equiposAP_clickHandler(event:MouseEvent):void
   { 
    
    //Ver panel medidores
    TWMedidores.visible="true";
    
    var queryTaskEquipo:QueryTask = new QueryTask();
    queryTaskEquipo.url = "http://gisred.chilquinta.cl:5555/arcgis/rest/services/AP_Municipal/AP_LA_CRUZ/MapServer/5";
    queryTaskEquipo.useAMF = false;
    var queryEquipo:Query = new Query();
    queryEquipo.outFields = ["*"];
    queryEquipo.returnGeometry = false;
    queryEquipo.where = "1=1";
    queryTaskEquipo.execute(queryEquipo, new AsyncResponder(onResult, onFault));
    
     function onResult(featureSet:FeatureSet, token:Object = null):void
    { 
     
     listaEquipos = new ArrayCollection(featureSet.attributes);
     
     
    }
    function onFault(info:Object, token:Object = null):void
    {
     Alert.show("no se puede cargar equipo "+ info.toString());
    }
    gridEquipos.dataProvider(listaEquipos); 
   }

But i still dont know if it is correct in the grid call the fields like this.
In the map server , the fields have those names, but i dont know if the arrayCollection will keep those names or i have to rename them.
I did that and my grid still doesnt work.. it doesnt show anything 😞
Thanks for ur help.

<mx:DataGrid  id="gridEquipos" x="2" y="5" width="100%" height="100%" visible="true" editable="false" dragEnabled="true" dropEnabled="true" itemClick="gridEquipos_itemClickHandler(event)" dataProvider="{listaEquipos}">
   <mx:columns>
    <mx:DataGridColumn headerText="Código Equipo / Medidor" dataField="ARCGIS.DBO.MEDIDORES_AP_006.id_medidor" id="id_equipo"/>
    <mx:DataGridColumn headerText="Tipo Conex." dataField="ARCGIS.DBO.MEDIDORES_AP_006.tipo_conexion" id="tipo_conex"/>
    <mx:DataGridColumn headerText="Cant. Tramos" dataField="ARCGIS.DBO.MEDIDORES_AP_006.tramos_ap" id="cant_tramos"/>
    <mx:DataGridColumn headerText="Nro. NIS" dataField="ARCGIS.DBO.MEDIDORES_AP_006.nis" id="nro_nis"/>
    <mx:DataGridColumn headerText="Cant. Luminarias" dataField="ARCGIS.DBO.MEDIDORES_AP_006.luminarias" id="cant_luminarias"/>
   </mx:columns>
  </mx:DataGrid>

Re: Filling Datagrid with FeatureSet Values.

RobertScheitlin__GISP — Fri, 10 Dec 2021 20:45:06 GMT

Evelyn,

Here is a working sample. You will see that your issue is likely that you are trying to assign the datagrids data provider in your equipoAP_clickHandler. This is an issue because the results of the query are not completed before it gets to that line of code and actually that line is not needed at all as you have already defined the dataProvider in the datagrid attributes.

<?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"
               xmlns:esri="http://www.esri.com/2008/ags">
    <fx:Declarations>
        <!-- Place non-visual elements (e.g., services, value objects) here -->
    </fx:Declarations>
    <fx:Script>
        <![CDATA[
            import com.esri.ags.FeatureSet;
            import com.esri.ags.tasks.QueryTask;
            import com.esri.ags.tasks.supportClasses.Query;
            
            import mx.collections.ArrayCollection;
            import mx.controls.Alert;
            import mx.events.ListEvent;
            import mx.rpc.AsyncResponder;
            
            [Bindable]
            private var listaEquipos:ArrayCollection;
            
            protected function equiposAP_clickHandler(event:MouseEvent):void
            {    
                var queryTaskEquipo:QueryTask = new QueryTask();
                queryTaskEquipo.url = "http://sampleserver1.arcgisonline.com/ArcGIS/rest/services/Louisville/LOJIC_LandRecords_Louisville/MapServer/2";
                queryTaskEquipo.useAMF = false;
                var queryEquipo:Query = new Query();
                queryEquipo.outFields = ["*"];
                queryEquipo.returnGeometry = false;
                queryEquipo.where = "1=1";
                queryTaskEquipo.execute(queryEquipo, new AsyncResponder(onResult, onFault));
                
                function onResult(featureSet:FeatureSet, token:Object = null):void
                { 
                    listaEquipos = new ArrayCollection(featureSet.attributes); 
                }
                function onFault(info:Object, token:Object = null):void
                {
                    Alert.show("no se puede cargar equipo "+ info.toString());
                }
                //No need for this
                //gridEquipos.dataProvider(listaEquipos); 
            }
            
            protected function gridEquipos_itemClickHandler(event:ListEvent):void
            {
                // TODO Auto-generated method stub
                
            }
            
        ]]>
    </fx:Script>
    <s:controlBarLayout>
        <s:VerticalLayout gap="10"
                          paddingBottom="7"
                          paddingLeft="10"
                          paddingRight="10"
                          paddingTop="7"/>
    </s:controlBarLayout>
    <s:controlBarContent>
        <s:RichText width="100%">
            This sample demonstrates how to populate a datagrid with the results of a querytask
        </s:RichText>
        <s:Button id="popButton"
                  click="equiposAP_clickHandler(event)"
                  label="execute query..."/>
    </s:controlBarContent>
    <mx:DataGrid  id="gridEquipos" width="100%" height="100%" visible="true" editable="false" dragEnabled="true" dropEnabled="true" itemClick="gridEquipos_itemClickHandler(event)" dataProvider="{listaEquipos}">
        <mx:columns>
            <mx:DataGridColumn headerText="Código Equipo / Medidor" dataField="OBJECTID" id="id_equipo"/>
            <mx:DataGridColumn headerText="Tipo Conex." dataField="ZONING_CODE" id="tipo_conex"/>
            <mx:DataGridColumn headerText="Cant. Tramos" dataField="ZONING_NAME" id="cant_tramos"/>
            <mx:DataGridColumn headerText="Nro. NIS" dataField="ZONING_TYPE" id="nro_nis"/>
        </mx:columns>
    </mx:DataGrid>
</s:Application>

Re: Filling Datagrid with FeatureSet Values.

EvelynHernandez — Mon, 24 Feb 2014 12:57:26 GMT

rscheitlin,

Yeah, you example works perfectly.
I tried to change my map and parameters into ur example but i receive an error trying to make a query

RPC Fault faultString="Token Required" faultCode="499" faultDetail=""]

The map query is http://gisred.chilquinta.cl:5555/arcgis/rest/services/AP_Municipal/AP_LA_CRUZ/MapServer/5
and some of the values that i want to obtain are
ARCGIS.DBO.MEDIDORES_AP_006.id_medidor ( type: esriFieldTypeString , alias: id , length: 50 )
ARCGIS.DBO.MEDIDORES_AP_006.propiedad ( type: esriFieldTypeString , alias: propiedad , length: 99 )

i dont know what is happening 😞
Thanks for ur patience ! !

Re: Filling Datagrid with FeatureSet Values.

RobertScheitlin__GISP — Mon, 24 Feb 2014 13:09:01 GMT

Evelyn,

That makes sense as your map service you are trying to use is secured. You will have to obtain a token and add that token to the queryTask.

Re: Filling Datagrid with FeatureSet Values.

EvelynHernandez — Mon, 24 Feb 2014 14:33:00 GMT

rscheitlin,

I did that already putting the token in the code.
The onResult add the features.attributes on the arraycollection, but the grid still doesnt show anything 😞

Re: Filling Datagrid with FeatureSet Values.

RobertScheitlin__GISP — Mon, 24 Feb 2014 14:43:28 GMT

Evelyn,

Are you still getting that same error RPC Fault faultString="Token Required" faultCode="499" faultDetail=""]?

Re: Filling Datagrid with FeatureSet Values.

EvelynHernandez — Fri, 10 Dec 2021 20:45:09 GMT

No.
In the onresult i put this alert to see if the query is going to pass through other side, but it shows the alert "did it", so i assume that the AC has the data given from the featureset.

Maybe it is something wrong with the datagrid.

I have this on my dgrid.

<mx:DataGrid  id="gridEquipos" width="30%" height="30%" visible="true" editable="false" dragEnabled="true" dropEnabled="true" itemClick="gridEquipos_itemClickHandler(event)" dataProvider="{listaEquipos}">
   <mx:columns>
    <mx:DataGridColumn headerText="Código Equipo / Medidor" dataField="ARCGIS.DBO.MEDIDORES_AP_006.id_medidor"/>
    
   </mx:columns>
  </mx:DataGrid>

and this is the onresult function.

function onResult(featureSet:FeatureSet, token:Object = null):void
    { 
     listaEquipos = new ArrayCollection(featureSet.attributes);
     Alert.show("did it");
     
    }

Thanks for ur patience !

Re: Filling Datagrid with FeatureSet Values.

RobertScheitlin__GISP — Mon, 24 Feb 2014 14:58:56 GMT

Evelyn,

Are you sure your field names need to be fully qualified like you have them?

dataField="ARCGIS.DBO.MEDIDORES_AP_006.id_medidor"

maybe try

dataField="id_medidor"

again.

Re: Filling Datagrid with FeatureSet Values.

EvelynHernandez — Mon, 24 Feb 2014 15:08:25 GMT

Yes i just tried and it doesnt work.
The grid is still in blank....

Also i tried making another grid but it doesnt work either.
Is there a way to know the attribute field's name to see if maybe it is that...
Thanks for ur patience!

Re: Filling Datagrid with FeatureSet Values.

EvelynHernandez — Mon, 24 Feb 2014 15:11:06 GMT

rscheitlin,

Yes i just tried and it doesnt work.
The grid is still in blank....

Is there a way to know the attribute field's name to see if maybe it is that...
Thanks for ur patience!

Re: Filling Datagrid with FeatureSet Values.

RobertScheitlin__GISP — Mon, 24 Feb 2014 15:11:48 GMT

Evelyn,

You could trace out the results of featureSet.attributes using

trace(ObjectUtil.toString(featureSet.attributes));

Re: Filling Datagrid with FeatureSet Values.

EvelynHernandez — Mon, 24 Feb 2014 15:20:05 GMT

How can i see the trace results?
Because im using a trial version of FB.

Re: Filling Datagrid with FeatureSet Values.

RobertScheitlin__GISP — Mon, 24 Feb 2014 15:26:15 GMT

Evelyn,

Trial version does not matter. When you debug your app using the "little green bug" button to the left of the green play button you will be able to see trace statements in the console window.

Re: Filling Datagrid with FeatureSet Values.

EvelynHernandez — Fri, 10 Dec 2021 20:45:12 GMT

rscheitlin,

It says this

C:\WINDOWS\system32\Macromed\Flash\NPSWF32_12_0_0_70.dll

Flash Builder cannot locate the required debugger version of Adobe Flash Player. You might need to install the debugger version of the Flash Player or reinstall Flash Builder.

Do you want to try to debug with the current version?

And if i run the debugger doesnt show anything.
And i dont know where the console is located.

Re: Filling Datagrid with FeatureSet Values.

RobertScheitlin__GISP — Mon, 24 Feb 2014 15:55:39 GMT

Evelyn,

Don't take this the wrong way, but you need to invest some time reading, Googling, and leaning.

https://developers.arcgis.com/flex/guide/debugging-tips.htm

To be able to use the Flash Debugger you have to install the debugger version of Flash Player (look for the download link for your flavor of web browser):

http://www.adobe.com/support/flashplayer/downloads.html

To find the console window: Window menu > show view > console.

Re: Filling Datagrid with FeatureSet Values.

EvelynHernandez — Tue, 25 Feb 2014 09:47:00 GMT

rscheitlin,

I finally did what i wanted to do with this
Attribute table. It is more easy.

https://developers.arcgis.com/flex/sample-code/attributetable.htm

The only problem that i have now is how to get the value of the cell what was clicked on the attribute table. Even if its the first one or second one.
Thanks.

Re: Filling Datagrid with FeatureSet Values.

RobertScheitlin__GISP — Tue, 25 Feb 2014 11:09:59 GMT

Evelyn,

I think you gave up to soon. Setting up your development environment is going to be very important if you are going to do very much with development in Flex. The trace statement and flash debugger version are great tools for any level of development and spending time getting them ready to use is important.

As far as get a selected cell value from the AttributeTable... I dont work with the Attribute table as it is so much easier for me to setup a spark datagrid. But here is what I think based on the docs:

var at:AttributeTable = new AttributeTable();                 at.dataGrid.selectedItem

Re: Filling Datagrid with FeatureSet Values.

EvelynHernandez — Thu, 27 Feb 2014 13:31:30 GMT

Well i just tried for last time the thing with the datagrid and now it works perfectly.
Really i dont know what happened before, but that makes me to do and learn a lot of new things about alternative ways to face a problem.

I really didnt understand about the trace and debugger and im still learning through googleing.

Thanks for all ur tips (: