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; } } }

Enhanced Search Widget for FlexViewer 2.1

RobertScheitlin__GISP

All Here is my next widget in the FlexViewer 2.1 series

Special thanks to Erwan Caradec for contributing to this code.

The Enhanced Search Widget extends the standard search widget with a floating data grid and a new spatial query w/buffering.

http://www.arcgis.com/home/item.html?id=5d4995ccdb99429185dfd8d8fb2a513e

Find more posts tagged with

Accepted answers

All comments

JustinFultz

Robert,

I would like to set up a search on a stand alone table and don't know if it is possible through this widget.

I have a point layer and stand alone table in a map service that are related. I can search the point layer and return the related records from the stand alone table, but I would like to search the stand alone table and return related points. When I try to set this up in the eSearch.xml I get no results in my web app when searching the table.

I can successfully query the stand alone table in the ArcGIS Services Directory. Am I doing something wrong, or is this not possible with the current version of the widget?

Thanks for all of your hard work!

Justin

RobertScheitlin__GISP

Justin,

Searching Flat (no geometry) tables is not supported in this widget currently.

JustinFultz

Thanks for the quick reply!!!

Any plans to incorperate this into a future release?

So if I convert this table into a point layer and give each record the geometry of the related existing point, could I just turn off symbology in the map document and accomplish the same thing?

Thanks!

RobertScheitlin__GISP

Justin,

Yes, I will add it to the list of requested enhancements.

So if I convert this table into a point layer and give each record the geometry of the related existing point, could I just turn off symbology in the map document and accomplish the same thing?

Sounds like that would work just fine.

SimonMorgan

Thanks for the quick reply!!!

Any plans to incorperate this into a future release?

So if I convert this table into a point layer and give each record the geometry of the related existing point, could I just turn off symbology in the map document and accomplish the same thing?

Thanks!

I kind of acheieved what you are looking for. I have a point layer of schools and a table only dataset with a list of school reservations. I wanted Robert's tool to return the location of every schoool that had made a reservation. I did it using a little SQL:

<definitionexpression>
    EXISTS (SELECT * FROM central2.GISADMIN.TRPD_Schdgrps_Schools 
    WHERE central2.GISADMIN.MN_Schools_PUBLIC.ORGID_REL = central2.GISADMIN.TRPD_Schdgrps_Schools.School_Code)
   </definitionexpression>
   <enableexport>true</enableexport>
   <name>Minnesota Schools - Users</name>
   <url>http://[server]/ArcGIS/rest/services/swan/CRANE_alldata/MapServer/1</url&gt;
   <expressions>
    <expression alias="All users" 
       textsearchlabel="Search for all non-user schools" 
       userlist="1=1">[value]</expression>
    <expression alias="All users by time period" 
       textsearchlabel="Enter a year (2010) or a time period (2010 Q1)"> 
       EXISTS (SELECT * FROM central2.GISADMIN.TRPD_Schdgrps_Schools 
       WHERE central2.GISADMIN.MN_Schools_PUBLIC.ORGID_REL = central2.GISADMIN.TRPD_Schdgrps_Schools.School_Code 
       AND central2.GISADMIN.TRPD_Schdgrps_Schools.TimePeriod LIKE '%[value]%')</expression>
    <expression alias="Multiple reservations" 
       textsearchlabel="Enter a year (2010) or a time period (2010 Q1)">
       gisadmin.MN_SCHOOLS_PUBLIC.ORGID_REL IN 
       (SELECT tss.School_Code FROM central2.gisadmin.TRPD_SCHDGRPS_SCHOOLS tss 
       WHERE tss.TimePeriod Like '%[value]%' GROUP BY tss.School_Code HAVING COUNT(*) > 1)</expression>
    <expression alias="Single reservation" 
       textsearchlabel="Enter a year (2010) or a time period (2010 Q1)">
       gisadmin.MN_SCHOOLS_PUBLIC.ORGID_REL IN 
       (SELECT tss.School_Code FROM central2.gisadmin.TRPD_SCHDGRPS_SCHOOLS tss 
       WHERE tss.TimePeriod Like '%[value]%' GROUP BY tss.School_Code HAVING COUNT(*) = 1)</expression>
    <expression alias="School Name" 
       textsearchlabel="Search for schools by name">
       SCHNAME Like '%[value]%'</expression>
    <expression alias="Type of School" 
       textsearchlabel="Search for schools by type" 
       userlist="ELEM,MIDD,HIGH,ALC,SECOND FACILITY COOP,CHARTER,COLLEGE,COOP,
       CORRECTIONAL,EDUCATION_DISTRICT,DISTRICT-OTHER,
       INDEPENDENT,INTERMEDIATE DIST,OFFICE,OTHER,SPECIAL">SCH_TYPE1 LIKE '%[value]%'</expression>
    <expression alias="School District Number" 
       textsearchlabel="Search for schools by Schoo District Number">
       SDNUM = [value]</expression>
   </expressions>

