Extracting Asset Data › How to Extract Asset Data › Create a Mapping File (Database) › Map and Extract Data with Query and Value Attributes (Database)

Map and Extract Data with Query and Value Attributes (Database)

The data-related tags that specify how to process and retrieve the mapping file and data typically consist of query and value attributes.

• A query attribute in any tag consists of a valid SQL query. The result of the query is used by tags having value attributes referencing the tags having a query attribute referencing the tag.

  The asset tag is the root tag for an asset and should have a query listing unique asset IDs from the target database. One XML file is created for each unique asset ID contained in the result set of the query attribute for the asset tag. All subsequent tags under the asset tag either have a query or value attribute referencing another tag. At runtime, the attributes receive runtime values from the tags they reference.

  For example, if a general tag query uses asset ID extracted in an asset tag query, the query attribute of the general tag will contain an annotation referencing the asset tag. This means that the general tag for each asset ID query changes based on the asset ID.

• The value attribute of the tags referencing some other tag is similar to the previous example.