ADMIN_TABLE

Used in

CONFIG  

Parent elements

METADATA_CONFIG 

Syntax

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

Description

Allows a Metadata Service to use information in an external administrative table.

Restrictions

• The administrative table is a user-defined table that can be 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 or ArcSDE.
• When using ADMIN_TABLE, the element must be the first element within METADATA_CONFIG.
• The table name and column names must match the exact case of the table and column name in the database.
• This element is not available from the ArcIMS Author interface.

Notes

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

Attribute Descriptions for ADMIN_TABLE

Attribute	Usage
filter	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	Name of field in the ADMIN_TABLE containing the Globally Unique Identifiers (GUIDs) that uniquely identify each published document. This field is used to join the administration table to the main internal table. The values in this field must correspond to the values in the DocUUID column in the main internal metadata table. The ID field must be a string field 38 characters in length.
insert	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. 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') where ADMIN_TABLE is the tablename value docUUID is the idcolumn value
tablename	Name of the external ADMIN_TABLE for administrator's use.

Back to top 

Examples for ADMIN_TABLE

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

Back to top