<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...