topic Re: Enhanced Search Widget - Searching Multiple Fields in ArcGIS Viewer for Flex Questions

Enhanced Search Widget - Searching Multiple Fields

ionarawilson1 — Mon, 25 Jun 2012 16:54:11 GMT

Hi Robert,

I decided to start a new thread as you answered the question I was having before. But now I need to start working on my own service and I need to ask you something about searching multiple fields. In the case of my website (see link below) I want the user to be able to search one field or many fields at the same time. So if the user decides to search all fields - Company (text input), county (dropdown), primary business (dropdown), major product (dropdown) and major species (dropdown), or just two or three of these fields, how can I change that on the xml or do I need to change the code on the mxml also?

http://tfsfrd.tamu.edu/fpd/fpdtx.asp

Thank you for all your help! I appreciate it!

Re: Enhanced Search Widget - Searching Multiple Fields

RobertScheitlin__GISP — Mon, 25 Jun 2012 17:49:15 GMT

Ionara,

Currently the way the widget is setup it expects that all fields specified in the xml will have entries from the user before the search is executed. So you have two possibilities:

Change the code in the mxml. In the function queryFeaturesText there is a area of the code that checks that all inputs have data and if so then the variable isAllInputsfilled is set to true and the search is allowed to execute.

Or you could setup a different expression for each combination of entries (not very practicle but would not require and code change).

Re: Enhanced Search Widget - Searching Multiple Fields

ionarawilson1 — Mon, 25 Jun 2012 18:04:12 GMT

Thank you Robert. I will try the first idea first!!! Thanks!

Re: Enhanced Search Widget - Searching Multiple Fields

ionarawilson1 — Mon, 25 Jun 2012 19:34:26 GMT

Robert, why on the enhanced search widget I can't make the graphic tools work? For example, I draw a polygon and it does not select anything. However if I use the search widget it works. I thought it was something I was doing but when I tried the link on the esri page the same problems happened.

Re: Enhanced Search Widget - Searching Multiple Fields

RobertScheitlin__GISP — Mon, 25 Jun 2012 19:37:35 GMT

Ionara,

You are likely forgetting to click the search button if you have the "enable multi-part graphics" checked.

Re: Enhanced Search Widget - Searching Multiple Fields

ionarawilson1 — Mon, 25 Jun 2012 19:41:19 GMT

Actually it works when I click search when I run from Flash Builder but not from the link at

http://gis.calhouncounty.org/FlexViewer3.0/index.html?config=config-eSearch.xml&search=2&slayer=4&exprnum=1

Do you know why?

Re: Enhanced Search Widget - Searching Multiple Fields

RobertScheitlin__GISP — Mon, 25 Jun 2012 19:47:42 GMT

Ionara,

Still likely your error. If you are using that url it zooms you to my county and when you switch to the graphical search the first layer is Louisville Zoning (well those are in Kentucky not Alabama) so you will not get any results unless you change the graphical search layers to Road centerlines (which are in Alabama).

Re: Enhanced Search Widget - Searching Multiple Fields

ionarawilson1 — Mon, 25 Jun 2012 21:34:06 GMT

It makes sense. Thanks! Still trying to figure out how to query multiple fields....

Re: Enhanced Search Widget - Searching Multiple Fields

RobertScheitlin__GISP — Sat, 11 Dec 2021 07:14:53 GMT

Ionara,

I have an example of querying multiple fields in the SearchWidget.xml that comes in the download:

        <layer>
            <definitionexpression></definitionexpression>
            <enableexport>true</enableexport>
            <name>Road Centerlines</name>
            <url>http://gis.calhouncounty.org/ArcGIS/rest/services/Highway/MapServer/5</url>
            <expressions>
                <expression alias="Road Name and Zip" textsearchlabel="Search by Road Name and Left Zipcode and Right Zip:">
                    <values>
                        <value prompt="Exmaple: ANDREW">RD_NAME = '[value]'</value>
                        <value prompt="Exmaple: 36201">AND ZIP_L = [value]</value>
                        <value prompt="Exmaple: 36201">AND ZIP_R = [value]</value>
                    </values>
                </expression>
                <expression alias="Road Surface" textsearchlabel="Search by Surface Type:">
                    <values>
                        <value prompt="Example: Asphalt" field="Surf_Type" usedomain="true">Surf_Type = '[value]'</value>
                    </values>
                </expression>
                <expression alias="Open SQL" textsearchlabel="Search by Typing Full SQL:">
                    <values>
                        <value prompt="Exmaple: RD_NAME = 'ANDREW' AND ZIP_L = 36201">[value]</value>
                    </values>
                </expression>
            </expressions>

Re: Enhanced Search Widget - Searching Multiple Fields

ionarawilson1 — Tue, 26 Jun 2012 15:03:18 GMT

Thank you for the tip Robert. I will post a new thread if I get stuck!! Thanks!

Re: Enhanced Search Widget - Searching Multiple Fields

EricGardecki — Wed, 27 Jun 2012 16:53:27 GMT

I don't want to hijack a thread but I have a tiny question about searching multiple fields. I noticed that you can't hit the enter key to run the search when you have multiple search fields, but you can any other time. Is there a remedy for this? Or maybe I'm making some dumb mistake?

I know I'm going to get some complaint calls over this even though it's such a small thing. 🙂

thanks

Re: Enhanced Search Widget - Searching Multiple Fields

RobertScheitlin__GISP — Wed, 27 Jun 2012 20:35:52 GMT

Eric,

No the enter key event listener was removed for multi field searches as there are now more than one input object that would need to listen for the event and then check if all inputs are valid, so I just removed it.

Re: Enhanced Search Widget - Searching Multiple Fields

ionarawilson1 — Thu, 28 Jun 2012 20:19:56 GMT

I am not sure it is the same question that Eric had, but I notice that for some of the layers, if I click choose a layer field and accept the default choice, I can click on "Search" but if I click, on another option inside the dropdown menu, it automatically searches the records for me without giving me the choice on clicking on the Search Button. Is it possible to change that?

Re: Enhanced Search Widget - Searching Multiple Fields

RobertScheitlin__GISP — Thu, 28 Jun 2012 20:35:23 GMT

Ionara,

No t sure why you would want to but sure you have the source code so you can change anything you want.

Re: Enhanced Search Widget - Searching Multiple Fields

ionarawilson1 — Fri, 29 Jun 2012 18:24:01 GMT

ok, thanks