Enhanced-Search-Widget-for-FlexViewer Part II

RobertScheitlin__GISP · ‎04-19-2012

All,

I am pleased to announce the next release of my eSearch Widget.

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

Version 2.5.1.7 - 4/19/2012
* Added ability to search (flat/standalone/no geometry) tables.
* This time all Zooming uses the same scaling (popup, datagrid, widget results, zoom to all).
* Added Relates icon/button to datagrids so that you can click on it in the datagrid to
open relates choice dialog.
* Move all skins to a skins package for cleaner organization.
* Links that are not associated with a field now work.
* Ability to disable the relates tab in the fixed widget is now configurable.

ChrisA · ‎02-07-2013

Hi Robert, The datagrid doesn't show up for me not matter what I try. Can you please take a look at my code attached.

Thanks,
Chris

RobertScheitlin__GISP · ‎02-07-2013

Chris,

Seems how you are configured for using the fixed datagrid did you add the fixed datagrid to your main config.xml in the UI elements section?

    <!-- UI elements -->
    <widget left="0" right="0" bottom="0" url="widgets/eSearch/SearchWidgetFixedDG.swf" config="widgets/eSearch/SearchWidgetFixedDG.xml"/>

ChrisA · ‎02-07-2013

Robert,

Awesome, thank you !

That fixed it . . . I have a data grid. Love the Widget !

Chris

GeraldLee__GISP · ‎02-08-2013

Robert,
I am using your lastest ESearch 3.1.8 (compiled) inside arcgis viewer 3.1. I have published a 10.1 service from a Sql Server 2008 SDE that has a single join to a table also in SDE. All works well as long as <fields all="true">. But when I use <fields all="false">, i get error [RPC Fault faultstring= "Invalid or missing input parameters." faultcode="400" faultdetail=""]. I have wasted an entire day, testing different parameters, changing formats, republishing services,etc. basically all i know to do, with my limited knowledge. I need another set of eyes if possible. I'm sure its something simple that im missing. If you could look over my syntax, I'd really appreciate it and I'd gladly reimburse your time with some adult beverages in Palm Springs :).

Beautiful widgets and excellent documentation.
Thanks alot for all your work,
Gerald

<layer>
            <definitionexpression/>
            <enableexport>false</enableexport>
            <enableprintgrid title="Selected Parcels">true</enableprintgrid>
            <name>Parcels</name>
            <url>http://maps3.murfreesborotn.gov/mboro/rest/services/GIS/PARCELS/MapServer/1</url>
            <expressions>
                <expression alias="OWNER NAME" textsearchlabel="Search by Owner Name:">
                    <values>
                        <value prompt="Example: SMITH JOSEPH">upper(CURRENT_GIS_OWNER_ADDRESS.NAME1) like upper('%[value]%')</value>
                    </values>
                </expression>
                <expression alias="GISLINK" textsearchlabel="Search by Parcel GISLINK Number:">
                    <values>
                        <value prompt="Example: 091N C 00900">Parcels.GISLINK = '[value]'</value>
                    </values>
                </expression>
            </expressions>
            <graphicalsearchlabel>Use one of the graphical search tools to select Parcels</graphicalsearchlabel>
            <spatialsearchlayer>true</spatialsearchlayer>
            <titlefield>GISLINK</titlefield>
            <fields all="false">
                <field name="RuthLIS.DBO.Parcels.GISLINK" visible="true" gridfield="true"/>
                <field name="RuthLIS.DBO.CURRENT_GIS_OWNER_ADDRESS.NAME1" alias="PROPERTY OWNER" gridfield="true"/>
                <field name="RuthLIS.DBO.CURRENT_GIS_OWNER_ADDRESS.ADDRESS1" alias="OWNER ADDRESS" gridfield="true"/>
                <field name="RuthLIS.DBO.CURRENT_GIS_OWNER_ADDRESS.CITY" alias="OWNER CITY" gridfield="true"/>
                <field name="RuthLIS.DBO.CURRENT_GIS_OWNER_ADDRESS.STATE" alias="OWNER STATE" gridfield="true"/>
                <field name="RuthLIS.DBO.CURRENT_GIS_OWNER_ADDRESS.ZIPCODE" alias="OWNER ZIPCODE" gridfield="true"/>
                <field name="RuthLIS.DBO.Parcels.STREETNO" alias="STREET NUMBER" gridfield="true"/>
                <field name="RuthLIS.DBO.Parcels.STREETNAME" alias="STREET NAME" visible="true" gridfield="true"/>
                <field name="RuthLIS.DBO.CURRENT_GIS_OWNER_ADDRESS.ACCOUNTNO" linkprefix="http://rutherfordcounty.org/apps/propertydata/REALRESULTS.ASPX?acct=" linksuffix="&version=20121231999&taxyear=2012" hyperlinkaliastext="ASSESSOR LINK" visible="true" hyperlinkgridfield="true"/>
            </fields>
            <links/>
            <zoomscale usegeometry="true" zoompercent="1.6"/>
            <autoopendatagrid>true</autoopendatagrid>
            <relates/>
            <queryattachments>false</queryattachments>
        </layer>

