WLF_LI_VIEW_COUNT_V

Details

• Schema: FUSION

• Object owner: WLF

• Object type: VIEW

Columns

Name
LEARNING_ITEM_ID LEARNING_ITEM_TYPE STATUS VIEWS_COUNT

Query

SQL_Statement

SELECT Events.LEARNING_ITEM_ID, Learning_Items.LEARNING_ITEM_TYPE, Event_Attempts.COMPLETION_STATUS AS STATUS, COUNT(Events.LEARNING_ITEM_ID) AS VIEWS_COUNT FROM WLF_LEARNING_ITEMS_F Learning_Items, WLF_EVENTS Events, WLF_EVENT_ATTEMPTS Event_Attempts WHERE TRUNC(SYSDATE) BETWEEN Learning_Items.EFFECTIVE_START_DATE AND Learning_Items.EFFECTIVE_END_DATE AND Events.LEARNING_ITEM_ID=Learning_Items.LEARNING_ITEM_ID AND Events.EVENT_ID = Event_Attempts.EVENT_ID AND EVENT_TYPE = 'ORA_LI_ATTEMPT' GROUP BY Events.LEARNING_ITEM_ID, Learning_Items.LEARNING_ITEM_TYPE, Event_Attempts.COMPLETION_STATUS