Friday, September 7, 2012

Another SQL query for dcm4chee

Like a previous one, useful to discover files with full path owned by a study.
SIUID = study instance uid

SELECT concat(filesystem.dirpath,'/', files.filepath)
FROM series
JOIN study ON series.study_fk =
JOIN patient ON study.patient_fk =
JOIN instance ON instance.series_fk =
JOIN files ON = files.instance_fk
JOIN filesystem ON files.filesystem_fk =
WHERE study.study_iuid = '$SIUID';

1 comment: