nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Selection Widget for SFV2.2 (with a query builder)

MarkHoyland

The Selection widget has a "Select by Attributes" and "Select by Location" option similar to ArcGIS.
It has options where you can set your selection type eg New Selection, Add to Selection, Remove from Selection.
Select from multiple layers that interstect/contain etc another layer.
You can view the results for each layer in a datagrid, and export to tab delimited text file.

Widget link: http://www.arcgis.com/home/item.html?id=20ed6af9ab204548bbf092d51b51fef8

I built this because it seemed like a fun project and the temptation of a Flex a Widget T-shirt was too much to resist.:o

If you download please leave feedback and rate the widgets (this should apply to any widget you download) as the feed back really helps to know what users are after.

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

JeffLegato

Mark,
Great widget! I am in the process of configuring it now and am having trouble getting the results to display in the grid. I can successfully run a query and zoom to the selected features but my selection results table remains empty although when I hover over the table the information is highlighted on the map and I can click on the table results and the map zooms to that item. Any ideas?

Also can I configure an alias for the fields?

Thanks!

MarkHoyland

Jeff,
"when I hover over the table the information is highlighted on the map"
So you can see the attribute data in the infowindow? Is this for all of your layers or just one.
Is the data you are querying available external so I can have a look.
Could you post your SelectionWidget.xml file.

Alias are net set up for this widget.

JeffLegato

I can see the attribute data in the info widow. Sorry, this app is internal so I can't share it with you but you can see the screenshot...

https://picasaweb.google.com/lh/photo/MRAgqqb33p2IAU0QMogAXg?feat=directlink

<?xml version="1.0" ?>
<configuration>
    <layers>
        <layer>
            <name>Parcels</name>
            <url>http://pacific/ArcGIS/rest/services/Planning/SLOCO_Parcels_CD_LU/MapServer/0</url&gt;
            <titlefield>SLOCO.SDE.SLO_PARCEL_CD_LU.APN</titlefield>
            <linkfield>SLOCO.SDE.PLN_Tidemark_pmt.link</linkfield>
            <fields>
                  <field name="SLOCO.SDE.SLO_PARCEL_CD_LU.APN"/> 
    <field name="SLOCO.SDE.SLO_PARCEL_CD_LU.ASSESSEE" alias="Assessee"/> 
    <field name="SLOCO.SDE.SLO_PARCEL_CD_LU.C_O"/>
    <field name="SLOCO.SDE.SLO_PARCEL_CD_LU.ADDRESS_1"/>
    <field name="SLOCO.SDE.SLO_PARCEL_CD_LU.CITY"/>
    <field name="SLOCO.SDE.SLO_PARCEL_CD_LU.STATE"/>
    <field name="SLOCO.SDE.SLO_PARCEL_CD_LU.ZIP"/>
    <field name="SLOCO.SDE.PLN_Tidemark_pmt.link"/>
            </fields>
 <infowindowfields>
                   <field name="SLOCO.SDE.SLO_PARCEL_CD_LU.APN"/> 
    <field name="SLOCO.SDE.SLO_PARCEL_CD_LU.ASSESSEE" alias="Assessee"/> 
    <field name="SLOCO.SDE.PLN_Tidemark_pmt.link"/>
   </infowindowfields>
        </layer>
       
    </layers>
    <zoomscale>5000</zoomscale>
    <info>widgets/InfoTemplates/InfoPopupWidget.swf</info>
</configuration>

DanielOchoa

Mark,

I'll echo the previous - great widget....and I see you are sharing Robs code. Collaboration is one of the keys to success....

Now, just putting it out there....combine the graphical selection tools (circle, square,line, etc) of Rob's eSearch with your query search parameters= perfect search tool!

~ D

MarkHoyland

Jeff,
I think this might be to do with the fully qualified field names. eg SLOCO.SDE.SLO_PARCEL_CD_LU.APN instead of APN
I am guessing you are doing this because your link field is from a different featureclass?
The intended use is that all the fields come from the same featureclass.(layer in the .xml config)
Your link field should be a field in the SLO_PARCEL_CD_LU layer.
Is the link the same for all parcels or different?

Test out your layer without the link field and without the fully qualified names and see if that works.

MarkHoyland

Hi Daniel,
The widget is based on the FlexViewer's built in search widget, with the addition of Robert's unionGeom function. That function is brilliant as it is client side and so quick. It is definately worth looking at what others have done and reusing there work (if permitted of course).

I did think about including graphical selection tools but there were a few widgets that already did this sort of thing, so I decided against it.

