Showing posts with label Content Item. Show all posts
Showing posts with label Content Item. Show all posts

Monday, 2 August 2021

HDL Template for Content Item

 For this use ContentItem.dat file.

You can see step by step video to load Content Item data for talent profile using this Link


Find Content Item Value set Name using below Query - 

SELECT 

a.content_value_set_id as ContentItemValueSetId, 

a.content_value_set_code, 

b.value_set_name as ContentItemValueSetName, 

value_set_description

FROM FUSION.hrt_content_tp_valuesets_b a, FUSION.hrt_content_tp_valuesets_tl b

WHERE a.content_value_set_id = b.content_value_set_id

and b.language = 'US' ;


Please find the below sample template :

METADATA|ContentItem|SourceSystemOwner|SourceSystemId|ContextName|ContentItemCode|Name|ItemDescription|DateFrom|DateTo|ContentItemValueSetName

MERGE|ContentItem|XXTEST|XXTEST_BTECH|DEGREE||BTECH|BTECH|1951/01/01||Degrees


How to sort data in rtf template

  How to sort data in rtf template Sort the data in Data model is the recommended approach. But if you want to sort the data in rtf template...