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

Quote from marcelvanherk

Hi,

did you re-initialize the worklist database? And is the modality asking for these items?

Marcel

Hi Marcel

yes, i was re-initialize the worklist database.

modality asking for these items? no. But if modality get worklist, 3 dicom above, cannot be filled

Quote from marcelvanherk

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

Quote from marcelvanherk

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