Need sql query to get Performance Library goal task and target outcomes
Need sql query to get Performance Library goal task and target outcomes
I am using below to get performance library goals
SELECT *FROM hrt_content_items_vl hciv
WHERE hciv.content_type_id = (SELECT content_type_id FROM hrt_content_types_vl WHERE content_type_name ='Goals')
AND hciv.name = 'Collaborates'
AND hciv.item_text_9 = 'PERFORMANCE'
Unable to find join to get the task(HRG_GOAL_ACTIONS) and target outcomes(HRG_GOAL_TARGET_OUTCOMES)
Tagged:
0