<?xml version="1.0" encoding="UTF-8"?>
Contains the queries for selecting objects that will be added as "Database(document)" in migration center
“r_object_id” is the unique identifier of the current version and “i_chronicle_id” is the attribute the identify all versions of this document.
<query type="main" name="fme documents" key= "r_object_id" versionid="i_chronicle_id">
select r_object_id, i_chronicle_id from rep1.dm_document_sp where subject like ‘migration-center’
This query will be run once for every row returns by “main” query. The placeholder “?” will be replaces with the value of column “i_chronicle_id” from “main” query. Every row returned by this query will correspond as a new object in MC database.
<query type="versions" name = "fme document versions" key="r_object_id" parentid = "i_antecedent_id">
select r_object_id, decode(i_antecedent_id, '0000000000000000', null,i_antecedent_id) as i_antecedent_id
This query will be run once for every row returns by “versions” query. The placeholder “?” will be replaces with the value of column “r_object_id” (specified in “key” attribute) from “versions” query. All values returned by this query will be added as source attributes in MC database.
<query type="version-metadata">
select object_name, title, i_antecedent_id from rep1.dm_document_sp where r_object_id = ?
<query type="version-metadata">
select keywords, r_version_label from rep1.dm_document_rp where r_object_id = ?
<query type="version-metadata" contentpath="set_file">
select doc.R_OBJECT_ID, content.set_file
from rep1.dm_document_sp doc, rep1.dmr_content_sp content
where doc.I_CONTENTS_ID = content.r_object_id