Deleted Discussions, Part III

Blackboard gave me some SQL to look at the XYTHOS bits.


USE CMS_DOC;
SELECT xu.FILE_ID, xu.FULL_PATH, xb.STORAGE_FILENAME
FROM XYF_URLS xu, XYF_FILES xf, XYF_FILE_VERSIONS xv, XYF_BLOBS xb
WHERE xu.FULL_PATH like '%FILENAME.JPG'
AND xu.FILE_ID = xf.FILE_ID
AND xf.FILE_ID = xv.FILE_ID
AND xf.LATEST_VERSION = xv.VERSION
AND xv.BLOB_ID = xb.BLOB_ID;


And you get something like

FILE_ID	FULL_PATH	STORAGE_FILENAME
18804	/internal/courses/.../FILENAME.JPG	/2011/2011-04/2011-04-13/6801/7901.6

and THAT's where your file is.