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.

Najděte více příspěvků označených jako

Accepted answers

All comments

mburge

Mark,
Have implemented your widget and it works well. However, I'm having an issue with the click event. If I use the click on a point prior to using the widget, the popup contains the name of the "structure" I'm clicking on with a "zoom to" option. Then, once I use the widget and create a selection, and use the hover feature either over the grid, or the point, the name of the "structure" is retained if I use the click event on a "non" selected point. The click popup keeps the name of the "hover" structure until another hover is done (the structure name in the click popup doesn't match the point clicked. Have also loaded up the uncompiled version in hopes if finding where to change this but so far have not - any help would be appreciated. The widget has nice functionality - thanks!

MarkHoyland

The widget has now been updated with bug fixes and enhancements.
I have started a new thread see:
http://forums.arcgis.com/threads/30179-Selection-Widget-Updated-Version

Hopefully changes for the better.

Been a while coming. Studying, surfing (been goin off lately!) and my children have been taking up my spare time. Havent had a chance to get back to this for a while.

Still no select by graphic option, wont get a chance to look at this for a while.
Leave feedback on new thread.

LeithaSackmann

Hi Daniel,

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,
I am also very interested in your Selection widget if it would have a graphics option included. I am first selecting catchment basins and these do not have a readily recognized name field so a graphics selection is necessary. Do you have any idea when you might get to this? Or is it possible to select polygons using the standard search widget and then use your Selection widget to query other layers with these selected polygons from the first graphic selection? Thought I'd ask before I tried it. Still - thanks for a great widget!!

MehulChoksey

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.

Changes from UIManager.as doesnt seem to be picked up in this case.
You will have to perform following in SelectionResults.mxml:
Add import along with other imports:

import mx.core.FlexGlobals;

Add following funtion:

 protected function dg_initializeHandler(event:FlexEvent):void
            {
               var dgBackgroundColor:uint = FlexGlobals.topLevelApplication.styleManager.getStyleDeclaration("global").getStyle('contentBackgroundColor');
               dg.setStyle("alternatingItemColors",[dgBackgroundColor,dgBackgroundColor]); 
            }

Add initialize="dg_initializeHandler(event)" in following declaration:

<mx:DataGrid id="dg" width="{dgContainer.width}" height="{dgContainer.height}"
                     horizontalScrollPolicy="on"
                     itemClick="dg_itemClickHandler(event)"
                     itemRollOver="dg_itemRollOverHandler(event)"
                     initialize="dg_initializeHandler(event)"/>

MollyAzami

Hi,

I was having the problem with the Layers being added to the TOC, so I added the one line in the INIT() and the one function as mentioned above.

It compiled fine.

Now the widget won't open at all. I just get a little clock going round and round...

I also tried importing the library that someone else mentioned... it didn't fix it...

any ideas?

EDIT: NEVER MIND, SEEMS TO BE A FLASH BUILDER ISSUE...won't do what I want it to...grrr...

francescodi_vito

Sorry Mark.
I'd need to use this great widget on a Map Service that contains a feature layer and table That Have a relationship class 1-M. What should I do to add this function? Could you help me with the code that you think should be added?
Help me please
thanks

francescodi_vito

Hi mark,
I have a question! It's possible to develop this widget for a custom application and not into FV 2.2?
The same work of Robert S. For esearch.
Is there into code gallery this type of widget or you don't develop this widget for not FV 2.2?
Thanks

SimoneCeccolini

This is Great widget my regards to autor, but i have a little problem when i use a pint widget like PrintSOE Widget (from TOM SCHULLER) , because the polygon of selection are hidden in final PDF.
The output result is only map without the selected polygon.
This not happend with other widget like eSearch or Draw Widget.

Please anyone help me.

Thanks forward from Simone.

Stefanobruscoli

Mark
I think I have found the problem:
if some field are only in <fields> tag and not in <infowindowfields> this fields are empty in datagrid result.
Reading your readme.txt, I understood that two list are indipendent and the second is only for quick summary for info widget. It would seem not to be so.... for my try...
There's problem?

Stefanobruscoli

Mark
I've this problem:
in fields tag I've put Shape_Area for item search and result.
If I try a search with this item I can see values in values list. But in the result I've the item Shape_Area with no values. This for all layers (my search layer have all polygons features....)
Please can you help me?

MarkHoyland

Mark,

Thanks for your response. Unfortunately I didn't have this thread set to email notification so I am just seeing this now! I am aware of the ArcGIS Server setting which controls the number of features returned, however I don't think this is the culprit in my case. While my number of unique values does exceed that default limit, I am only getting ~50 unique values pulled into the selection tool. Let me know if you have an idea on what else might be going on.

Thanks!

Lisa, Here is a test application to help see if the results are what they should be.
You can add your own url and field name at run time.
Firstly it will select all features in the layer. If the ArcGISServer limit is reached it will return that amount of features. (standard flex api querytask)
Next it the passes the results of the query to a function which extracts the unique values.
There is a .swf file included, just double click the .swf in windows explorer and open in internet explorer.
Source code is also included if you want to see how it works.
Let me know if this helps.

QueryTest.zip

MarkHoyland

Thanks Robert
i have another question! is it possible to change the code for use the ALIAS of fields in the XML file?

Franceso,
While it is possible, there is quite a bit of work to get this done. I am not looking at this option yet, but maybe in a version 2 of the widget.

LisaArnold

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.

Mark,

Thanks for your response. Unfortunately I didn't have this thread set to email notification so I am just seeing this now! I am aware of the ArcGIS Server setting which controls the number of features returned, however I don't think this is the culprit in my case. While my number of unique values does exceed that default limit, I am only getting ~50 unique values pulled into the selection tool. Let me know if you have an idea on what else might be going on.

Thanks!

francescodi_vito

Thanks Robert
i have another question! is it possible to change the code for use the ALIAS of fields in the XML file?

MikeMartin

In SelectionByAttributes.mxml the function retreiveFieldValues, I had to comment out the query.where"1=1" and add a new line of query.text = "%".
Not sure why text worked and 1=1 did not work on your layer, as both methods are doing the same thing.

If you can access the source code, I would suggest making the change.
//query.where = "1=1";
query.text = "%";

URLs with 1=1 are blocked by our IOT folks. I've had to use OBJECTID>-1 for queries; unfortunately, I am unable to access/change the source code...but I definitely think that is the issue. No matter what layer I use from our server I have the same problem, but no problems with the arcgisonline sample data. Thanks for your help Mark.

MarkHoyland

mmartin;89662 wrote:
Thanks for replying Mark. I am not getting any at all.

Mike,
I could do some testing on your layer. When I query it gives an error message:

{
  "error" : 
  {
    "code" : 500, 
    "message" : "No display field", 
    "details" : []
  }
}

You will have to set the display field. I think the display field is set in ArcMap under the display tab or the label tab.

I also tested another layer of yours (Significant Withdrawal Wells ID: 0) and found that I had to change the query method before it would work.

In SelectionByAttributes.mxml the function retreiveFieldValues, I had to comment out the query.where"1=1" and add a new line of query.text = "%".
Not sure why text worked and 1=1 did not work on your layer, as both methods are doing the same thing.

If you can access the source code, I would suggest making the change.

//query.where = "1=1";
query.text = "%";

MarkHoyland

Hi Mark
but is it possible to extend the widget's function for a map service with a relationshio class?

Francesco,
I have not done anything with relationship class, so I dont know the answer to that.

francescodi_vito

Hi Mark
but is it possible to extend the widget's function for a map service with a relationshio class?

MikeMartin

Mike,
Do you mean you are not getting a full list or none at all.
If you are not getting a full list then it has been mentioned previously in this thread

If you are not getting any values at all, please post your selectionwidget.xml file.

Thanks for replying Mark. I am not getting any at all.

<?xml version="1.0" ?>
<configuration>
    <layers>
        <layer>
            <name>Water Wells</name>
            <url>http://dnrmaps.dnr.in.gov/ArcGIS/rest/services/ProgramMaps/WaterWells_DNR_102100/MapServer/1</url&gt;
            <titlefield>DBLREFNO</titlefield>
            <linkfield></linkfield>
          <fields>
            <field name="DBLREFNO"/>
          </fields>
        </layer>
    </layers>
    <zoomscale>50000</zoomscale>
    <info>widgets/InfoTemplates/InfoPopupWidget.swf</info>
</configuration>

MarkHoyland

I do have a problem with the Get Unique Values not loading

Mike,
Do you mean you are not getting a full list or none at all.
If you are not getting a full list then it has been mentioned previously in this thread

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.

If you are not getting any values at all, please post your selectionwidget.xml file.

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

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

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

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.

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.

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

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 ?

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.

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

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

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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