But yes a select by Graphic option like ArcGIS would be good.
I will see about adding one.
(I am also happy to include contributions and enhancements from others.)

JeffLegato

Test out your layer without the link field and without the fully qualified names and see if that works.

Yep, that did the trick. Thanks for the help!

That link field is unique but based on the APN so I'll have to experiment a little and see what I can do.

So my suggestions for improvements would be to allow aliases and fully qualified fields so that you can use joined tables. 😉

Seriously though, thanks for all the work you put into these things. My application would be severely lacking if it were not for people like yourself and Robert.

MarkHoyland

Sertact(February 24, 2011)
Great widget. Many thanks for the great job. A small question. When make the selection and the results are returned. The results are not displayed at their correct locations on the map. When I double click from the grid it kind of centers the correct location for that record but again all the others are not displayed correctly. My map service and map are at the same datum which is WGS84. One other thing at your SelectionWidgetUtil.as I realized that you add/subtract 5000 to get the graphic extent of the records selected. I think this value is a bit high if one is using Decimal degrees with wgs84 datum. Any suggestions for these. Many thanks again.

Sertact,
The results are returned as a featurelayer which is a direct representation of the GIS data. If it is not in the correct place it sounds like some sort of projection issue?? If you put the base map that you are using with this widget into ArcGIS and overlay your data on top of it, does it line up correctly. Is your data available externally?

The zoom function in SelectionWidgetUtil.as is copied from one of my other projects which is using projected data. The 5000 was for metres (5 kilometres) So for decimal degrees it would be a bit high. I will update this at some stage (maybe use pan to point xy instead).

SertaçTAKIL

Sertact,
The results are returned as a featurelayer which is a direct representation of the GIS data. If it is not in the correct place it sounds like some sort of projection issue?? If you put the base map that you are using with this widget into ArcGIS and overlay your data on top of it, does it line up correctly. Is your data available externally?

The zoom function in SelectionWidgetUtil.as is copied from one of my other projects which is using projected data. The 5000 was for metres (5 kilometres) So for decimal degrees it would be a bit high. I will update this at some stage (maybe use pan to point xy instead).

Sorry my data is not publicly available. Yes they do line up in ArcGIS. All my service layers are of WGS84 datum with decimal degrees. The strange thing is they are at their right place but the icons that indicate their places are at the wrong place. When I click to a result from the result list it zooms to that feature correctly, and puts the icon to the correct location for that record (and for some others that are close to that feature). But when I pan or zoom in/out I see that the icons for the other results are at the wrong places. Can it be some kind of a refresh issue? I wonder.

That's what I thougt with the zoom issue. no problem with that ridght now.
Thanks for the answer.

MarkHoyland

KDAGIS(March 4, 2011)
I really like this widget, thank you! I have one issue. The layers that I have specified to be in the query drop down list get added to the layers I have listed under my More... button. Even though they are already there. So I wind up then having each layer listed twice under my More... button. I've looked around in the code but haven't identified what code I could take out to make it not add the layers to the More.. button.

Nice pickup, I have looked into this and it seems to be a "feature" of TOC component in the MapSwitcher Widget.
TOC.as in com.esri.viewer.components.toc has en event listener on the map for MapEvent.LAYER_ADD.
It automatically adds the FeatureLayers to the TOC when the map fires the event.

There is a workaround however. In the MapSwitcher.xml file you can tell it to exclude layers.
<layerlist visible="true">
<excludelayer>Louisville Police Facilities</excludelayer>
<excludelayer>Counties</excludelayer>
<excludelayer>States</excludelayer>
</layerlist>

Edit:
Here is a fix for the issue. (Ignore the above workaround.)
Add this listener to the init() function in the SelectionWidget.mxml file. Just add as the first line in init()