You will notice that in the definition query tag, I used the exists command of SQL. ArcGIS automatically starts every query with the select statement, so you essentially can only build a query after "select * from where" and so you do not need to type that as you may already know.

EXISTS (SELECT * FROM central2.GISADMIN.TRPD_Schdgrps_Schools
WHERE central2.GISADMIN.MN_Schools_PUBLIC.ORGID_REL = central2.GISADMIN.TRPD_Schdgrps_Schools.School_Code)

This query essentially looks at the schools table and only returns schools that have a matching school ID in the reservations table.

Just thought I would share, it may not do exactly what you need, but hopefully it was helpful!

One thign to note, this query may not give an expected result if your table is registered as versioned because it does nto query the A and D tables.

Heena1

Hi Mark,

Did you figure this out yet?
I changed visible="true" to visible="false" in SearchWidget.mxml line 3653. After that, "add search tolerance to point search" was set to "checked" by default.
<s:Group id="spatialInput"
     width="100%" height="100%"
     visible="false"
     visible.spatialInput="true">
   <s:layout>

Heena
Village of Algonquin, IL

Hi Robert,

What is the best way to make the check box for "add search tolerance to point selection" to be "checked" by default.

The reason I ask is that i cannot get the point selection tool to actually select a point feature unless I check the box first. It seems kind of redudant, unless I am missing something. I have set the toleranceforpointgraphicalselection value to 100. If you set this value, would you not want the user to use this as the default.

Thanks for any assistance or direction that you can provide.

Mark

SimonMorgan

Robert,

I have a question. I just switched one of my esearch widgets over to the new 2.5.0.7 XML format. This is how I setup the link:

<links>
    <link includeinresults="false" field="WEB_URL" alias="School Website">
     <linkprefix></linkprefix>
     <linksuffix></linksuffix>
     <iconfield></iconfield>
     <iconprefix></iconprefix>
     <iconsuffix></iconsuffix>
    </link>
   </links>

I am NOT getting the default icon int he search results window. I do get the link in the popup and the link in the datagrid (I have that setup in fields).

RobertScheitlin__GISP

Hi Mark,

Did you figure this out yet?
I changed visible="true" to visible="false" in SearchWidget.mxml line 3653. After that, "add search tolerance to point search" was set to "checked" by default.
        <s:Group id="spatialInput"
                 width="100%" height="100%"
                 visible="false"
                 visible.spatialInput="true">
            <s:layout>

Heena
Village of Algonquin, IL

Henna,

Have you set the new

<tolerancebydefault>true</tolerancebydefault>

in the SearchWidget.xml?

Untitled.png

RobertScheitlin__GISP

Robert,

I have a question. I just switched one of my esearch widgets over to the new 2.5.0.7 XML format. This is how I setup the link:
<links>
                <link includeinresults="false" field="WEB_URL" alias="School Website">
                    <linkprefix></linkprefix>
                    <linksuffix></linksuffix>
                    <iconfield></iconfield>
                    <iconprefix></iconprefix>
                    <iconsuffix></iconsuffix>
                </link>
            </links>
I am NOT getting the default icon int he search results window. I do get the link in the popup and the link in the datagrid (I have that setup in fields).

Simon,

that is a bug and will be fixed in version 2.5.0.8. Sorry for the inconvenience. Version 2.5.0.8 Now Available 12/30/11 9pm Central time.