AnthonyGiles · ‎02-08-2013

Gerald,

Your expression value:

<value prompt="Example: 091N C 00900">Parcels.GISLINK = '[value]'</value>

is searching against a numeric field so you do not need the speech marks:

<value prompt="Example: 091N C 00900">Parcels.GISLINK = [value]</value>

Regards

Anthony

P.S. If it works I will also be in Palm Springs for a beer 😮

RobertScheitlin__GISP · ‎02-08-2013

Gerald,
My initial scan of your configuration leads me to believe that this is your issue:

You currently have:

<value prompt="Example: SMITH JOSEPH">upper(CURRENT_GIS_OWNER_ADDRESS.NAME1) like upper('%[value]%')</value>

Should be:

<value prompt="Example: SMITH JOSEPH">upper(RuthLIS.DBO.CURRENT_GIS_OWNER_ADDRESS.NAME1) like upper('%[value]%')</value>

GeraldLee__GISP · ‎02-08-2013

Anthony/Robert: I've made both suggested changes but I'm still having the same error. Thanks again for your time.

RobertScheitlin__GISP · ‎02-08-2013

Gerald,

Upon more examination you have the same issue in other areas:

        <layer>
            <definitionexpression/>
            <enableexport>false</enableexport>
            <enableprintgrid title="Selected Parcels">true</enableprintgrid>
            <name>Parcels</name>
            <url>http://maps3.murfreesborotn.gov/mboro/rest/services/GIS/PARCELS/MapServer/1</url>
            <expressions>
                <expression alias="OWNER NAME" textsearchlabel="Search by Owner Name:">
                    <values>
                        <value prompt="Example: SMITH JOSEPH">upper(RuthLIS.DBO.CURRENT_GIS_OWNER_ADDRESS.NAME1) like upper('%[value]%')</value>
                    </values>
                </expression>
                <expression alias="GISLINK" textsearchlabel="Search by Parcel GISLINK Number:">
                    <values>
                        <value prompt="Example: 091N C 00900">RuthLIS.DBO.Parcels.GISLINK = '[value]'</value>
                    </values>
                </expression>
            </expressions>
            <graphicalsearchlabel>Use one of the graphical search tools to select Parcels</graphicalsearchlabel>
            <spatialsearchlayer>true</spatialsearchlayer>
            <titlefield>RuthLIS.DBO.Parcels.GISLINK</titlefield>
            <fields all="false">
                <field name="RuthLIS.DBO.Parcels.GISLINK" visible="true" gridfield="true"/>
                <field name="RuthLIS.DBO.CURRENT_GIS_OWNER_ADDRESS.NAME1" alias="PROPERTY OWNER" gridfield="true"/>
                <field name="RuthLIS.DBO.CURRENT_GIS_OWNER_ADDRESS.ADDRESS1" alias="OWNER ADDRESS" gridfield="true"/>
                <field name="RuthLIS.DBO.CURRENT_GIS_OWNER_ADDRESS.CITY" alias="OWNER CITY" gridfield="true"/>
                <field name="RuthLIS.DBO.CURRENT_GIS_OWNER_ADDRESS.STATE" alias="OWNER STATE" gridfield="true"/>
                <field name="RuthLIS.DBO.CURRENT_GIS_OWNER_ADDRESS.ZIPCODE" alias="OWNER ZIPCODE" gridfield="true"/>
                <field name="RuthLIS.DBO.Parcels.STREETNO" alias="STREET NUMBER" gridfield="true"/>
                <field name="RuthLIS.DBO.Parcels.STREETNAME" alias="STREET NAME" visible="true" gridfield="true"/>
                <field name="RuthLIS.DBO.CURRENT_GIS_OWNER_ADDRESS.ACCOUNTNO" linkprefix="http://rutherfordcounty.org/apps/propertydata/REALRESULTS.ASPX?acct=" linksuffix="&amp;version=20121231999&amp;taxyear=2012" hyperlinkaliastext="ASSESSOR LINK" visible="true" hyperlinkgridfield="true"/>
            </fields>
            <links/>
            <zoomscale usegeometry="true" zoompercent="1.6"/>
            <autoopendatagrid>true</autoopendatagrid>
            <relates/>
            <queryattachments>false</queryattachments>
        </layer>

GeraldLee__GISP · ‎02-08-2013

I had originally changed those too thinking that might be the issue. I've changed them so many times ive lost track. But I'm still getting same error though.. I've done about every combo i can think of.. Only thing that works is when its <fields all="true"> its probably one lousy comma or space somewhere....

AnthonyGiles · ‎02-08-2013

Gerald,

From what I can see you have fields coming from different tables in your fields area but you do not have any relates set up. Your fields need to come from the same layer.

Regards

Anthony