how add dicom tag in table dicomworklist

  • Hi marcell


    how add dicom tag in table dicomworklist?

    we add in dicom.sql

    { 0x0008, 0x0090, "ReferringPhysician", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0008, 0x1060, "ReadingPhysician", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0008, 0x1070, "Operator", 64, SQL_C_CHAR, DT_STR, "---" },


    but in server status, modalati can't get.


    [DICOMSERVER] 0010,0010 4 PN PatientName "TEST"

    [DICOMSERVER] 0010,0020 4 LO PatientID "212 "

    [DICOMSERVER] 0010,0030 8 DA PatientBirthDate "19800323"

    [DICOMSERVER] 0010,0040 2 CS PatientSex "F "

    [DICOMSERVER] 0010,2000 0 LO MedicalAlerts (empty)

    [DICOMSERVER] 0010,2110 0 LO Allergies (empty)

    [DICOMSERVER] 0020,000d 14 UI StudyInstanceUID "1.2.1234.56789"

    [DICOMSERVER] 0032,1032 0 PN RequestingPhysician (empty)

    [DICOMSERVER] 0032,1060 0 LO RequestedProcedureDe (empty)

    [DICOMSERVER] 0032,1070 0 LO RequestedContrastAge (empty)

    [DICOMSERVER] Coding sequence (0040,0100), level=1

    [DICOMSERVER] 0008,0060 2 CS Modality "MR"

    [DICOMSERVER] 0040,0001 0 AE ScheduledStationAETi (empty)

    [DICOMSERVER] 0040,0002 8 DA ScheduledProcedureSt "20190730"

    [DICOMSERVER] 0040,0003 6 TM ScheduledProcedureSt "120000"

    [DICOMSERVER] 0040,0006 0 PN ScheduledPerformingP (empty)

    [DICOMSERVER] 0040,0007 0 LO ScheduledProcedureSt (empty)

    [DICOMSERVER] Coding sequence (0040,0008), level=2

    [DICOMSERVER] (sequence is empty)

    [DICOMSERVER] 0040,0009 0 SH ScheduledProcedureSt (empty)

    [DICOMSERVER] 0040,0012 0 LO PreMedication (empty)

    [DICOMSERVER] 0040,1001 0 SH RequestedProcedureID (empty)

    [DICOMSERVER] Records = 1

    [DICOMSERVER] C-Find (Modality Work List) located 1 records


    regards

    Rudiansyah

  • Hi,


    can you look the conquest log in debug mode? It lists what items are queried and the reply.


    Marcel

    Hi Marcel


    server status


    [DICOMSERVER] UPACS THREAD 56: STARTED AT: Wed Jul 31 01:35:02 2019

    [DICOMSERVER] A-ASSOCIATE-RQ Packet Dump

    [DICOMSERVER] Calling Application Title : "GEHC "

    [DICOMSERVER] Called Application Title : "DICOMSERVER "

    [DICOMSERVER] Application Context : "1.2.840.10008.3.1.1.1", PDU length: 16352

    [DICOMSERVER] Number of Proposed Presentation Contexts: 1

    [DICOMSERVER] Presentation Context 0 "1.2.840.10008.5.1.4.31" 1

    [DICOMSERVER] Server Command := 0020

    [DICOMSERVER] Message ID := 0033

    [DICOMSERVER] 0000,0002 22 UI AffectedSOPClassUID "1.2.840.10008.5.1.4.31"

    [DICOMSERVER] 0000,0100 2 US CommandField 32

    [DICOMSERVER] 0000,0110 2 US MessageID 51

    [DICOMSERVER] 0000,0700 2 US Priority 0

    [DICOMSERVER] 0000,0800 2 US DataSetType 0

    [DICOMSERVER] 0002,0010 19 UI TransferSyntaxUID "1.2.840.10008.1.2.2"

    [DICOMSERVER] (ModalityWorkListQuery) search level:

    [DICOMSERVER] Query On Modality WorkList

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

    [DICOMSERVER] Queried item 0008 0020 is not in the database

    [DICOMSERVER] Queried item 0008 0030 is not in the database

    [DICOMSERVER] Queried item 0008 0090 is not in the database

    [DICOMSERVER] Queried item 0008 1030 is not in the database

    [DICOMSERVER] Queried item 0008 1060 is not in the database

    [DICOMSERVER] Queried item 0008 1070 is not in the database

    [DICOMSERVER] Queried item 0008 1150 is not in the database

    [DICOMSERVER] Queried item 0008 1155 is not in the database

    [DICOMSERVER] Queried item 0008 1150 is not in the database

    [DICOMSERVER] Queried item 0008 1155 is not in the database

    [DICOMSERVER] Queried item 0010 0021 is not in the database

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

    [DICOMSERVER] Queried item 0010 1010 is not in the database

    [DICOMSERVER] Queried item 0010 1020 is not in the database

    [DICOMSERVER] Queried item 0010 1030 is not in the database

    [DICOMSERVER] Queried item 0010 21b0 is not in the database

    [DICOMSERVER] Queried item 0010 21c0 is not in the database

    [DICOMSERVER] Queried item 0032 1064 is not in the database

    [DICOMSERVER] Queried item 0038 0010 is not in the database

    [DICOMSERVER] Queried item 0038 0011 is not in the database

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

    [DICOMSERVER] Queried item 0038 0300 is not in the database

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

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

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

    [DICOMSERVER] Queried item 0008 0103 is not in the database

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

    [DICOMSERVER] Queried item 0040 0020 is not in the database

    [DICOMSERVER] Queried item 0040 3001 is not in the database

    [DICOMSERVER] Queried item 0040 2016 is not in the database

    [DICOMSERVER] Queried item 0040 2017 is not in the database

    [DICOMSERVER] Issue Query on Columns: DICOMWorkList.AccessionN, DICOMWorkList.PatientNam, DICOMWorkList.PatientID, DICOMWorkList.PatientBir, DICOMWorkList.PatientSex, DICOMWorkList.MedicalAle, DICOMWorkList.ContrastAl, DICOMWorkList.StudyInsta, DICOMWorkList.ReqPhysici, DICOMWorkList.ReqProcDes, DICOMWorkList.ReqContras, DICOMWorkList.Modality, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.PreMedicat, DICOMWorkList.ReqProcID

    [DICOMSERVER] Values: DICOMWorkList.Modality = E'MR' and DICOMWorkList.StartDate = E'20190730'

    [DICOMSERVER] Tables: DICOMWorkList

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

    [DICOMSERVER] 0008,0050 6 SH AccessionNumber "111111"

    [DICOMSERVER] Coding sequence (0008,1110), level=1

    [DICOMSERVER] (sequence is empty)

    [DICOMSERVER] Coding sequence (0008,1120), level=1

    [DICOMSERVER] (sequence is empty)

    [DICOMSERVER] 0010,0010 6 PN PatientName "TEST, "

    [DICOMSERVER] 0010,0020 6 LO PatientID "222222"

    [DICOMSERVER] 0010,0030 8 DA PatientBirthDate "19781229"

    [DICOMSERVER] 0010,0040 2 CS PatientSex "M "

    [DICOMSERVER] 0010,2000 0 LO MedicalAlerts (empty)

    [DICOMSERVER] 0010,2110 0 LO Allergies (empty)

    [DICOMSERVER] 0020,000d 18 UI StudyInstanceUID "1.2.3.4.123456789"

    [DICOMSERVER] 0032,1032 8 PN RequestingPhysician "CEMPAKA "

    [DICOMSERVER] 0032,1060 10 LO RequestedProcedureDe "MRI THORAX"

    [DICOMSERVER] 0032,1070 0 LO RequestedContrastAge (empty)

    [DICOMSERVER] Coding sequence (0040,0100), level=1

    [DICOMSERVER] 0008,0060 2 CS Modality "MR"

    [DICOMSERVER] 0040,0001 0 AE ScheduledStationAETi (empty)

    [DICOMSERVER] 0040,0002 8 DA ScheduledProcedureSt "20190730"

    [DICOMSERVER] 0040,0003 6 TM ScheduledProcedureSt "120000"

    [DICOMSERVER] 0040,0006 0 PN ScheduledPerformingP (empty)

    [DICOMSERVER] 0040,0007 10 LO ScheduledProcedureSt "MRI THORAX"

    [DICOMSERVER] Coding sequence (0040,0008), level=2

    [DICOMSERVER] (sequence is empty)

    [DICOMSERVER] 0040,0009 0 SH ScheduledProcedureSt (empty)

    [DICOMSERVER] 0040,0012 0 LO PreMedication (empty)

    [DICOMSERVER] 0040,1001 0 SH RequestedProcedureID (empty)

    [DICOMSERVER] Records = 1

    [DICOMSERVER] C-Find (Modality Work List) located 1 records

    [DICOMSERVER] UPACS THREAD 56: ENDED AT: Wed Jul 31 01:35:02 2019

    [DICOMSERVER] UPACS THREAD 56: TOTAL RUNNING TIME: 0 SECONDS



    Regards

    Rudiansyah

  • Hi,


    apparently you have a syntax error in dicom.sql; Can you post 'show database layout' and you whole dicom.sql.


    Marcel

    Hi Marcel



    *WorkList*

    {

    { 0x0008, 0x0050, "AccessionNumber", 16, SQL_C_CHAR, DT_STR, "OBR.3" },

    { 0x0010, 0x0020, "PatientID", 64, SQL_C_CHAR, DT_STR, "PID.4" },

    { 0x0010, 0x0010, "PatientName", 64, SQL_C_CHAR, DT_STR, "PID.5" },

    { 0x0010, 0x0030, "PatientBirthDate", 8, SQL_C_DATE, DT_DATE, "PID.7" },

    { 0x0010, 0x0040, "PatientSex", 16, SQL_C_CHAR, DT_STR, "PID.8" },


    { 0x0010, 0x2000, "MedicalAlerts", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0010, 0x2110, "ContrastAllergies", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0020, 0x000d, "StudyInstanceUID", 64, SQL_C_CHAR, DT_UI, "---" },

    { 0x0032, 0x1032, "ReqPhysician", 64, SQL_C_CHAR, DT_STR, "OBR.16" },

    { 0x0032, 0x1060, "ReqProcDescription", 64, SQL_C_CHAR, DT_STR, "OBR.4.1" },


    { 0x0008, 0x0090, "ReferringPhysician", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0008, 0x1060, "ReadingPhysician", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0008, 0x1070, "Operator", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0008, 0x1040, "DepartmentName", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0040, 0x0100, "--------", 0, SQL_C_CHAR, DT_STARTSEQUENCE, "---" },

    { 0x0008, 0x0060, "Modality", 16, SQL_C_CHAR, DT_STR, "OBR.21" },

    { 0x0032, 0x1070, "ReqContrastAgent", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0040, 0x0001, "ScheduledAE", 16, SQL_C_CHAR, DT_STR, "---" },

    { 0x0040, 0x0002, "StartDate", 8, SQL_C_DATE, DT_DATE, "OBR.7.DATE" },

    { 0x0040, 0x0003, "StartTime", 16, SQL_C_CHAR, DT_TIME, "OBR.7.TIME" },

    { 0x0040, 0x0006, "PerfPhysician", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0040, 0x0007, "SchedPSDescription", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0040, 0x0009, "SchedPSID", 16, SQL_C_CHAR, DT_STR, "OBR.4" },

    { 0x0040, 0x0010, "SchedStationName", 16, SQL_C_CHAR, DT_STR, "OBR.24" },

    { 0x0040, 0x0011, "SchedPSLocation", 16, SQL_C_CHAR, DT_STR, "---" },

    { 0x0040, 0x0012, "PreMedication", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0040, 0x0400, "SchedPSComments", 64, SQL_C_CHAR, DT_STR, "---" },

    { 0x0040, 0x0100, "---------", 0, SQL_C_CHAR, DT_ENDSEQUENCE, "---" },


    { 0x0040, 0x1001, "ReqProcID", 16, SQL_C_CHAR, DT_STR, "OBR.4.0" },

    { 0x0040, 0x1003, "ReqProcPriority", 16, SQL_C_CHAR, DT_STR, "OBR.27" }

    }




    Rudiansyah

  • Hi,


    syntax seems correct, yet your log shows:


    [DICOMSERVER] Queried item 0008 0090 is not in the database[DICOMSERVER] Queried item 0008 1060 is not in the database

    [DICOMSERVER] Queried item 0008 1070 is not in the database


    So it was not accepted by the server. Did you push 'clear worklist database'?


    Marcel

    Marcel van Herk is developer of the Conquest DICOM server together with Lambert Zijp.