SimonMorgan

Robert,

Thank you for fixing the bug, very much appreciated.

I have another question or possibly an enhancement request. I have an access database that is a front end for a table in my geodatabase. The table is only editable via access. It is joined to a feature class. I added a web component to the form to display a flex app. I have it setup so that it runs a query against the esearch widget depending upon which asset has been picked on the form.

So if asset 87 is picked the web component within the form builds the following URL:

http://gis2/swan/application25/index.html?config=config-engineering.xml&search=87 and then displays the web app from within Access on the form itself.

It works very nicely, however, it would be nice if I could controlt he zoom. Per your documentation, the widget zooms to the extent of the results. Would you be willing to add a parameter such that the zoom level could be included in the URL or would this be easy to do my self? I have a basic understanding of Flex.

RobertScheitlin__GISP

Simon,

I believe this is already possible in the current version... Try setting the :

<zoomscale usegeometry="false">10000</zoomscale>

for the layer that is being searched in the SearchWidget.xml. Let me know if that does not work and I will look into it.

SimonMorgan

Simon,

I believe this is already possible in the current version... Try setting the :
<zoomscale usegeometry="false">10000</zoomscale>
for the layer that is being searched in the SearchWidget.xml. Let me know if that does not work and I will look into it.

That did it thank you!!!

Heena1

Robert,

I've downloaded 2.5.0.8 and Related Table data are not showing. Could you tell me what I am missing?
I am attaching Searchwidgt xml. Try to search Hydrant ID "h1-0259". It has Flush data related. Thank you.

Image.png

SearchWidgetXML.txt.zip

RobertScheitlin__GISP

Henna,

Try relate id 0 and 1 and not 12 and 13.

<relates>
                <relate id="0" label="Hydrant Flush" enableexport="true">
                    <fields all="true" />
                </relate>
            <relate id="1" label="Hydrant Repair" enableexport="true">
                    <fields all="true" />
                </relate>
            </relates>

Heena1

Thank you Robert. It works.

DavidJenkins

I get this error if I minimize the enhanced search widget and then click on a record within the data grid.

