topic Re: enhanced search widget related tables and features in ArcGIS Viewer for Flex Questions

enhanced search widget related tables and features

RaulLeos — Tue, 23 Jun 2015 15:51:51 GMT

search widget will not displace the parcel parameters of the related tables data when a search is performed. The parcel feature class has a relationship in the SDE with a table and only table information is displayed but when you click on the record it will not zoom to it. please help on xml code.

Re: enhanced search widget related tables and features

RobertScheitlin__GISP — Tue, 23 Jun 2015 16:08:48 GMT

Raul,

Please attach what you have in your eSearchWidget.xml currently.

Re: enhanced search widget related tables and features

RaulLeos — Tue, 23 Jun 2015 16:28:37 GMT

<?xml version="1.0" ?>

<layer>

<name>McAllen Parcels</name>

<url>http://gismap.mcallen.net/mcgis/rest/services/ParcelEditing/MapServer/10</url>

<value prompt="Owner's Name Ex: Doe John">upper(LAST_FIRST) LIKE upper('%[value]%')</value>

</values>

<value prompt="Owner's City Ex: McAllen" isvaluerequired="false">upper(OWNERCITY) LIKE upper('%[value]%')</value>

</values>

</expression>

<value prompt="Geographic ID Ex: M1950-00-061-0000-00">GEO_ID = '[value]'</value>

<value prompt="Property ID Ex: 229138" isvaluerequired="false">PROP_ID = '[value]'</value>

</values>

</expression>

<value prompt="Example: 78501">upper(OWNERZIP) LIKE upper('%[value]%')</value>

</values>

</expression>

</expressions>

<graphicalsearchlabel>Use one of the graphical search tools to select McAllen Parcels</graphicalsearchlabel>

</fields>

<links>

<![CDATA[{URL}]]>

</link>

</links>

<queryattachments>false</queryattachments>

</simplefillsymbol>

</symbology>

</layer>

<layer>

<name>Subdivision</name>

<url>http://gismap.mcallen.net/mcgis/rest/services/ParcelEditing/MapServer/14</url>

<value prompt="Example: Shadow Brook">upper(SUBD) LIKE upper('%[value]%')</value>

</values>

</expression>

</expressions>

<graphicalsearchlabel>Use one of the graphical search tools to select Parcels</graphicalsearchlabel>

<titlefield>Subdivision</titlefield>

</fields>

</layer>

</layers>

<table>

<name>County Parcels</name>

<url>http://gismap.mcallen.net/mcgis/rest/services/ParcelEditing/MapServer/13</url>

<value prompt="Owner's Name Ex: Doe John">upper(GIS_Data_file_as_name) LIKE upper('%[value]%')</value>

</values>

<value prompt="Owner's City Ex: McAllen" isvaluerequired="false">upper(addr_city) LIKE upper('%[value]%')</value>

</values>

</expression>

<value prompt="Geographic ID Ex: M1950-00-061-0000-00">GIS_Data_geo_id = '[value]'</value>

<value prompt="Property ID Ex: 229138" isvaluerequired="false">GIS_Data_prop_id = '[value]'</value>

</values>

</expression>

<value prompt="Example: 78501">upper(zip) LIKE upper('%[value]%')</value>

</values>

</expression>

</expressions>

<graphicalsearchlabel>Use one of the graphical search tools to select County Parcels</graphicalsearchlabel>

</fields>

<links>

<![CDATA[{URL}]]>

</link>

</links>

<queryattachments>false</queryattachments>

</relate>

</relates>

</simplefillsymbol>

</symbology>

</table>

</tables>

<name>esriSpatialRelContains</name>

<label>entirely contained in</label>

</spatialrelationship>

<name>esriSpatialRelIntersects</name>

<label>intersected by</label>

</spatialrelationship>

<name>esriSpatialRelEnvelopeIntersects</name>

<label>intersected by envelope of</label>

</spatialrelationship>

</spatialrelationships>

</bufferunit>

<name>UNIT_STATUTE_MILE</name>

<label>Miles</label>

</bufferunit>

<name>UNIT_METER</name>

<label>Meters</label>

</bufferunit>

<name>UNIT_KILOMETER</name>

<label>Kilometers</label>

</bufferunit>

</bufferunits>

</footer>

</printdatagrid>

<removeserchlayersminmaxscale>false</removeserchlayersminmaxscale>

<popupsdisabled>false</popupsdisabled>

<tolerancebydefault>false</tolerancebydefault>

<defaultselectionoption>textInput</defaultselectionoption>

<enablemultigraphicssearch>false</enablemultigraphicssearch>

