ADMIN_TABLE  Examples

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:


Restrictions:


Notes:


Attribute Descriptions for ADMIN_TABLE:

Attribute Usage Back to Top
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.
 

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>