AnsweredAssumed Answered

Finding linked content

Question asked by jdiamant on Dec 8, 2016
Latest reply on May 25, 2017 by jdiamant

This request is content system based, so not useful for ASR connection to STATS - it might come in useful for those using openDB.

 

I am looking for assistance with a query that will list the courses that a Content System item is linked to. I have built a query - given below - which will obtain all content within the given schema.  I would like to know if it can be adapted to include the ID of a Courses(s) or Organization(s) when the item has been linked to.

 

SELECT

--COUNT (1)

F.FILE_ID as Files_FID, U.FILE_ID as URLS_FID, F.FILE_SIZE, F.MIME_TYPE,

U.FILE_NAME, U.FULL_PATH

from

CMS_FILES_INST.XYF_URLS u,

CMS_FILES_INST.XYF_FILES F

WHERE

U.FILE_ID = F.FILE_ID

order by U.FULL_PATH asc

;

 

Within the GUI you can look at links but not to my knowledge against a bulk of courses in one go.  The basis for this request is to determine linked content, versus non linked content for environment cleanup. 

Any assistance appreciated

 

Joel

Outcomes