burkybang
02/08/2022, 6:45 PMRichard Tanner
02/08/2022, 7:36 PMselect
f.id,
f.name,
fo.appfolder,
replace(fo.appfolder,' : ','/')||'/'||f.name as path
from
File f
join MediaItemFolder fo on fo.id = f.folder
where
replace(fo.appfolder,' : ','/')||'/'||f.name=<PATH TO LOOKUP>
burkybang
02/08/2022, 7:38 PMRichard Tanner
02/08/2022, 7:38 PMburkybang
02/08/2022, 7:39 PMburkybang
02/08/2022, 7:43 PM