wildcards and c-find searches

    I found some interesting behavior coming from a GE Workstation when it is searching using blank wildcards and conquest doesn't like it. For some reason there is a space in front of the * which turns into a % in the LIKE search. This causes no records to be found when you put a space in front of at least name field for sure but not sure of patient id field. The code in conquest seems to remove the space and correctly searches patient id with it taken out when testing with buil-in query. With built in query when you put a space and then H* (last name) to cause this to happen it doesn't find records for patient name. It's reproducible. Is this an scu issue or something the scp should handle properly?




    [CONQUEST] A-ASSOCIATE-RQ Packet Dump
    [CONQUEST] Calling Application Title : "calling "
    [CONQUEST] Called Application Title : "called "
    [CONQUEST] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 28672
    [CONQUEST] Number of Proposed Presentation Contexts: 1
    [CONQUEST] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.2.1" 1
    [CONQUEST] Server Command := 0020
    [CONQUEST] Message ID := 0003
    [CONQUEST] (StudyRootQuery) search level: STUDY
    [CONQUEST] Query On Study
    [CONQUEST] Issue Query on Columns: DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.StudyInsta, DICOMStudies.StudyID
    [CONQUEST] Values: DICOMStudies.StudyDate >= '20110422' and DICOMStudies.StudyDate <= '20110422' and DICOMStudies.StudyTime >= '000000' and DICOMStudies.StudyTime <= '235959' and DICOMStudies.PatientNam LIKE ' %' and DICOMStudies.PatientID LIKE ' %'
    [CONQUEST] Tables: DICOMStudies
    [CONQUEST] Sorting (DICOMStudies.PatientNam) DoSort := 1
    [CONQUEST] Records = 0
    [CONQUEST] C-Find (StudyRoot) located 0 records
    [CONQUEST] UPACS THREAD 188: ENDED AT: Fri Apr 22 15:37:16 2011
    [CONQUEST] UPACS THREAD 188: TOTAL RUNNING TIME: 0 SECONDS
    [CONQUEST]
    [CONQUEST] UPACS THREAD 191: STARTED AT: Fri Apr 22 15:38:06 2011
    [CONQUEST] A-ASSOCIATE-RQ Packet Dump
    [CONQUEST] Calling Application Title : "calling "
    [CONQUEST] Called Application Title : "called "
    [CONQUEST] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 28672
    [CONQUEST] Number of Proposed Presentation Contexts: 1
    [CONQUEST] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.2.1" 1
    [CONQUEST] Server Command := 0020
    [CONQUEST] Message ID := 0005
    [CONQUEST] (StudyRootQuery) search level: STUDY
    [CONQUEST] Query On Study
    [CONQUEST] Issue Query on Columns: DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.StudyInsta, DICOMStudies.StudyID
    [CONQUEST] Values: DICOMStudies.PatientNam LIKE ' %' and DICOMStudies.PatientID LIKE ' %'
    [CONQUEST] Tables: DICOMStudies
    [CONQUEST] Sorting (DICOMStudies.PatientNam) DoSort := 1
    [CONQUEST] Records = 0
    [CONQUEST] C-Find (StudyRoot) located 0 records
    [CONQUEST] UPACS THREAD 191: ENDED AT: Fri Apr 22 15:38:06 2011
    [CONQUEST] UPACS THREAD 191: TOTAL RUNNING TIME: 0 SECONDS
    [CONQUEST]
    [CONQUEST] UPACS THREAD 192: STARTED AT: Fri Apr 22 15:38:35 2011
    [CONQUEST] A-ASSOCIATE-RQ Packet Dump
    [CONQUEST] Calling Application Title : "caling "
    [CONQUEST] Called Application Title : "called "
    [CONQUEST] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 28672
    [CONQUEST] Number of Proposed Presentation Contexts: 1
    [CONQUEST] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.2.1" 1
    [CONQUEST] Server Command := 0020
    [CONQUEST] Message ID := 0006
    [CONQUEST] (StudyRootQuery) search level: STUDY
    [CONQUEST] Query On Study
    [CONQUEST] Issue Query on Columns: DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.StudyInsta, DICOMStudies.StudyID
    [CONQUEST] Values: DICOMStudies.PatientID LIKE '1234-56%'
    [CONQUEST] Tables: DICOMStudies
    [CONQUEST] Sorting (DICOMStudies.PatientNam) DoSort := 1
    [CONQUEST] Records = 2
    [CONQUEST] C-Find (StudyRoot) located 2 records
    [CONQUEST] UPACS THREAD 192: ENDED AT: Fri Apr 22 15:38:35 2011
    [CONQUEST] UPACS THREAD 192: TOTAL RUNNING TIME: 0 SECONDS

    Hi,


    I think GE got it wrong, it should have sent '* ' instead of ' *' to make the field even length. But I can get conquest to handle ' *' correctly. Are there other cases e.g., ab* that would cause a leading space?


    Marcel

    I found a query that was done below that seems to do the same.



    4/22/2011 2:27:16 PM [CONQUEST] UPACS THREAD 235: STARTED AT: Fri Apr 22 14:27:15 2011
    4/22/2011 2:27:16 PM [CONQUEST] A-ASSOCIATE-RQ Packet Dump
    4/22/2011 2:27:16 PM [CONQUEST] Calling Application Title : "CALLING "
    4/22/2011 2:27:16 PM [CONQUEST] Called Application Title : "CONQUEST "
    4/22/2011 2:27:16 PM [CONQUEST] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 28672
    4/22/2011 2:27:16 PM [CONQUEST] Number of Proposed Presentation Contexts: 1
    4/22/2011 2:27:16 PM [CONQUEST] Presentation Context 0 "1.2.840.10008.5.1.4.1.2.2.1" 1
    4/22/2011 2:27:16 PM [CONQUEST] Server Command := 0020
    4/22/2011 2:27:16 PM [CONQUEST] Message ID := 001e
    4/22/2011 2:27:16 PM [CONQUEST] (StudyRootQuery) search level: STUDY
    4/22/2011 2:27:16 PM [CONQUEST] Query On Study
    4/22/2011 2:27:16 PM [CONQUEST] Issue Query on Columns: DICOMStudies.StudyDate, DICOMStudies.StudyTime, DICOMStudies.AccessionN, DICOMStudies.StudyModal, DICOMStudies.ReferPhysi, DICOMStudies.StudyDescr, DICOMStudies.PatientNam, DICOMStudies.PatientID, DICOMStudies.StudyInsta, DICOMStudies.StudyID
    4/22/2011 2:27:16 PM [CONQUEST] Values: DICOMStudies.StudyDate >= '20110422' and DICOMStudies.StudyDate <= '20110422' and DICOMStudies.StudyTime >= '000000' and DICOMStudies.StudyTime <= '235959' and DICOMStudies.PatientNam LIKE ' D%' and DICOMStudies.PatientID LIKE ' %'
    4/22/2011 2:27:16 PM [CONQUEST] Tables: DICOMStudies
    4/22/2011 2:27:16 PM [CONQUEST] Sorting (DICOMStudies.PatientNam) DoSort := 1
    4/22/2011 2:27:16 PM [CONQUEST] Records = 0
    4/22/2011 2:27:16 PM [CONQUEST] C-Find (StudyRoot) located 0 records
    4/22/2011 2:27:16 PM [CONQUEST] UPACS THREAD 235: ENDED AT: Fri Apr 22 14:27:16 2011
    4/22/2011 2:27:16 PM [CONQUEST] UPACS THREAD 235: TOTAL RUNNING TIME: 1 SECONDS

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login