Hello Marcel,
am from chile, and i have a litle problem with a query/retrieve from efilm.
look, when efilm make a query by modality, ex: CR, the conquest server tellme this:
[OSSIS] UPACS THREAD 10: STARTED AT: Thu Jun 28 17:17:37 2012
[OSSIS] A-ASSOCIATE-RQ Packet Dump
[OSSIS] Calling Application Title : "OSSIS_RX"
[OSSIS] Called Application Title : "OSSIS"
[OSSIS] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 64234
[OSSIS] Number of Proposed Presentation Contexts: 6
[OSSIS] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.3.1" 1
[OSSIS] Presentation Context 1 "1.2.840.10008.5.1.4.1.2.3.2" 1
[OSSIS] Presentation Context 2 "1.2.840.10008.5.1.4.1.2.2.1" 1
[OSSIS] Presentation Context 3 "1.2.840.10008.5.1.4.1.2.2.2" 1
[OSSIS] Presentation Context 4 "1.2.840.10008.5.1.4.1.2.1.1" 1
[OSSIS] Presentation Context 5 "1.2.840.10008.5.1.4.1.2.1.2" 1
[OSSIS] Server Command := 0020
[OSSIS] Message ID := 0003
[OSSIS] (StudyRootQuery) search level: STUDY
[OSSIS] Query On Study
[OSSIS] Queried item 0008 0080 is not in the database
[OSSIS] Queried item 0008 1040 is not in the database
[OSSIS] Issue Query on Columns: DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID
[OSSIS] Values: DICOMStudies.StudyDate >= E'20120628' and DICOMStudies.StudyDate <= '20120628' and (DICOMStudies.StudyModal = E'CR' or DICOMStudies.StudyModal LIKE ''CR\\\\%' or DICOMStudies.StudyModal LIKE '%\\\\'CR\\\\%' or DICOMStudies.StudyModal LIKE '%\\\\'CR')
[OSSIS] Tables: DICOMStudies
[OSSIS] Sorting (DICOMStudies.PatientNam) DoSort := 1
[OSSIS] ***Failed SQLExecDirect : SELECT DISTINCT DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.PatientBir, DICOMStudies.PatientSex, DICOMStudies.StudyInsta, DICOMStudies.StudyID FROM DICOMStudies WHERE DICOMStudies.StudyDate >= E'20120628' and DICOMStudies.StudyDate <= '20120628' and (DICOMStudies.StudyModal = E'CR' or DICOMStudies.StudyModal LIKE ''CR\\\\%' or DICOMStudies.StudyModal LIKE '%\\\\'CR\\\\%' or DICOMStudies.StudyModal LIKE '%\\\\'CR') ORDER BY (DICOMStudies.PatientNam)
[OSSIS] ***Error: 7: 42601: ERROR: error de sintaxis en o cerca de «CR»; Error while executing the query
[OSSIS] ***Error: 7: 42601: ERROR: error de sintaxis en o cerca de «CR»; Error while executing the query
[OSSIS] C-Find (StudyRoot) located 0 records
[OSSIS] UPACS THREAD 10: ENDED AT: Thu Jun 28 17:17:37 2012
[OSSIS] UPACS THREAD 10: TOTAL RUNNING TIME: 0 SECONDS
may you help me please.
PD: with 1.4.15 version not happend. sorry for my english, is very basic.