ADMIN_TABLE

ADMIN_TABLE

Used in: CONFIG
Parent elements: METADATA_CONFIG

<ADMIN_TABLE	Attribute Description Table
*idcolumn ="string"* *insert ="string"* *tablename ="string"* filter ="string" > (m) <RESPONSE_COLUMN... /> </ADMIN_TABLE >
Bold: Attribute or child element is required. (m): Child element can be used multiple times.

Description:

Provides information on an external administration table.

Restrictions:

The administration table is user-defined table used in addition to the metadata tables generated by the Metadata Server. You must create the table separately using your database administration tools. The table cannot be created using ArcCatalog.

Notes:

The ADMIN_TABLE is an external database table joined to the main internal metadata table. The name of this internal table is defined in the configuration file under TABLE_NAME. The administration table is visible to an administrator, but not clients. The table can be used to store additional fields of data for use in queries.

Attribute Descriptions for ADMIN_TABLE:

Attribute	Usage	Back to Top
filter	1 SQL where clause to execute against the ADMIN_TABLE. The clause is appended with an AND to every where clause generated by SEARCH_METADATA.
idcolumn	2 Name of field in the ADMIN_TABLE containing the join time ussed to join the administration table to the main internal metadata table. The ID column in the ADMIN_TABLE must be a string field 38 characters in length.
insert	3 SQL INSERT statement to execute against the ADMIN_TABLE whenever a new document is added to the Metatdata Server. Must contain '%s' (including the single quotes) in place of the ID field value. The value '%s' is a placeholder for the internal ID and is assigned automatically by the Metadata Server. The ID field must be a string field 38 characters in length. In the following example, the ADMIN_TABLE has two columns: the first is "docUUID", and the second is "service_running". The column "docUUID" is the field used to relate the ADMIN_TABLE to the main internal metadata table. INSERT into <ADMIN_TABLE> (docUUID, service_running) values ('%s','No').
tablename	4 Name of external ADMIN_TABLE for administrator's use.

Examples for ADMIN_TABLE:

Example 1:

Back to Top

<?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" />
    </ENVIRONMENT>
    <METADATA_CONFIG>
      <WORKSPACES>
        <SDEWORKSPACE name="unique_name" server="server_name" instance="port:5151" database="optional_database_name" user="user_name" password="user_password" />
      </WORKSPACES>
      <ADMIN_TABLE tablename="AdminTable" idcolumn="DocUUID" filter="Approved='Y'" insert="INSERT INTO AdminTable (DocUUID, Approved) VALUES ('%s', 'N')">
        <RESPONSE_COLUMN columnname="Approved" />
      </ADMIN_TABLE>
      <METADATA_CONTENT validate="true" />
      <TABLE_NAME prefix="imsmetadata" />
    </METADATA_CONFIG>
  </CONFIG>
</ARCXML>