Urgent :: How to configure and achieve ForwardByQuery in DCM4CHEE5 similar to available in dcm4chee2.18

[AKS]

Dear Vrinda/Gunter/Anyone else

Please let me know the steps to configure a scheduler for exporting studies to an external entity in DCM4CHEE5 .    It should be based on a database query as was the case in dcm4chee2.18 which had a service called  ForwardByQuery for this purpose.

[Vrinda Nayak]

Hello, I do not have experience working on DCM4CHEE 2.x. In DCM4CHEE 5.x you can configure an Exporter / Export Rule to achieve automatic forwarding from archive to one or more external remote destinations. In Export Rule you can set conditions as required based on any supported DICOM Tags. 

What exactly is your use case requiring export based on DB query which can't be achieved via Export Rule - Conditions?

[Ajay Sabherwal]

Hi 

In dcm4chee2.18 you could write a query to select series which needs to be forwarded .

So we used it effectively to query our HIS to send only the studies which need to be forwarded as documented in HIS and not as per any DICOM Tag. Not all studies are required to be forwarded.   

In DCM4CHEE5, I believe you can only put rules based on DICOM Tags which is not helpful for this scenario.

 Thanks & Regards

 

Ajay K. Sabherwal

--
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/w1yYtb51Da4/unsubscribe.
To unsubscribe from this group and all its topics, send an email to dcm4che+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/dcm4che/9c0c4ec2-b6ea-4db6-81b7-7002a3224aefn%40googlegroups.com.

[Vrinda Nayak]

Can you share a query example of 

> to send only the studies which need to be forwarded as documented in HIS

[Ajay Sabherwal]

This query is the default query in DCM4CHEE 2.x 

SELECT DISTINCT series.series_iuid, series.retrieve_aets, series.pk FROM series INNER JOIN series_req ON series.pk = series_req.series_fk WHERE series.series_status = 0 AND series.ext_retr_aet IS NULL AND series.updated_time < ? ORDER BY series.pk

This query i can join with HIS for my requirement to be fulfilled 

This is the photo of the Bean implemented in DCM4CHEE 2.x

 Thanks & Regards

 

Ajay K. Sabherwal

To view this discussion visit https://groups.google.com/d/msgid/dcm4che/3620d7f4-3175-4b59-8993-48793c788b25n%40googlegroups.com.

[AKS]

Hi Vrinda,

Any update