private function init():void
{
 map.addEventListener(MapEvent.LAYER_ADD, onLayerAdd, false, 100);

The 100 at the end of the listener gives the listener a high priority.

Add the function in the SelectionWidget.mxml file.

private function onLayerAdd(event:MapEvent):void
{
 event.stopImmediatePropagation();
}

This will stop the TOC.as from being notified that a layer was added to the map.
I will update the source code and recompile on the download page when I get a chance.

KellyEmmons

Perfect, thanks! I also had to add:

import com.esri.ags.events.MapEvent;

And that fixed the issue. Again, this is a great widget. Thanks!

AdamRepsher

Hi Daniel,
The widget is based on the FlexViewer's built in search widget, with the addition of Robert's unionGeom function. That function is brilliant as it is client side and so quick. It is definately worth looking at what others have done and reusing there work (if permitted of course).

I did think about including graphical selection tools but there were a few widgets that already did this sort of thing, so I decided against it.

But yes a select by Graphic option like ArcGIS would be good.
I will see about adding one.
(I am also happy to include contributions and enhancements from others.)

Mark,
First - Great Widget! This is what I have been searching for!

I would love it if you did add on a select by graphic. Yes, others have done it, but not with anything like the full query builder and spatial select that you have created! 🙂

Cheers!
--Adam

DanielOchoa

Mark,

Interesting problem here....when using your Selection Widget in a flexviewer where Robert Scheitlin's TOC widget is open, the TOC widget populates with whatever layers are placed into the Selection Widget XML.

Example - Say I have layer one, layer two and layer three in the drop down of the Selection Widget. The selection widget is not set to preload, but the TOC widget is, and lists, say, 3 map services. If I then activate the Selection Widget, as soon as it opens, the TOC widget then lists layer one, layer two and layer three right above the map services in the TOC, and has them turned on. Unchecking them does nothing - the layer visibility of these additions is not controlled from here. They persist even if the selection widget is turned off. The only way to remove them from the TOC wdiget window is to restart the viewer. So, the addition of these layers to the TOC dont cause any issues, but can be confusing for a potential user to see.

My question - is there any way to prevent or fix it so this doesnt happen?

Thanks

MarkHoyland

Interesting problem here....when using your Selection Widget in a flexviewer where Robert Scheitlin's TOC widget is open, the TOC widget populates with whatever layers are placed into the Selection Widget XML.

Please see above fix in this thread to KDAGIS on the 03-07-2011 02:58 PM, as it sounds like the same thing is happening. I will update the source code on the download page with this fix.

LisaArnold

Hi Mark,

Thanks for the great widget. I had a couple questions for you.

On the Select by Attribute tab, not all of my unique values for each field are loading. Is there a limit to how many unique values it will load? If not, do you have a suggestion of what I might check to resolve this issue?

I am using the widget on data that doesn't turn on until 1:577,791. If I use the widget zoomed out, where some of my other layers are turned on at 1:4,622,324, the tool returns results but does not draw the highlighting. The selected features are only highlighted/drawn if I am zoomed into the level that the actual layer comes on. Since the widget draws the selection in what I think is a graphics layer it is very fast, so i would like it to show up at the zoomed out scale even though the actual map service layer won't draw until the user zooms to a feature. Is there a way to make this happen?

Thanks for your help!

francescodi_vito

hy guys, I downloaded this widget and it's great.
But i have a problems with one field of my map service. the field is set on YES/NO, and when i run the selct by attribute for the YES value all it's ok, but when i set the select for NO value i have a #1009 error and say me that "TypeError: Error # 1009: Can not access a property or method of a null object reference." but but despite this i have a result on a map.
Why?
help me

City_of_Port_Angeles_GIS

Mark,
I seem to be having the same type of problem that Sertac TAKIL was having. When I run a query on just a few point items, the icons show at the correct places. But if I run a query with a lot of point items, the icons are incorrectly placed. This seems to happen only with point data. My polygon data(e.g. Parcels) do not display this behavior. Here is a little bit of oddness associated with this behavior: when the query builder first returns the queried items the basemap flips upside-down then right-side up. The icons are being placed on the upside-down map so when the map flips right-side up the icons are incorrectly placed. Any idea what could be causing this? I am using ArcServer 9.3.1 and FlexViewer 2.2. My site is intended for our utility crews and in-house staff so is not publicly available. Any help would be appreciated.
Thanks,
Billy

MarkHoyland

Lisa,
List not showing all unique values is to do with an ArcGIS Server setting which controls the amount of features allowed to be returned. The setting can be changed in the server. See the comments on the page where you can download the Selection widget as there is an answer in one of the comments.
I am also currently investigating the paging method to retreive the result as this will get all results regardless of the setting. (One of the esri samples uses paging.)

As for the scale issue,the results are returned to a flex featurelayer, which is similar to a graphicslayer, but the featurelayer is based on the actual layer in the msd/mxd. The scale dependant setting is inherited from the mxd/msd.
There is a minscale, maxscale property that can be set for the featurelayer, so yes what you want can be done.

If you want to add this yourself for all layers you can add the two lines in bold below to the init() function in SelectionWidget.MXML.
I will however add this functionality as a configurable option when I get a chance to update the source code.

for (var i:int = 0; i < lyrList.length(); i++)
{
 var lyrURL:String = lyrList.url;
 var lyrLabel:String = lyrList.name;
 
 var featureLayer:FeatureLayer = new FeatureLayer(lyrURL);
 featureLayer.name = lyrLabel;
 featureLayer.minScale = 0;
 featureLayer.maxScale = 0;
 featureLayer.addEventListener(LayerEvent.LOAD, featureLayer_loadHandler);
}

MarkHoyland

francesco,
Is your data available to the public?
Is this a text field that has a value of YES/NO ?
If you can run the code from within flashbuilder can you post the full error message or the line that the error occurs on.

JesseMetcalfe

Hi Mark,
Its been really a great widget and I appreciate you guys hard work to support this vast community of Viewer application for their day to day work.

Actully I am trying to modify this widget to suit my requirement.
when querying a field I want user to allow to
- select multiple values from the list
- do not want to give options for selecting operators.
so my query will always be

"select * from <layer> where <fld1> = "selection1" OR "selection2"

Pls. give me some pointers. It will be really helpfull.

Jesse

francescodi_vito

Hi Mark
for "available for the public" you mean if my Map Service have a password?
The filed YES or NO it's text field.
the error is "TypeError: Error # 1009: Can not access a property or method of a null object reference."
here attached 2 pictures of widget when i run the selection for YES and NO

xanderm

Where/How can I change the color of the selection results grid? I'd like a bit more contrast in the results. It's currently white text with an off-white background.

I'm not seeing it in the mxml. Or perhaps is based on the style tags set in the config.xml????

Thanks.

26651Capture.JPG

Capture.JPG

MarkHoyland

Xander,

I think you have to look into styling. I dont apply any styling so it just uses the default FlexViewer style.
http://help.arcgis.com/en/webapps/flexviewer/help/Default.htm#CSHID=styling.htm|StartTopic=styling.htm

If you are still unsure post a new thread about styling a datagrid in flex viewer, and I am sure others would be able to help.

JesseMetcalfe

Is their a way If I can provide aliases for fields to build the query ?

I want to modify this widget to suit my requirement.

when querying a field I want user to allow to
- select multiple values from the list
- do not want to give options for selecting operators.
so my query will always be

"select * from <layer> where <fld1> = "selection1" OR "selection2"
I am successful in populating the Unique values List when I select any field and able to select Multiple values from the list.

Please suggest ?

francescodi_vito

Hi Mark,
in this pisctures that i attached in this message, there is a error that i have. i Have this error when i run the selection widget for NO field

Problem.jpg

MarkHoyland

francesco,
Are you able to copy and paste that message, and post it here?
Otherwise I need you scroll across the message window, and grab another picture, so I can see the right hand side of the message.
It is probably the second and third line of that message that I need to see.

ps. By publicly available(previous post), I mean can I put your mapservice into my project, or is it only available within your intranet.

MarkHoyland

Jesse,
What you want is possible, You would have to redesign the Graphic Interface a bit.
The selection statement that you need is:

"select * from <layer> where <fld1> = "selection1" OR <fld1> = "selection2"

Notice you have to include the field name for each selection.

Another possible query is: where <fld1> in ("selection1" ,"selection2")
I am not able to test at the moment but it might get you started.

francescodi_vito

Hi Mark! Sorry But my map service is only available on the intranet! Now I'm using uncompiled version and in FV property i set a 10.2 flash player version that i use,and when i run the selection with a 'NO' value the datagrid is not fill and on the map there is the result of selection, But if i zoom in the datagrid is immediatelly filled But the clear button and export button and zoom button are not available? Why? Obvously the error message has disappered! Please help me

JesseMetcalfe

Thanks Mark,
I am able to implement the functionality.
However now I want to perform Definition Query on the selected criteria.
So below is my code Snippet -

In SelectByAttributes.mxml - I m setting definitionExpression and calling refresh on target layer.
But It is only showing me busy cursor.

Is it possible if I can detach the "Selection Results" table from the widget ?
Pls help.

protected function selectBtn_clickHandler(event:MouseEvent):void
{
this.cursorManager.setBusyCursor();
var query:Query = new Query;
query.where = queryFilter.text;
targetLayer.definitionExpression = queryFilter.text;
targetLayer.refresh();
//targetLayer.selectFeatures(query, selectionMethod, new AsyncResponder(onSelectResult, onSelectFault, targetLayer));
}

Jesse

MikeMartin

Great widget Mark, just what I've been looking for. I do have a problem with the Get Unique Values not loading, however. Everything else works great. Is there a setting for the layer's service I need to look for? Thanks.

Mike

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.