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

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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