HDL – Query to find sectionId for Talent Profile Item load
With enhanced profiles (v2), sectionId is a required attribute while loading the Profile Items to a worker’s profile. Section Id can be found using below query:
select SECTION_ID from HRT_PROFILE_TYP_SECTIONS WHERE CONTENT_TYPE_ID=110 AND SECTION_CONTEXT LIKE 'PERSON%'
select * from HRT_PROFILE_SECTIONS_b where content_type_id=125 order by creation_date desc