STOREDQUERIES

Used in

Servers

Parent elements

Syntax

<STOREDQUERIES > No Attributes (r)(m)<STOREDQUERY... /> </STOREDQUERIES >
(r): Attribute or child element is required. (m): Child element can be used multiple times.

Description

The main element used around one or more STOREDQUERY expressions in a stored query EXTENSION.

Examples for STOREDQUERIES

<?xml version="1.0" encoding="UTF-8"?>
<ARCXML version="1.1">
  <CONFIG>
    <ENVIRONMENT>
      <LOCALE country="US" language="en" variant="" />
      <UIFONT color="0,0,0" name="Arial" size="12" style="regular" />
      <SCREEN dpi="96" />
    </ENVIRONMENT>
    <MAP>
      <PROPERTIES>
        <ENVELOPE minx="-141.0030059814453" miny="41.9133186340332" maxx="-52.62028121948242" maxy="83.10832214355469" name="Initial_Extent" />
        <MAPUNITS units="decimal_degrees" />
        <FILTERCOORDSYS id="4326" />
        <FEATURECOORDSYS id="4326"/>
      </PROPERTIES>
      <WORKSPACES>
        <SHAPEWORKSPACE name="shp_ws-0" directory="<path to CANADA ESRIDATA>" />
      </WORKSPACES>
      <LAYER type="featureclass" name="province" visible="true" id="0">
        <DATASET name="province" type="polygon" workspace="shp_ws-0" />
        <SIMPLERENDERER>
          <SIMPLEPOLYGONSYMBOL filltransparency="1.0" fillcolor="127,127,127" />
        </SIMPLERENDERER>
        <EXTENSION type="StoredQuery">
          <STOREDQUERIES>
            <STOREDQUERY name="Provinces">
              <QUERY where="( NAME = '[%var%]' )" subfields="#SHAPE# AREA CODE NAME POP1991 POP91_SQMI" />
              <SQVAR position="0" name="[%var%]">
                <FIELD name="NAME" precision="0" type="12" size="25" />
              </SQVAR>
            </STOREDQUERY>
          </STOREDQUERIES>
      </EXTENSION>
      </LAYER>
    </MAP>
  </CONFIG>
</ARCXML>