Query the Dcm4Chee database for Study Storage location.

[Rady]

Hello, 

Please help me with an Idea to query the exact Study Storage location from the Dcm4Chee database based on StudyInstanceUId. I would like to use for an application to extract a data and avoid the overhead of a DICOM Q/R which to me is inducing quite a bit of delay in my cloud storage process. 

with regards

Rady

[BRIT]

Rady,

You can't guarantee that the instances are all in the same place but here's the pseudo (SQL) code that you'll need.  It's very rough and should use inner joins to make the statement more rugged, but...

select filepath from files where instance_fk in (

  select pk from instance where series_fk in (

    select pk from series where study_fk in (

      select pk from study where study_iuid = '1.2.3.4.5.6.7.8.9.0'

      )

    )

  )

This assumes that there's a single file-system configured on your DCM4CHEE server.  Alternatively, you'll need to pick up the filesystem_fk from the files folder for each instance to ensure that you're starting off in the right folder.

[Ravindran Padmanabhan]

Thanks a lot BRIT, i will try and post here my SP to fetch the File path for all the images in the study or series. 

regards

Rady

Rady (Ravindran Padmanabhan)

CTO of Innowave Healthcare

Mob    : +919790974930

e-mail : ra...@innowave.in

Skype : radyworks

--
You received this message because you are subscribed to a topic in the Google Groups "dcm4che" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/dcm4che/OGn02guIj1E/unsubscribe.
To unsubscribe from this group and all its topics, send an email to dcm4che+u...@googlegroups.com.
To post to this group, send email to dcm...@googlegroups.com.
Visit this group at http://groups.google.com/group/dcm4che.
For more options, visit https://groups.google.com/groups/opt_out.