Query worklist items from Conquest Pacs by fluorograph

  • Good day!

    We installed in hospital digital fluorograph.

    So, application of fluorograph sends requests worklist to Conquest, but records doesn't appear in application. In Conquest i have the next log:

    [CONQUESTSRV1] Coding sequence (0040,4018), level=1

    [CONQUESTSRV1] (sequence is empty)

    [CONQUESTSRV1] Coding sequence (0040,4025), level=1

    [CONQUESTSRV1] (sequence is empty)

    [CONQUESTSRV1] Coding sequence (0040,4026), level=1

    [CONQUESTSRV1] (sequence is empty)

    [CONQUESTSRV1] Coding sequence (0040,4027), level=1

    [CONQUESTSRV1] (sequence is empty)

    [CONQUESTSRV1] Coding sequence (0040,4034), level=1

    [CONQUESTSRV1] Coding sequence (0040,4009), level=2

    [CONQUESTSRV1] (sequence is empty)

    [CONQUESTSRV1] Records = 4

    [CONQUESTSRV1] C-Find (Modality Work List) located 4 records

    [CONQUESTSRV1] UPACS THREAD 19: ENDED AT: Mon Nov 11 16:00:59 2019

    [CONQUESTSRV1] UPACS THREAD 19: TOTAL RUNNING TIME: 0 SECONDS

    [CONQUESTSRV1]

    [CONQUESTSRV1] UPACS THREAD 20: STARTED AT: Mon Nov 11 16:01:14 2019

    [CONQUESTSRV1] A-ASSOCIATE-RQ Packet Dump

    [CONQUESTSRV1] Calling Application Title : "PROSCAN "

    [CONQUESTSRV1] Called Application Title : "CONQUESTSRV1 "

    [CONQUESTSRV1] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 16384

    [CONQUESTSRV1] Number of Proposed Presentation Contexts: 1

    [CONQUESTSRV1] Presentation Context 0 "1.2.840.10008.5.1.4.31" 1

    [CONQUESTSRV1] Server Command := 0020

    [CONQUESTSRV1] Message ID := 0001

    [CONQUESTSRV1] (ModalityWorkListQuery) search level:

    [CONQUESTSRV1] Query On Modality WorkList

    [CONQUESTSRV1] Queried item 0008 0005 is not in the database

    [CONQUESTSRV1] Queried item 0008 0016 is not in the database

    [CONQUESTSRV1] Queried item 0008 0018 is not in the database

    [CONQUESTSRV1] Queried item 0008 1111 is not in the database

    [CONQUESTSRV1] Queried item 0010 1000 is not in the database

    [CONQUESTSRV1] Queried item 0010 4000 is not in the database

    [CONQUESTSRV1] Queried item 0029 0001 is not in the database

    [CONQUESTSRV1] Queried item 0008 0100 is not in the database

    [CONQUESTSRV1] Queried item 0008 0102 is not in the database

    [CONQUESTSRV1] Queried item 0008 0104 is not in the database

    [CONQUESTSRV1] Queried item 0038 0050 is not in the database

    [CONQUESTSRV1] Queried item 0038 0500 is not in the database

    [CONQUESTSRV1] Queried item 0040 4004 is not in the database

    [CONQUESTSRV1] Queried item 0040 4005 is not in the database

    [CONQUESTSRV1] Queried item 0040 4006 is not in the database

    [CONQUESTSRV1] Queried item 0040 4011 is not in the database

    [CONQUESTSRV1] Queried item 0040 4015 is not in the database

    [CONQUESTSRV1] Queried item 0008 0100 is not in the database

    [CONQUESTSRV1] Queried item 0008 0102 is not in the database

    [CONQUESTSRV1] Queried item 0040 4021 is not in the database

    [CONQUESTSRV1] Queried item 0040 4022 is not in the database

    [CONQUESTSRV1] Queried item 0008 0100 is not in the database

    [CONQUESTSRV1] Queried item 0008 0102 is not in the database

    [CONQUESTSRV1] Queried item 0008 0100 is not in the database

    [CONQUESTSRV1] Queried item 0008 0102 is not in the database

    [CONQUESTSRV1] Queried item 0008 0100 is not in the database

    [CONQUESTSRV1] Queried item 0008 0102 is not in the database

    [CONQUESTSRV1] Queried item 0008 0100 is not in the database

    [CONQUESTSRV1] Queried item 0008 0102 is not in the database

    [CONQUESTSRV1] Queried item 0040 4035 is not in the database

    [CONQUESTSRV1] Queried item 0040 a370 is not in the database

    [CONQUESTSRV1] Issue Query on Columns: DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.MedicalAle, DICOMWorkList.ContrastAl, DICOMWorkList.StudyInsta, DICOMWorkList.ReqProcID

    [CONQUESTSRV1] Values:

    [CONQUESTSRV1] Tables: DICOMWorkList

    [CONQUESTSRV1] Sorting (DICOMWorkList.PatientNam) DoSort := 1

    [CONQUESTSRV1] Coding sequence (0032,1064), level=1

    [CONQUESTSRV1] (sequence is empty)

    [CONQUESTSRV1] Coding sequence (0040,4018), level=1

    [CONQUESTSRV1] (sequence is empty)

    [CONQUESTSRV1] Coding sequence (0040,4025), level=1

    [CONQUESTSRV1] (sequence is empty)

    [CONQUESTSRV1] Coding sequence (0040,4026), level=1

    [CONQUESTSRV1] (sequence is empty)

    [CONQUESTSRV1] Coding sequence (0040,4027), level=1

    [CONQUESTSRV1] (sequence is empty)

    [CONQUESTSRV1] Coding sequence (0040,4034), level=1

    [CONQUESTSRV1] Coding sequence (0040,4009), level=2

    [CONQUESTSRV1] (sequence is empty)

    [CONQUESTSRV1] Records = 4

    [CONQUESTSRV1] C-Find (Modality Work List) located 4 records

    [CONQUESTSRV1] UPACS THREAD 20: ENDED AT: Mon Nov 11 16:01:14 2019

    [CONQUESTSRV1] UPACS THREAD 20: TOTAL RUNNING TIME: 0 SECONDS


    It means that in Conquest database SQl not enough fields for correct answer? Is it right? How i can decide this problem?

  • Thank you for answer, Marcel!

    StudyInstanceUID provided.

    Read many forums: problem in program of scanner (i guess this internal additional filter on worklist items). I will connect to developers this program.

  • Good day, Marcel! I'm not sure, but possible i found some bug.

    This my Worklist Structure in dicom.sql dicomsql.zip

    Here conquest debug log with responce for workListquery: dicomdebuglog.txt

    You can see, that:

    Coding sequence (0040,0008), level=2

    [CONQUESTSRV1] >0008,0100 8 SH CodeValue "ST-0017 "

    [CONQUESTSRV1] >0008,0102 6 SH CodingSchemeDesignat "XPROM "

    [CONQUESTSRV1] >0008,0104 8 LO CodeMeaning "Fluorogr"

    AND

    [CONQUESTSRV1] Coding sequence (0032,1064), level=1

    [CONQUESTSRV1] 0008,0100 8 SH CodeValue "ST-0017 "

    [CONQUESTSRV1] 0008,0102 6 SH CodingSchemeDesignat "XPROM "

    [CONQUESTSRV1] 0008,0104 8 LO CodeMeaning "Fluorogr"


    have similar values, but in sql database fields for this tags have different values.

    So value dicom-tag (0032,1064)/(0008,0100) rewrite value in dicom-tag (0040,0100)/(0040,0008)/(0008,0100), when Conquest generate worklist response.

    May be i have mistake in dicom.sql? Can you explain me, please?

  • Hi,


    it is not a bug, it is a limitation ;->. The SQL database does not support levels, so it cannot differentiate the two items. The ENDSEQUENCE and STARTSEQUENCE items in dicom.sql are just there as 'comments'. They are currently ignored.


    So unfortunately have more than one items like CodeValu in the database. It is a very major change to fix this.


    Marcel

Participate now!

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