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.
How to extract the Content ID of a video
Summary
How to extract the Content ID of a video uploaded in the resource catalogContent
Hi,
I need to know the Content ID of a video that has been uploaded in the Catalog Resources.
I tried with the following SQL query, but it seems to extract all the contents in the catalog, except those that are of "video" type.
select T.NAME, T.DESCRIPTION, CONT.*
from WLF_LEARNING_ITEMS_F F
INNER JOIN WLF_LEARNING_ITEMS_F_TL T ON F.LEARNING_ITEM_ID = T.LEARNING_ITEM_ID
INNER JOIN WLF_LI_CONTENT_F CONT
ON F.LEARNING_ITEM_ID = CONT.LEARNING_ITEM_ID
from WLF_LEARNING_ITEMS_F F
INNER JOIN WLF_LEARNING_ITEMS_F_TL T ON F.LEARNING_ITEM_ID = T.LEARNING_ITEM_ID
INNER JOIN WLF_LI_CONTENT_F CONT
ON F.LEARNING_ITEM_ID = CONT.LEARNING_ITEM_ID
Tagged:
0