topic Re: Flex select and zoom to a feature by values from datagrid in ArcGIS Viewer for Flex Questions

Flex select and zoom to a feature by values from datagrid

LiYao — Wed, 19 Nov 2014 08:20:43 GMT

Dear all,

In my flex application, I have a function to retrieve feature attributes in a datagrid.

In the datagrid, I add a context menu "Select and Zoom", when click this context menu on a selected row, I need to select and zoom to the feature based on the "Item No" and "Item Sub No" value.

The feature layer is a polyline layer.

I tried to find a solution from ESRI smaple, but no luck. Could anybody please give me help on this? Thanks a lot.

I am using Adobe Flash Builder 4.6 and arcgis api for flex 3.6.

Re: Flex select and zoom to a feature by values from datagrid

RobertScheitlin__GISP — Wed, 19 Nov 2014 13:57:18 GMT

Li Yao,

Is your datagrid populated by a QueryTask results (i.e. Graphics.attributes)? What code do you currently have for the Select and Zoom function?

Re: Flex select and zoom to a feature by values from datagrid

LiYao — Thu, 20 Nov 2014 06:04:51 GMT

Hi Robert,

It is select by attribute, I found Mark Hoyland's sample which based on your eSearch.

function onSelectItem(e:ContextMenuEvent):void{

if(datagrid.selectedIndex >= 0){

"selected Item No = " + datagrid.selectedItem.itemNo);

"selected Item Sub No = " + datagrid.selectedItem.itemSubNo);

this.cursorManager.setBusyCursor();

var query:Query = new Query;

query.where = "SELECT * from dev_db.DBO.ItemDetails WHERE Item_No = '" + datagrid.selectedItem.itemNo + "' and Sub_No = '" + datagrid.selectedItem.itemSubNo + "'";

new AsyncResponder(onSelectResult, onSelectFault, targetLayer));
else{

"Select a record first","ATTENTION");

}

private function onSelectResult(info:Array, token:FeatureLayer = null😞void {

this.cursorManager.removeBusyCursor();

var fl:FeatureLayer = token;

if (fl.selectedFeatures.length == 0)

"Selection completed but found no features. Please check your parameters." ,

"Nothing Found", Alert.OK);

}

private function onSelectFault(info:Object, token:Object = null😞void

{
this.cursorManager.removeBusyCursor();

"Could not complete Selection. Please try again.\n" + info.toString(),

"Selection Error", Alert.OK);

}

All features are in the layer dev_db.DBO.ItemDetails, but never select the feature and the busy icon there.

Thanks a lot for the patient and attention.

Re: Flex select and zoom to a feature by values from datagrid

RobertScheitlin__GISP — Thu, 20 Nov 2014 13:52:10 GMT

Li Yao,

I we where you are defining your Query object in your code and setting the busy cursor but I don not see where you are actually executing the QueryTask . Like this:

queryTask.execute(query, new AsyncResponder(onResult, onFault));

Re: Flex select and zoom to a feature by values from datagrid

LiYao — Fri, 21 Nov 2014 07:14:36 GMT

Hi Robert,

I have updated my onSelectItem in the mxml file as follows:

private function onSelectItem(e:ContextMenuEvent):void{
if(datagrid.selectedIndex >= 0){
Alert.show("selected Segment Id = " + datagrid.selectedItem.itemNo);
Alert.show("selected BQ No = " + datagrid.selectedItem.itemSubNo);

this.cursorManager.setBusyCursor();
var query:Query = new Query;

query.where = "SELECT * from geri_db.DBO.BQ_Segment_1 WHERE Item_No = '" + datagrid.selectedItem.itemNo + "' and Sub_No = '" + datagrid.selectedItem.itemSubNo + "'";
queryTask.execute(query, new AsyncResponder(onResult, onFault));

function onResult(featureSet:FeatureSet, token:Object = null):void
{
   myGraphicsLayer.clear();

   if (featureSet.features.length == 0)
   {
    Alert.show("No feature found. Please try again.");
   }
   else
   {
    var unionExtent:Extent;
    var myFirstGraphic:Graphic = featureSet.features[0];
    unionExtent = Polyline(myFirstGraphic.geometry).extent;

    for each (var myGraphic1:Graphic in featureSet.features)
    {
     myGraphicsLayer.add(myGraphic1);
     unionExtent = unionExtent.union(Polyline(myGraphic1.geometry).extent);
    }

    MainMap.extent = unionExtent;
   }
}
function onFault(info:Object, token:Object = null):void
{
   Alert.show(info.toString());
}

}else{
Alert.show("Select a record first","ATTENTION");
}
}

The related components in the mxml is like follows:

<esri:QueryTask id="queryTask"
url="http://localhost:6080/arcgis/rest/services/MyService/MapServer/1"/>
<esri:QueryTask id="queryTaskZoom"
url="http://localhost:6080/arcgis/rest/services/MyService/MapServer/1"/>