<multipartgraphicsearch>false</multipartgraphicsearch>

<floatorfixed>float</floatorfixed>

<relatetooltip>Show Relates</relatetooltip>

<relateicon>widgets/eSearch/assets/images/i_relate.png</relateicon>

<urlsearcherrormessage>URL search parameters are incorrect</urlsearcherrormessage>

<includetextquery>include text query in selection criteria</includetextquery>

<includetextquerywarn>Must be the same search layer in both

graphical and text search pages.</includetextquerywarn>

<buffergrapicprops>Buffer graphic properties</buffergrapicprops>

<bufferusergraphics>Buffer Graphic</bufferusergraphics>

<norelatesfound>No related features found for:</norelatesfound>

<norelatesfoundalerttitle>No Results</norelatesfoundalerttitle>

<addtolerance>Add search tolerance to point selection</addtolerance>

<existingdrawgraphicslabel>Use Existing Enhanced Draw Widget Graphics</existingdrawgraphicslabel>

<existinglocategraphicslabel>Use Existing Enhanced Locate Widget Graphics</existinglocategraphicslabel>

<existingbuffergraphicslabel>Use Existing Point Buffer Widget Graphics</existingbuffergraphicslabel>

<graphicalsearchlabel>Graphical Search</graphicalsearchlabel>

<textsearchlabel>Text Search</textsearchlabel>

<resultslabel>Results</resultslabel>

<layerlabel>Search Layer:</layerlabel>

<layerfieldlabel>Search Layer Field:</layerfieldlabel>

<nolayerlabel>No search layer defined.</nolayerlabel>

<submitlabel>Search</submitlabel>

<pointlabel>Select by Point</pointlabel>

<linelabel>Select by Line</linelabel>

<rectanglelabel>Select by Rectangle</rectanglelabel>

<polygonlabel>Select by Polygon</polygonlabel>

<clearlabel>Clear</clearlabel>

<loadinglabel>Loading...</loadinglabel>

<selectionlabel>Features Selected:</selectionlabel>

<gridresultslabel>Show Results in Grid</gridresultslabel>

<csvdefaultname>Selected Records</csvdefaultname>

<relatescsvdefaultname>Related Records</relatescsvdefaultname>

<exportbtnlabel>Export...</exportbtnlabel>

<export2csvoptionlabel>Export to CSV...</export2csvoptionlabel>

<export2txtoptionlabel>Export to Txt...</export2txtoptionlabel>

<bufferlabel>apply a search distance:</bufferlabel>

<spatialsearchlabel>Spatial search</spatialsearchlabel>

<applybufferlabel>Apply buffer</applybufferlabel>

<searchlayerlabel>Search entities of:</searchlayerlabel>

<enablemultipartsearch>enable multi-part graphics</enablemultipartsearch>

<zoomalltip>Zoom to all results</zoomalltip>

<bufferalpha>Fill opacity</bufferalpha>

<buffercolor>Fill color</buffercolor>

<nobuffercolor>No fill color</nobuffercolor>

<bufferoutlinecolor>Outline color</bufferoutlinecolor>

<nobufferoutlinecolor>No outline color</nobufferoutlinecolor>

<bufferoutlinewidth>Outline Width</bufferoutlinewidth>

<configbuffergra>Configure buffer graphic properties...</configbuffergra>

<requiredtooltip>This field is required.

Enter a value to enable search button</requiredtooltip>

<selectmethodtip>Click to change the selection method</selectmethodtip>

<newselectionmethodtip>Create new selection</newselectionmethodtip>

<addselectionmethodtip>Add to current selection</addselectionmethodtip>

<removeselectionmethodtip>Remove from current selection</removeselectionmethodtip>

<pagingqueryerrormsg>Four unsucessfull attempts was made to get unique values for</pagingqueryerrormsg>

</labels>

</simplefillsymbol>

</symbols>

</configuration>

Re: enhanced search widget related tables and features

RobertScheitlin__GISP — Sat, 11 Dec 2021 19:39:31 GMT

Raul,

Your relate id should be a number.

            <relates>
                <relate id="0" label="County Parcels" enableexport="true" icon="widgets/eSearch/assets/images/i_relate.png" enableprintgrid="true" printitle="County Tax Roll">
                    <fields all="true"/>
                    <zoomscale usegeometry="true" zoompercent="1.6"/>
                </relate>
            </relates>

Re: enhanced search widget related tables and features

RaulLeos — Tue, 23 Jun 2015 20:34:24 GMT

Thanks Robert for your quick response, I have assigned the relate number as you indicated and now i get an error #1009

