Hi,
Im trying to filter an export converter to send studies within the past 190 days and with the series description of 5.0 with the following dicom.ini exportconverter delow
ExportConverter1 = forward patient now -190 seriesdesc 5.0 to CTPACS
the header of 1 images in the series is as follows
(0010,0020) LO [74396 ] # 6 PatientID
(0008,103e) LO [Thorax IV 5.0 B31f RECIST] # 26 SeriesDescription
I'm getting this error
[CT_SRV1] MyPatientRootRetrieveGeneric :: SearchOn
[CT_SRV1] 0008,0052 8 CS QueryRetrieveLevel "PATIENT "
[CT_SRV1] 0008,103e 4 LO SeriesDescription ""
[CT_SRV1] 0010,0020 6 LO PatientID "74396 "
[CT_SRV1] Query On Image
[CT_SRV1] Issue Query on Columns: DICOMImages.SOPClassUI, DICOMImages.SOPInstanc, DICOMSeries.SeriesDesc, DICOMSeries.SeriesInst, DICOMStudies.PatientID, DICOMStudies.StudyInsta,DICOMImages.ObjectFile,DICOMImages.DeviceName
[CT_SRV1] Values: DICOMSeries.SeriesDesc = and DICOMStudies.PatientID = '74396' and DICOMSeries.StudyInsta = DICOMStudies.StudyInsta and DICOMImages.SeriesInst = DICOMSeries.SeriesInst
[CT_SRV1] Tables: DICOMImages, DICOMSeries, DICOMStudies
[CT_SRV1] ***Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and DICOMStudies.PatientID = '74396' and DICOMSeries.StudyInsta = DICOMStudies.S' at line 1
[CT_SRV1] Retrieve: move search failed
[CT_SRV1] ***preretrieve/forward xxx to: remote DICOM error
[CT_SRV1] C-Move (PatientRoot)
[CT_SRV1] UPACS THREAD 13: ENDED AT: Tue Aug 10 17:41:04 2010
[CT_SRV1] UPACS THREAD 13: TOTAL RUNNING TIME: 0 SECONDS
My question is
1. is my use of seriesdesc filter correct as i intended which is to send only series having the "5.0" within its expresssion or will it check the exact word for word description?
2. The debug says my SeriesDescription is "" ? is this a bug?
If I remove the seriesdesc is the exportconverter its works as intended (the studies from the last 190 days), however it sends all the series within each study and i only need those with 5.0mm thickness
thanks advance for any advice.
ajgg