<esri:Query id="query" returnGeometry="true" outSpatialReference="{MainMap.spatialReference}">
</esri:Query>

<esri:Map id="MainMap">
<esri:extent>
   <esri:Extent xmin="-126" ymin="24" xmax="-67" ymax="50">
    <esri:SpatialReference wkid="4326"/>
   </esri:Extent>
</esri:extent>
<esri:ArcGISDynamicMapServiceLayer
   url="http://10.180.8.144:6080/arcgis/rest/services/MyService/MapServer"/>
<esri:GraphicsLayer id="myGraphicsLayer" symbol="{sfs}" graphicProvider="{lastIdentifyResultGraphic}"/>
</esri:Map>

But got "RPC Fault 400" warning as displayed here:

Thanks a lot for the help.

Re: Flex select and zoom to a feature by values from datagrid

RobertScheitlin__GISP — Fri, 21 Nov 2014 13:02:38 GMT

Li Yao,

Well I was expecting to see the QueryTask created in the onSelectItem function using action script. an I have no idea why you are showing me a mxml map object as the viewer uses a action script map object from the MapManager.as and each widget has access to that map...

I think it would be best for you to add an attachment with your whole widget code so I can clear see what you are doing.

Re: Flex select and zoom to a feature by values from datagrid

LiYao — Mon, 24 Nov 2014 02:11:16 GMT

Hi Robert,

I have attached my widget package. I am using asp.net to retrieve the data from sql server database. The part of retrieving the data is handled by others, currently I am using a example sql query statement in asp.net (that means every time I will get the same result in the datagrid), what I am focusing is the map part.

In "Attribute Search" widget, what I am testing is onclick the "Ok" button and open the datagridview (attribute search results widget).

Seems I am very far away from the correct way, so sorry to trouble you so many times.

Re: Flex select and zoom to a feature by values from datagrid

RobertScheitlin__GISP — Sun, 12 Dec 2021 02:39:07 GMT

Li Yao,

So here is your main issue in the AttributeSearch.mxml:

            public function handleEvent():void
            {
//You don't close the widget that the code is running in using this code
                /*var widgetId:Number = ViewerContainer.getInstance().widgetManager.getWidgetId("Attribute Search");
                AppEvent.dispatch(AppEvent.WIDGET_CLOSE, widgetId);*/

                var widgetId2:Number = ViewerContainer.getInstance().widgetManager.getWidgetId("Attribute Search Results");
//ViewerContainer.dispatchEvent has been depreciated, you should have seen the warning in Flash builder about this
                //ViewerContainer.dispatchEvent(new AppEvent(AppEvent.WIDGET_RUN, widgetId2));
                AppEvent.dispatch(AppEvent.WIDGET_RUN, widgetId2);
//This is how you close the same widget that the code is running in
                this.setState("closed");
            }

In your AttributeSearchResult.mxml

Why you are adding a map component to your widget I am not sure... Do you really want a map inside this widget?...

If you are wanting to add layers to the main Viewers map then just use the map keyword in your widgets code.

</viewer:WidgetTemplate>    
    <esri:Map id="MainMap" width="245" height="42">  
        <esri:extent> 
            <esri:Extent xmin="-126" ymin="24" xmax="-67" ymax="50">  
                <esri:SpatialReference wkid="4326"/>  
            </esri:Extent>  
        </esri:extent>  
        <esri:ArcGISDynamicMapServiceLayer  
            url="http://localhost:6080/arcgis/rest/services/MyService/MapServer"/>  
        <esri:GraphicsLayer id="myGraphicsLayer" symbol="{sfs}" graphicProvider="{lastIdentifyResultGraphic}"/>  
    </esri:Map>  
</viewer:BaseWidget>

This copy you provided of this widget still has issue that I helped you resolve in another thread. Like you GridColumns need to children of a spark ArrayList. and your results from your web service need to be wrapped in an array collection:

            public function GetLoc(event:ResultEvent):void {
                // Databind data from webservice to datagrid
                datagrid.dataProvider = new ArrayCollection(event.result as Array);
            }

Re: Flex select and zoom to a feature by values from datagrid

LiYao — Mon, 24 Nov 2014 06:43:22 GMT

Hi Robert,

Thanks so much for the help!

Unfortunately, the error still exists.

have updated my code accordingly.

In fact, I don't need the map component in the widget.

For the selection query I have checked in Arcmap. In arcmap the feature really exist and the query works.

There are 3 warning messages in the flash builder:

(1) 1084:function 'onFault' will be scoped to the default namespace:AttributeSearchResult:intenal. It will not be visible outside of this package.

(2) 1084:function 'onResult' will be scoped to the default namespace:AttributeSearchResult:intenal. It will not be visible outside of this package.