Re: enhanced search widget related tables and features

RobertScheitlin__GISP — Tue, 23 Jun 2015 21:31:05 GMT

Raul,

OK on closer inspection of your data and your XML your "County Parcels" as a table when it is an actual layer. The way this should work is you search a layer for some parcel and when that parcel is found you can bring up the related records for that parcel, or vice versa you can add the related table and search its fields for some data and then query the related feature layer (the actual parcel polygon) and zoom the map to that. When I move the "County Parcels" up to be a layer instead of a table and use the relate id of 0 then it works fine but as you are only returning one field "GIS_Data_file_as_name", it seems you have some configuration yet to do.

Re: enhanced search widget related tables and features

RaulLeos — Tue, 23 Jun 2015 21:51:15 GMT

Robert, you are right i just don't know what else the xml code needs. I am hitting my head on what it is and no clue. Do you have any ideas?

Re: enhanced search widget related tables and features

RobertScheitlin__GISP — Tue, 23 Jun 2015 22:05:32 GMT

Raul,

Are you not using App Builder for Flex? If you use App Builder then you will have a GUI to use in configuring the widget (Assuming you are using Version 3.7 of Flex Viewer and the widget).

Re: enhanced search widget related tables and features

RaulLeos — Wed, 24 Jun 2015 14:48:16 GMT

Robert, I am using app builder and yes I have the GUI and i am using version 3.4 of the release of the widget. I have tried looking at the config file and no clue why this is happening, but I will go ahead and look through it again and see where the problem might be. thank you for all your help

Re: enhanced search widget related tables and features

RobertScheitlin__GISP — Sat, 11 Dec 2021 19:39:34 GMT

Raul,

In version 3.4 of the widget there was not a full GUI for configuring the eSearch Widget in app builder. In 3.7 of ArcGIS Viewer for flex there is a FULL GUI for configuring the widget that takes all the need to know XML out of the equation.

You have done well configuring the other layers, all you need to do is move the "County Parcels" from the tables to a layer and then add some fields besides the GIS_Data_file_as_name (just like you have for your other layers), and like I said earlier use:

            <relates>
                <relate id="0" label="County Parcels" enableexport="true" icon="widgets/eSearch/assets/images/i_relate.png" enableprintgrid="true" printitle="County Tax Roll">
                    <fields all="true"/>
                    <zoomscale usegeometry="true" zoompercent="1.6"/>
                </relate>
            </relates>

Re: enhanced search widget related tables and features

RaulLeos — Wed, 24 Jun 2015 16:21:54 GMT

Robert,

thanks for all your help! i just added the County Parcels as a layer and works!!

thank you so much you don't know how much i have been working on this change on my parcels gis map.

thanks again!

Re: enhanced search widget related tables and features

RobertScheitlin__GISP — Wed, 24 Jun 2015 16:31:24 GMT

Raul,

Glad to help. Now it is your turn to help the community by marking this question as answered. All you have to do is click the "Correct Answer" link (the one with the little green star) on the post that provided the answer for you. If the answer was not provided by one of the responders then you can mark any of the replies that you received as helpful by clicking on the "Actions" menu and choosing "Mark as Helpful"

Re: enhanced search widget related tables and features

RobertScheitlin__GISP — Thu, 25 Jun 2015 12:56:01 GMT

Raul,

Thanks for marking one of my replies as helpful. Can you also mark it as answered (this is more important for people finding the correct answer).

All you have to do is click the "Correct Answer" link (the one with the little green star) on the post that provided the answer for you (you will have to do this from the actual thread as this is not visible in your inbox or activity stream).

Re: enhanced search widget related tables and features

RobertScheitlin__GISP — Thu, 25 Jun 2015 13:07:57 GMT

Raul,

Thanks

Re: enhanced search widget related tables and features

RaulLeos — Thu, 25 Jun 2015 13:17:10 GMT

Robert, if i want to upgrade to latest version of viewer for flex 3.7, what are the items to get affected.

Re: enhanced search widget related tables and features

RobertScheitlin__GISP — Thu, 25 Jun 2015 13:23:36 GMT

Raul,

Download the App Builder for 3.7 and see if it will upgrade your existing App Builder apps. There has been some changes between 3.4 and 3.7 but it should not be hard to update.

Re: enhanced search widget related tables and features

RaulLeos — Thu, 25 Jun 2015 14:29:53 GMT

Robert, the upgrade changes what and also did the enhanced widget changed alot and what did from version 3.4 to 3.7

Re: enhanced search widget related tables and features

RobertScheitlin__GISP — Thu, 25 Jun 2015 14:34:54 GMT

