You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!