WLF_LI_LIKE_COUNT_V

Details

• Schema: FUSION

• Object owner: WLF

• Object type: VIEW

Columns

Name
LEARNING_ITEM_ID LEARNING_ITEM_TYPE STATUS LIKES_COUNT

Query

SQL_Statement

SELECT Events.LEARNING_ITEM_ID AS LEARNING_ITEM_ID, Learning_Items.LEARNING_ITEM_TYPE, Event_Social.STATUS, COUNT(Events.LEARNING_ITEM_ID) AS LIKES_COUNT FROM WLF_LEARNING_ITEMS_F Learning_Items, WLF_EVENTS Events, WLF_EVENT_SOCIAL Event_Social WHERE TRUNC(SYSDATE) BETWEEN Learning_Items.EFFECTIVE_START_DATE AND Learning_Items.EFFECTIVE_END_DATE AND Learning_Items.LEARNING_ITEM_ID = Events.LEARNING_ITEM_ID AND Events.EVENT_ID = Event_Social.EVENT_ID AND EVENT_TYPE = 'ORA_LI_SOCIAL' AND Events.EVENT_SUB_TYPE = 'ORA_EVT_SUBT_LIKE' GROUP BY Events.LEARNING_ITEM_ID, Learning_Items.LEARNING_ITEM_TYPE, Event_Social.STATUS