(3) widgets.MyService.AttributeSearch:WebserviceTest is a module or application that is directly referenced. This will cause widgets.MyService.AttributeSearch:WebserviceTest and all of its dependencies to be linked in with widgets.MyService.AttributeSearch:AttributeSearch. Using an interface is the recommended practice to avoid this.

Thanks a lot.

Re: Flex select and zoom to a feature by values from datagrid

RobertScheitlin__GISP — Mon, 24 Nov 2014 14:18:19 GMT

Li Yao,

OK, I have commented out many line (unused or unneeded) and made several coding comments, and added some code. Take a look at these changes.

Re: Flex select and zoom to a feature by values from datagrid

LiYao — Tue, 25 Nov 2014 03:51:14 GMT

Hi Robert,

You are so nice, thanks a lot. This time no fault error.

But still 2 issues:

(1) If I use the updated GetLoc() no result displayed in the datagrid.

public function GetLoc(event:ResultEvent):void {

// Databind data from webservice to datagrid

datagrid.dataProvider = new ArrayCollection(event.result as Array);

}

(2) If I use the old GetLoc function, result will display, but when I try to use "select and zoom", still the same, only the busy cursor there.

This time I use another layer and query on the Segment_ID only, the following is what can found in the querytask url.

and query.where = "Segment_ID ='1988/03-1'"; //this time use exact value to test

And what I see in manually select this feature:

But still not work. So sorry to trouble so much, but this one drive me crazy.

Re: Flex select and zoom to a feature by values from datagrid

RobertScheitlin__GISP — Sun, 12 Dec 2021 02:39:10 GMT

Li Yao,

So have you inspected the query.where string to see if it is what you are expecting by placing a breakpoint in your code or a trace like this:

                        query.where = "Item_No = '" + datagrid.selectedItem.itemNo + "' and Sub_No = '" + datagrid.selectedItem.subNo + "'";
                        trace(query.where);

Re: Flex select and zoom to a feature by values from datagrid

LiYao — Wed, 26 Nov 2014 01:09:55 GMT

Hi Robert,

Yes I trace the query statement and also verified it in arcmap.

Thanks.

Re: Flex select and zoom to a feature by values from datagrid

LiYao — Thu, 27 Nov 2014 08:01:49 GMT

Hi Robert,

Currently situation is I can confirm the query feature exists.

BUT the strange thing is in both cases(the feature exists or not exist), it always show the busy cursor.

What may be the possible reason for this problem?

Thanks for the help.

Re: Flex select and zoom to a feature by values from datagrid

RobertScheitlin__GISP — Sun, 12 Dec 2021 02:39:13 GMT

Li Yao,

The portions of your code where you are using this.cursorManager.removeBusyCursor(); are not portions that you actually use. So the the busy cursor will stay unless you put that line in some code that is actually being called.

Maybe try this code update (line 8):

                                var unionExtent:Extent; 
                                var myFirstGraphic:Graphic = featureSet.features[0]; 
                                unionExtent = Polyline(myFirstGraphic.geometry).extent; 
                               
                                for each (var myGraphic1:Graphic in featureSet.features) 
                                { 
                                    graphicsLayer.add(myGraphic1);
                                    if(myGraphic1.geometry !== myFirstGraphic.geometry){
                                        unionExtent = unionExtent.union(Polyline(myGraphic1.geometry).extent);
                                    }
                                } 
                                map.extent = unionExtent;

Re: Flex select and zoom to a feature by values from datagrid

LiYao — Tue, 02 Dec 2014 01:50:30 GMT

Thank you Robert for the help on this topic.

But the problem still there. I trace the progress and find the application stuck at this line:

unionExtent = Polyline(myFirstGraphic.geometry).extent;

And I found the code will NOT satisfy the condition of :(myGraphic1.geometry !== myFirstGraphic.geometry).

Thanks!

Re: Flex select and zoom to a feature by values from datagrid

RobertScheitlin__GISP — Tue, 02 Dec 2014 13:35:31 GMT

Li Yao,

So are you sure that myFirstGraphic.geometry is not null? Are you sure that the geometry is actually a Polyline?

Re: Flex select and zoom to a feature by values from datagrid

LiYao — Wed, 03 Dec 2014 03:10:05 GMT

Hi Robert,

Yes myFirstGraphic.geometry is not null and the geometry is polyline.

The code seems partially work now, it can zoom to the feature but not select the feature.

Is there anything missing?

Thanks a lot!!

Re: Flex select and zoom to a feature by values from datagrid

LiYao — Mon, 08 Dec 2014 02:59:32 GMT

Hi Robert,

I have 2 layers (1 polyline, 1 polygon). I use the same code (except to change polyline to polygon), it works properly (zoom to the feature, also select the feature).

Since this thread is too long, I create a new thread to make it clear. thanks.