Enhanced-Search-Widget-for-FlexViewer Part III

[RobertScheitlin__GISP]

All,

   Here is a new thread to post questions and discuss the Enhanched Search Widget. The old thread was getting too long.

[RobertScheitlin__GISP]

Elizabeth,

   Querying a layer that has a join to a standalone table in SDE is absolutely supported and has been thoroughly test in this widget. There is even a running example of this on the widget live preview site. So it is just a matter of your configuration then. So what you have currently setup in the eSearchWidget.xml... Does it error out or give no results or what?

One of the immediate thing I saw was you had the operator attribute in the value tag and that is only needed when you have multiple value tags for using more than one field in the SQL Expression.

<value prompt="Example: Owner: " isvaluerequired="true" operator="AND">upper(santarosagis.GISADMIN.QS36F_SRVIEW1.OWNER_NAME) LIKE upper('%[value]%')</value>

If you take you eSearchWidget.xml file and zip it you will be able to attach the whole thing. You dont have to worry about masking the IP address as that IP is only an internal IP for your network and not something anyone could ping.

[ElizabethB]

Here's my zip file, Robert. I removed the part of your code that searches by Sub list (although I know we will want that later on down the line). So all I need this tool to do now is just search by owner name. I also removed the metric distance searches.. I left my mistake w/the operator syntax for you to look at.  When I run the tool I get a error #1009.

Thanks again for your help!

[RobertScheitlin__GISP]

Elizabeth,

  What you sent is the zip is not the eSearchWidget.xml...

[ElizabethB]

Elizabeth,

  What you sent is the zip is not the eSearchWidget.xml...

Hmm, am not seeming to have a good week!  Ok, where exactly do I find said widget xml file? I copied the xml that shows up in the flex builder when I click 'modify' on the widget tab. That is the file that I have been editing, is that the problem? I know I really need a flex builder class. Unfortunately this project is fast tracked & has to come before any training. 

Thanks for helping!

[RobertScheitlin__GISP]

Elizabeth,

   If you are on a windows machine then the files would be located at:
C:\inetpub\wwwroot\flexviewers\YOUR APPLICATION NAME\widgets\eSearch

[ElizabethB]

Ok, here it is then! Thanks-

[RobertScheitlin__GISP]

Elizabeth,

   Can you paste your search url into your browser (http://192.1.1.163:6080/arcgis/rest/services/MyMapService/MapServer/5) and hit enter, this will take you to the Rest Service endpoint and there it will list all the fields and other details of your map service layer and if you have the ability to pint that page to a pdf or just take some screen captures of that info so I can take a look.

[ElizabethB]

Does this help any? Screenshot of the main services page of this service, and some of the SRView1 showing most of the fields.  I didn't want to bombard you so if I haven't sent enough just let me know. Thanks!

[DavidColey]

Hi Robert-
I aplogize for potentially being in the wrong thread.  I was wondering if you had any difficulites in displaying coded values in either the primary feature class or related table when using the Enhanched Search Widget:

Version: 3.2.1
Build Date: 4/1/2013

I seem to be having difficulty displaying domain descriptions in fields that use coded value domains when I am also utililizing the usesubtype="true" setting.  Any insight is appreciated and btw nice meeting you at the Dev Conference in March this year

thanks
David Coley
Sarasota County GIS
Sarasota County, FL

[RobertScheitlin__GISP]

Elizabeth,

   As layer 5 is a Table and not a layer with geometry it has to be added to the tables and not the layers:

    <layers/>
    <tables>
        <table>
            <token/>
            <definitionexpression/>
            <enableexport>true</enableexport>
            <enableprintgrid title="Selected Owners">true</enableprintgrid>
            <name>Owner Name Search</name>
            <url>http://192.1.1.163:6080/arcgis/rest/services/MyMapService/MapServer/5</url>
            <expressions>
                <expression alias="Owner_Name" textsearchlabel="Search Owner Last Name:" isvaluerequired="true">
                    <values>
                        <value prompt="Example: Owner: " isvaluerequired="true" >upper(OWNER_NAME) LIKE upper('%[value]%')</value>
                    </values>
                </expression>
            </expressions>
            <titlefield>OWNER_NAME</titlefield>
            <fields all="true"/>
            <links/>
            <queryattachments>false</queryattachments>
            <relates/>
            </relates>
        </table>
    </tables>