HDL or Metadata file for loading content items

Dat File Name: ContentItem.dat
 
METADATA|ContentItem|ContentItemValueSetName|ContentItemCode|ItemDescription|DateFrom|ContextName|ContentSupplierCode|ContentTypeId|Name
 
MERGE|ContentItem||||1951/01/01|CERTIFICATION|U|103|Safety Officer
Select ITEM.CONTENT_ITEM_ID, ITEM.CONTENT_TYPE_ID, ITEM.CONTENT_ITEM_CODE,ITEM.DATE_FROM,
ITEM.BUSINESS_GROUP_ID, TL.NAME, TL.ITEM_DESCRIPTION, TYPE.CONTEXT_NAME, ITEM.CREATED_BY,
ITEM.CREATION_DATE, ITEM.LAST_UPDATED_BY, ITEM.LAST_UPDATE_DATE
from hrt_content_items_b ITEM,
hrt_content_items_tl TL,
hrt_content_types_b TYPE
where ITEM.CONTENT_ITEM_ID=TL.CONTENT_ITEM_ID
AND ITEM.CONTENT_TYPE_ID=TYPE.CONTENT_TYPE_ID
AND UPPER(TYPE.CONTEXT_NAME) =UPPER('CERTIFICATION')

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.

Technical Contents - SQL-HDL
Posted by : Mohammad
Follow on Linkedin