Dave, Are the shape and objectid fields visible in your data or do you have them hidden when you published the service? I honestly have no experience with database views working in my widget so you might be the first...(and it might not work with them).
upper(ZONING_NAME) LIKE upper('%[value]%')
<symbols> <simplefillsymbol color="0xff0000" alpha="0.0"> <outline color="0x00FFFF" alpha="0.8" width="2" /> </simplefillsymbol> <!-- You can have one or the other, either simplemarkersymbol or picturemarkersymbol defined for your point results NOT BOTH. picturemarkersymbol will override simplemarkersymbol if you do not have it commented out. --> <!-- <simplemarkersymbol style="square" size="12" color="0xff0000" alpha="0.5" xoffset="0" yoffset="0" angle="0"> <outline style="solid" color="0x000000" alpha="1" width="1"/> </simplemarkersymbol> --> <picturemarkersymbol url="assets/images/i_search.png" height="20" width="20" xoffset="1" yoffset="1" /> <simplelinesymbol color="0x00FFFF" alpha="0.8" width="2" /> </symbols>
<symbology> <simplefillsymbol color="0x00FFFF" alpha="0"> <outline color="0x00FFFF" alpha="1.0" width="2" /> </simplefillsymbol> </symbology>
[RPC Fault faultString="Invalid or missing input parameters." faultcode="400" faultDetail=""]
<layer> <definitionexpression></definitionexpression> <enableexport>true</enableexport> <name>New Jersey Correctional Institutions</name> <url>http://xyz.xyz.xyz.xyz:8080/arcgis/rest/services/NewJerseyLayersService/MapServer/2</url> <expressions> <expression alias="Name" textsearchlabel="Search Institution Name"> <values> <value prompt="Example: Island Heights Police Department">upper(NAME) LIKE upper('%[value]%')</value> </values> </expression> <expression alias="Address" textsearchlabel="Search Institution Address"> <values> <value prompt="Example: 380 Hillsdale Avenue">upper(ADDRESS) LIKE upper('%[value]%')</value> </values> </expression> <expression alias="City" textsearchlabel="Search Institution City"> <values> <value prompt="Example: Chatham">upper(CITY) LIKE upper('%[value]%')</value> </values> </expression> <expression alias="County" textsearchlabel="Search Institution County"> <values> <value prompt="Example: Morris">upper(COUNTY) LIKE upper('%[value]%')</value> </values> </expression> </expressions> <graphicalsearchlabel>Use one of the graphical search tools to select a Correctional Institution</graphicalsearchlabel> <spatialsearchlayer>true</spatialsearchlayer> <titlefield>Name</titlefield> <fields all="false"> <field name="OBJECTID" alias="ID" gridfield="true"/> <field name="NAME" alias ="Name" gridfield="true"/> <field name="ADDRESS" alias="Address" gridfield="true"/> <field name="CITY" alias="City" gridfield="true"/> <field name="COUNTY" alias="County" gridfield="true"/> <field name="TELEPHONE" alias="Phone Number" gridfield="true"/> </fields> <links /> <zoomscale usegeometry="true" zoompercent="1.6" /> <autoopendatagrid>false</autoopendatagrid> <relates /> <queryattachments>false</queryattachments> </layer>
<layer> <definitionexpression></definitionexpression> <enableexport>true</enableexport> <name>New Jersey Hospitals</name> <url>http://xyz.xyz.xyz.xyz:8080/arcgis/rest/services/NewJerseyLayersService/MapServer/7</url> <expressions> <expression alias="Name" textsearchlabel="Search Hospital Name"> <values> <value prompt="Example: Virtuawest Jersey Hospital">upper(NAME) LIKE upper('%[value]%')</value> </values> </expression> <expression alias="Address" textsearchlabel="Search Hospital Address"> <values> <value prompt="Example: 380 Hillsdale Avenue">upper(ADDRESS) LIKE upper('%[value]%')</value> </values> </expression> <expression alias="City" textsearchlabel="Search Hospital City"> <values> <value prompt="Example: Chatham">upper(CITY) LIKE upper('%[value]%')</value> </values> </expression> <expression alias="County" textsearchlabel="Search Hospital County"> <values> <value prompt="Example: Morris">upper(COUNTY) LIKE upper('%[value]%')</value> </values> </expression> </expressions> <graphicalsearchlabel>Use one of the graphical search tools to select a Hospital</graphicalsearchlabel> <spatialsearchlayer>true</spatialsearchlayer> <titlefield>Name</titlefield> <fields all="false"> <field name="OBJECTID" alias="ID" gridfield="true"/> <field name="NAME" alias ="Name" gridfield="true"/> <field name="ADDRESS" alias="Address" gridfield="true"/> <field name="CITY" alias="City" gridfield="true"/> <field name="COUNTY" alias="County" gridfield="true"/> <field name="TELEPHONE" alias="Phone Number" gridfield="true"/> <field name="NAICDESCR" alias="Type" gridfield="true"/> </fields> <links /> <zoomscale usegeometry="true" zoompercent="1.6" /> <autoopendatagrid>false</autoopendatagrid> <relates /> <queryattachments>false</queryattachments> </layer>
<configuration> <layers> <layer> <token/> <definitionexpression/> <enableexport>true</enableexport> <name>Owner Name Search</name> <url>http://192.1.1.xyz: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.xyz: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>
Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.