Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Join Course and Offering assignment table
Summary:
Hi,
I'm trying to create a Datamodel (basically a query) to join Course Assignment and Offering Assignment.
Both uses the same table WLF_ASSIGNMENT_RECORDS_F, just different "where clause".
Course → select * from WLF_ASSIGNMENT_RECORDS_F where LEARNING_ITEM_TYPE = 'ORA_COURSE'
Offering → select * from WLF_ASSIGNMENT_RECORDS_F where LEARNING_ITEM_TYPE = 'ORA_CLASS'
And then I use WLF_LI_CLASSES_F to get the relationship between Course and Offering.
This is how I join originally.
select 'COURSE', A.ASSIGNMENT_RECORD_NUMBER as COURSE_ASSIGNMENT_RECORD_NUMBER, A.LEARNING_ITEM_ID as COURSE_LEARNING_ITEM_ID
,B.LEARNING_ITEM_ID as WLF_LI_CLASSES_F_LEARNING_ITEM_ID
Tagged:
0