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>
Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.