[INDENT]Main Thread (Suspended: RangeError: Error #1125: The index 0 is out of range 0.)
widgets.eSearch::SearchWidget/highlightDataGroupItem
widgets.eSearch::SearchWidgetFixedDG/onItemRollOver
widgets.eSearch::SearchWidgetFixedDG/__resultsGrid_itemRollOver
flash.events::EventDispatcher/dispatchEventFunction [no source]
flash.events::EventDispatcher/dispatchEvent [no source]
mx.core::UIComponent/dispatchEvent [no source]
mx.controls.listClasses::ListBase/mouseOverHandler [no source]
mx.controls.listClasses::ListBase/mouseMoveHandler [no source][/INDENT]

I'm not a flex / flash expert so I could use some help. I would also be interested in removing the onItemRollOver functionality in the DataGrid and making it clickRow instead so it would zoom and showInfoWindow. Having it bound to a click instead of using roll over would improve performance of larger sets of data in the current extent.

Thank you for your help in advance.

Dave Jenkins GISP
jkindave@gmail.com

RobertScheitlin__GISP

Dave,

I have no plans for such a major rewrite of my datagrid code right now (as far as the row click). But I will attempt to duplicate the error you are getting a develop a fix if I can duplicate it.

Heena1

Hi Robert,

I have image hyperlink set up in Search Result and Grid Result for Signs data. Most Sign data search is using domain. I am using 2.5.0.8. When search result comes, they display same images. Although when I click image link in Grid field, it displays the correct images. I am attaching image and text file. Could you please help me out? Thank you so much.

SignSearchWidgetXML.txt.zip

Signs.png

RobertScheitlin__GISP

Henna,

Now that the MVP competition is back. I need you to always post questions to a new thread and not to an existing one, that way you can mark questions as answered.

RachelS_

This is in response to the Point Buffer widget included in the original link for the Search Widget. I've adopted the Point Buffer code and wrote a function to calculate the radius distance I want to apply a buffer for, based on some user inputs via combo boxes. Instead of using the input text (textInputBuffer) I want the buffer distance to be defined by my function. Is there a way to switch it so that the ApplyBuffer function reads from my function and not the text input?
Thanks!!

RobertScheitlin__GISP

Rachel,

Sure I can probably help with that. BUT read the post right before yours... You need to start a new thread.

RachelS_

whoop, sorry! turns out i was responding to a thread from a while ago. new post duly created.

RobertScheitlin__GISP

I get this error if I minimize the enhanced search widget and then click on a record within the data grid.
[INDENT]Main Thread (Suspended: RangeError: Error #1125: The index 0 is out of range 0.)
widgets.eSearch::SearchWidget/highlightDataGroupItem
widgets.eSearch::SearchWidgetFixedDG/onItemRollOver
widgets.eSearch::SearchWidgetFixedDG/__resultsGrid_itemRollOver
flash.events::EventDispatcher/dispatchEventFunction [no source]
flash.events::EventDispatcher/dispatchEvent [no source]
mx.core::UIComponent/dispatchEvent [no source]
mx.controls.listClasses::ListBase/mouseOverHandler [no source]
mx.controls.listClasses::ListBase/mouseMoveHandler [no source][/INDENT]

I'm not a flex / flash expert so I could use some help. I would also be interested in removing the onItemRollOver functionality in the DataGrid and making it clickRow instead so it would zoom and showInfoWindow. Having it bound to a click instead of using roll over would improve performance of larger sets of data in the current extent.

Thank you for your help in advance.

Dave Jenkins GISP
jkindave@gmail.com

Dave,

After looking into your error and the LOE for making the datagrid interaction with the widget results configurable, I was able to fix the error and add your enhancement request. Download version 2.5.1.1 and you will find that the grid widget interaction is now configurable, and that click results in the grid will both zoom to the results and show the popup.

NathanEnge

Robert, I'm having a bit of an issue, and trying to figure out what I'm missing. I'm still using the 2.4 esearch. I have a feature class that is joined to a view table via arcmap and published to msd. I can do the text based query, but using the graphic select is no joy. all my the fields are turned on. The graphic search works for another feature class that has no join. any ideas?

RobertScheitlin__GISP

Nathan,

It is time to put this 14 page thread to rest (especially now that the MVP program is back running again). Please always start a new post from now on. When you do start a new post make sure you clarify if you are talking about a actual spatial view or just a flat table that the join is made with.

mgiles86

Hi Robert,
I am using your enhanced search widget and noticed that the layers in the 'search layer' dropdown (Louisville zoning, parcels, etc.) are not in my application. Then i checked in the .xml and noticed that the layers that exist in the dropdown are hardcoded into the xml...
Does this mean that, if i have 50 layers in my application, i have to hardcode each into the widget? There is no way to update the dropdown list dynamically as layers are added / removed, visible/not visible??

MariaSevier

Hi Robert,

I have looked at this code until I'm cross eyed and looked at several forums to see where the code is incorrect but still can't figure it out.

I keep getting the following error.
"[RPC Fault faultString="Invalid or missing input parameters." faultCode="400" faultDetail=""]

I have run these same queries in the rest environment on the layers in the code and it works just fine there. I'm not sure what the problem is at this point.

Here is my code (the police district search works but the street tree and catch basin ones get me the error above.).
<layer>
   <definitionexpression></definitionexpression>
   <enableexport>true</enableexport>
   <name>Street Trees</name>
   <url>http://lwchgis01:6080/arcgis/rest/services/MainInternalMaps/Topo/MapServer/0</url>
   <expressions>
    <expression alias ="Street Trees" textsearchlabel="Search by Tree Number: [ Example: 823]" >TREENO like '[value]'</expression>
   </expressions>
   <graphicalsearchlabel>Use one of the graphical search tools to select Trees</graphicalsearchlabel>
    <spatialsearchlayer>true</spatialsearchlayer>
    
   <fields all="false">
    <field name="TREENO" gridfield="true"/>
    <field name="ADDRESS" gridfield="true"/>
    <field name="SIDE" gridfield="true"/>
    <field name="TYPE" gridfield="true"/>
    <field name="YEAR_PLANTE" gridfield="true"/>
    <field name="ELEC_RECEP" gridfield="true"/>
    <field name="MOVED" gridfield="true"/>
   </fields>
   <linkfield></linkfield>
   <icon isfield="false"></icon>
   <zoomscale usegeometry="false">2500</zoomscale>
   <autoopendatagrid>true</autoopendatagrid>
</layer>
<layer>
   <definitionexpression></definitionexpression>
   <enableexport>true</enableexport>
   <name>Catch Basins</name>
   <url>http://lwchgis01:6080/arcgis/rest/services/MainInternalMaps/StormDrainage2/MapServer/10</url>
   <expressions>
    <expression alias="Catch Basin ID" textsearchlabel="Search by CBID: [ Example: 421595APAR123]">CBID like upper('[value]')</expression>
    <expression alias="Type of Catch Basin" textsearchlabel="Search by TCB: [ Example: 1A]">TCB like upper('[value]')</expression>
   </expressions>
   <graphicalsearchlabel>Use one of the graphical search tools to select Catch Basins</graphicalsearchlabel>
    <spatialsearchlayer>true</spatialsearchlayer>
    
   <fields all="false">
    <field name="CBID" gridfield="true"/>
    <field name="TCB" gridfield="true"/>
    <field name="NOP" gridfield="true"/>
    <field name="DIAM" gridfield="true"/>
    <field name="DOCB" gridfield="true"/>
    <field name="DOS" gridfield="true"/>
    <field name="SM" gridfield="true"/>
    <field name="WAT_QUAL" gridfield="true"/>
    <field name="OI" gridfield="true"/>
    <field name="INSTDATE" gridfield="true"/>
    <field name="DL" gridfield="true"/>
    <field name="DRE" gridfield="true"/>
    <field name="LIE" gridfield="true"/>
    <field name="MV" gridfield="true"/>
   </fields>
   <linkfield></linkfield>
   <icon isfield="false"></icon>
   <zoomscale usegeometry="false">25000</zoomscale>
   <autoopendatagrid>true</autoopendatagrid>
</layer>
<layer>
   <definitionexpression></definitionexpression>
   <enableexport>true</enableexport>
   <name>Police Districts</name>
   <url>http://lwchgis01:6080/arcgis/rest/services/MainInternalMaps/Police/MapServer/1</url>
   <expressions>
    <expression alias="Police District" textsearchlabel="Search by District [ Example: LD01]">NEW like upper('[value]')</expression>
   </expressions>
   <graphicalsearchlabel>Use one of the graphical search tools to select Police Districts</graphicalsearchlabel>
    <spatialsearchlayer>true</spatialsearchlayer>
    <titlefield>Precinct</titlefield>
   <fields all="false">
    <field name="NEW" alias="Police District" gridfield="true"/>
    <field name="NAME" gridfield="true"/>
   </fields>
   <linkfield></linkfield>
   <icon isfield="false"></icon>
   <zoomscale usegeometry="false">25000</zoomscale>
   <autoopendatagrid>true</autoopendatagrid>
</layer>

Thanks for any help that you can provide.
Maria Sevier

RobertScheitlin__GISP

Maria,

Sure I can help you but you need to post a new thread for every question you have now a days. Once a thread has been answered I will not be answering other questions on that thread. This thread is 14 Pages long and it is time to retire it.

DavidJenkins

Dave,

After looking into your error and the LOE for making the datagrid interaction with the widget results configurable, I was able to fix the error and add your enhancement request. Download version 2.5.1.1 and you will find that the grid widget interaction is now configurable, and that click results in the grid will both zoom to the results and show the popup.

Robert,

Thanks. I was able to modify the code somewhat on my own by combining the onItemRollOver function into the clickRow function in the SearchWidgetFixedDG.mxml, but I still had range error when I would minimize the widget and click on an item in the grid. I will try your new release immediately. You are the man! Thanks.

Dave

MarkSmith1

Hi Robert,

Does your search widget (2.5.1.2) support Many-to-Many relationships when looking for related records? We're having problems getting it to work and we're wondering if it's on end or if it's a limitation of the API.

Thanks,

Mark

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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