Raul,

I don't remember all the changes. you will have to go through the whats new section. The eSearch widget has to many changes to list from 3.4 to 3.7... I use to find bugs and fix them all the time and add enhancements as people requested.

Re: enhanced search widget related tables and features

RobertScheitlin__GISP — Thu, 25 Jun 2015 14:47:48 GMT

Raul,

You can find the list of changes in the eSearch download readme.txt

Version 3.7.4 - Feb 10, 2015

* Fixed bug with searching Multipoint geometry.

Version 3.7.3 - Jan 4, 2015

* Fixed bug with switching search layer drop down would sometimes produce and error depending on expression and layer configuration.

Version 3.7.2 - Dec 10, 2014

* (lets try this again) Fixed issue with data grids if compiling with any SDK less than Apache Flex 4.13 SDK (do not compile with 4.13 SDK)

Version 3.7.1 - Dec 8, 2014

* Fixed issue with data grids if compiling with Apache Flex 4.13 SDK

Version 3.7 - Nov 29, 2014

* Recompiled for Flex Viewer 3.7

* Assets folder is now searched for based on the location of the compiled widget and not the configuration file.

* This widget now has a GUI in App Builder!

Version 3.6.10 - 10/20/2014

* Fixed issues with searching MultiPoint Geometry.

* Fixed error 1009 when preforming a graphical search when the widget is initially opened.

Version 3.6.9 - 9/12/2014

* Made some big code changes that now allows the esri print service able to print the search results with the proper symbology.

* Fixed and issue when the first layer in the xml has uniquevalsfromfield and you use a url search a bug occurred.

Version 3.6.8 - 6/23/2014

* Fixed a bug with sum field when the format was currency.

* If the selectedgraphicaltool has been specified or you have already used a graphical search tool

when you switch to the graphical search tab that tool will be selected automatically.

* Uniquevalsfromfield now optimized to use returnDistinctValues if the server version is 10.1 or greater

(this means no paging and faster unique values). Thanks to Daryl Anderson for this idea.

Version 3.6.7 - 5/29/2014

* Fixed a few graphical query issues introduced in 3.6.6.

* Fixed hyperlinkaliastext not being used with working with related data.

* Added another localized text option to xml.

Version 3.6.6 - 5/22/2014

* Fixed URL Query Bug when a search is made and no results are found.

* Fixed csv and txt file extension bug in Fixed datagrid export.

Version 3.6.5 - 4/3/2014

* Changed export GUI design to minimize footprint.

* Added buffer support to eDraw, eLocate and pointBuffer.

Version 3.6.4 - 3/3/2014

* Fixed issue with field formatting not staying specific to the field it was set for.

* csv and txt exports now export proper linefeed based on OS.

* Added exportnumbersasformattedstrings attribute to enableexport tag. See pdf for explanation.

* Added popuplinktype attribute to link tag. See pdf for explanation.

Version 3.6.3 - 2/26/2014

* Fix major bug with uniquevalsfromfield not returning all records in some cases.

Version 3.6.2 - 2/20/2014

* Fix issue with disableinpopup in datagrids.

* Fix issue with UNC links that have icons specified not working in my popups.

* Fix issue with union geoms function and some multi ring polygons.

Special thanks to Leonardo Araújo for the code contribution.

* Added more configurable messages for widget internationalization.

* You can now configure the buffer graphic to remain visible after the search.

Version 3.6.1 - 12/19/2013

* Fixed issue With search layer symbology not showing when using a URL search until a selection was made in the datagrid.

* Unique values from field now honors the layers definition expression.

Version 3.6 - 12/19/2013

* Recompile for ArcGIS Viewer for Flex Version 3.6

Version 3.5.4 - 11/5/2013

* Fixed issue With dropdownlists sizes that was introduce in 3.5.3.

Version 3.5.3 - 10/22/2013

* Fixed issue With preload="minimized" and the dropdownlists.

* Fixed issue with SubTypes and Domains assigned to subtypes.

* Fixed issue with text qualify userlists and the all option.

Version 3.5.2 - 10/11/2013

* Fixed issue hyper link grid fields and version 3.5.1.

* Added ability to text qualify userlists that contain comma in their values.

Version 3.5.1 - 10/11/2013

* Fixed issue with tables and version 3.5.

Version 3.5 - 10/7/2013

* Added sub selection color for subselecting results from he datagrid.

* Fixed Relate error when using fields all="true"

* Fixed issue with choose relate dialog not closing using the X in the upper right corner.

* When buffering during a graphical search, the buffer graphic is now removed after the search is complete.