<configuration> <layers> <layer> <token/> <definitionexpression/> <enableexport>true</enableexport> <name>Owner Name Search</name> <url>http://192.1.1.xxx:6080/arcgis/rest/services/MyMapService/MapServer/4</url> <expressions> <expression alias="Owner_Name" textsearchlabel="Search Owner Last Name:" isvaluerequired="true"> <values> <value prompt="Example: Owner: " isvaluerequired="true" operator="AND">upper(santarosagis.GISADMIN.QS36F_SRVIEW1.OWNER_NAME) LIKE upper('%[value]%')</value> </values> </expression> </expressions> <graphicalsearchlabel>Use one of the graphical search tools to select Zoning</graphicalsearchlabel> <spatialsearchlayer>false</spatialsearchlayer> <titlefield>OWNER_NAME</titlefield> <fields all="true"/> <links/> <zoomscale usegeometry="true" zoompercent="2"/> <autoopendatagrid>false</autoopendatagrid> <queryattachments>false</queryattachments> <relates/> <symbology> <simplefillsymbol color="0xff0000" alpha="0.5"> <outline color="0xff0000" alpha="0.8" width=".4"/> </simplefillsymbol> </symbology> </layer> </layers> <tables> <table> <token/> <definitionexpression/> <enableexport>true</enableexport> <enableprintgrid title="Selected Sub Types">true</enableprintgrid> <name>Sub Type</name> <url>http://192.1.1.xxx:6080/arcgis/rest/services/MyMapService/MapServer/5</url> <expressions> <expression alias="Owner_Name" textsearchlabel="Search for Owner Last Name:"> <values> <value prompt="Example: 100" userlist="60,70,80,90,100" autosubmit="false">REPLSCORE > [value]</value> </values> </expression> </expressions> <titlefield>FACILITYID</titlefield> <fields all="false"> <field name="FACILITYID"/> <field name="FCLASS" alias="Feature Class" gridfield="true"/> <field name="ASSETCOND" alias="Asset Condition" gridfield="true"/> <field name="CONDDATE" alias="Condition Date" dateformat="MM/DD/YYYY" useutc="true" gridfield="true"/> <field name="REPLSCORE" alias="Replacement Score" gridfield="true"/> </fields> <links> <link alias="View Traffic Photo" disablelinksifnull="true"> <![CDATA[{agree_with_incident}]]> <icon><![CDATA[assets/images/i_camera.png]]></icon> </link> </links> <relates/> <queryattachments>false</queryattachments> </table> </tables> </symbols> </configuration>
Elizabeth,
So you have tested the Query at the REST End point just like I said in my last post (not just in ArcMap)?...
I actually have never tested a SDE View Join in my widget so it might be an issue there...