Worklist Problem

  • Hello, I have been studying and working a lot with conquest in the last 3 months and we have made good progress by making a Worklist that sends different data to different devices, of which we have:


    - 3 Ultrasound (US)

    - 2 X-Ray (DX)

    - 1 Mastyography (MG)

    - 1 Magnetic Resonance (RM)

    - 1 Panoramic Dental (CR)

    - 1 Tomography (CT)

    - 1 Fluoroscopy (XA)


    Most devices are receiving the Worklist data well. Except for the fluoroscopy device and the tomography device. And to be honest I don't know how to solve the problem with those 2 devices.


    To make the Worklist data, I use insert in through MySQL Worklist Table. Since the clinical system is the way in which I can send the information to Conquest. I Want to share the data that Works in

    each case of the modalities that I mention.


    AccessionN

    AccessTime

    ContrastAl

    MedicalAle

    Modality

    PatientBir

    PatientID

    PatientNam

    PatientSex

    PerfPhysic

    PreMedicat

    qFlags

    qSpare

    qTimeStamp

    ReqContras

    ReqPhysici

    ReqProcDes

    ReqProcID

    ReqProcPri

    SchedPSCom

    SchedPSDes

    SchedPSID

    SchedPSLoc

    SchedStati

    ScheduledA

    StartDate

    StartTime

    StudyInsta

    3301




    US

    19470824

    034935c02

    Patien Name

    F

    CORTES^OSCAR






    CORTES^OSCAR

    SONOGRAFIA ABDOMINAL (SUPERIOR)









    20200711

    091500


    3302




    US

    19470824

    034935c02

    Patien Name

    F

    CORTES^OSCAR






    CORTES^OSCAR

    SONOGRAFIA PELVICA









    20200711

    093000



    This data works in all 3 Ultrasound.


    AccessionN

    AccessTime

    ContrastAl

    MedicalAle

    Modality

    PatientBir

    PatientID

    PatientNam

    PatientSex

    PerfPhysic

    PreMedicat

    qFlags

    qSpare

    qTimeStamp

    ReqContras

    ReqPhysici

    ReqProcDes

    ReqProcID

    ReqProcPri

    SchedPSCom

    SchedPSDes

    SchedPSID

    SchedPSLoc

    SchedStati

    ScheduledA

    StartDate

    StartTime

    StudyInsta

    3327




    DX

    20100804

    103883c06

    Patient Name

    F








    CARA PERFILOGRAMA LATERAL AP









    20200711

    022500



    This data works in all 2 X-Ray.


    AccessionN

    AccessTime

    ContrastAl

    MedicalAle

    Modality

    PatientBir

    PatientID

    PatientNam

    PatientSex

    PerfPhysic

    PreMedicat

    qFlags

    qSpare

    qTimeStamp

    ReqContras

    ReqPhysici

    ReqProcDes

    ReqProcID

    ReqProcPri

    SchedPSCom

    SchedPSDes

    SchedPSID

    SchedPSLoc

    SchedStati

    ScheduledA

    StartDate

    StartTime

    StudyInsta

    5249




    MG

    19530602

    077145c01

    CARRILLO VELASCO^LEONOR

    F

    CHIQUITO^MYRNA CECILIA






    CHIQUITO^MYRNA CECILIA

    MAMOGRAFIA CON SONOGRAFIA









    20200731

    094500



    This Works on the Mastyography


    AccessionN

    AccessTime

    ContrastAl

    MedicalAle

    Modality

    PatientBir

    PatientID

    PatientNam

    PatientSex

    PerfPhysic

    PreMedicat

    qFlags

    qSpare

    qTimeStamp

    ReqContras

    ReqPhysici

    ReqProcDes

    ReqProcID

    ReqProcPri

    SchedPSCom

    SchedPSDes

    SchedPSID

    SchedPSLoc

    SchedStati

    ScheduledA

    StartDate

    StartTime

    StudyInsta

    3297




    MR

    19570128

    024416c01

    SAENZ DOMINGUEZ^JULIETA MARIA

    F

    DIAZ^BLANCA ESTHELA






    DIAZ^BLANCA ESTHELA

    RESONANCIA DE COLUMNA LUMBAR








    WL

    20200711

    100200



    This Works on the Magnetic Resonance


    AccessionN

    AccessTime

    ContrastAl

    MedicalAle

    Modality

    PatientBir

    PatientID

    PatientNam

    PatientSex

    PerfPhysic

    PreMedicat

    qFlags

    qSpare

    qTimeStamp

    ReqContras

    ReqPhysici

    ReqProcDes

    ReqProcID

    ReqProcPri

    SchedPSCom

    SchedPSDes

    SchedPSID

    SchedPSLoc

    SchedStati

    ScheduledA

    StartDate

    StartTime

    StudyInsta

    3588




    CR

    19860306

    128871c01

    LEON ADRIANO^CYNTHIA GUADALUPE

    F








    PANORAMICA (ORTHOPANTOGRAFIA)








    WL

    20200714

    052600



    This Works on the Panoramic Dental


    But I cannot make the information visible on the tomography and on the fluoroscope.


    On CT I Use this


    AccessionN

    AccessTime

    ContrastAl

    MedicalAle

    Modality

    PatientBir

    PatientID

    PatientNam

    PatientSex

    PerfPhysic

    PreMedicat

    qFlags

    qSpare

    qTimeStamp

    ReqContras

    ReqPhysici

    ReqProcDes

    ReqProcID

    ReqProcPri

    SchedPSCom

    SchedPSDes

    SchedPSID

    SchedPSLoc

    SchedStati

    ScheduledA

    StartDate

    StartTime

    StudyInsta

    3337

    190001



    CT

    19310830

    003120c02

    FIGUEROA BENCOMO^ALICIA

    F





    190001



    ABDOMEN AP DECUBITO (SIMPLE DE ABDOMEN)








    WL

    20200712

    190000




    I have tried to enter different values. But at the moment I put ScheduledA without value, the computer shows a successful connection.


    But when I put the WL value it gives me errors, some saying syntax error and others saying that NULL values are not accepted. Also the same problem on 1 Fluoroscopy (XA)


    This is my Dicom.ini


    # This file contains configuration information for the DICOM server

    # Do not edit unless you know what you are doing


    [sscscp]

    MicroPACS = sscscp


    # Network configuration: server name and TCP/IP port#

    MyACRNema = Wl

    TCPPort = 104


    # Host, database, username and password for database

    SQLHost = localhost

    SQLServer = conquest

    Username = root

    Password = 112233Az@

    MySql = 1

    DoubleBackSlashToDB = 1

    UseEscapeStringConstants = 0


    # Configure server

    ImportExportDragAndDrop = 1

    ZipTime = 05:

    UIDPrefix = 1.2.826.0.1.3680043.2.135.737598.53612758

    EnableComputedFields = 1

    EnableReadAheadThread = 1

    PatientQuerySortOrder =

    StudyQuerySortOrder =

    SeriesQuerySortOrder =

    ImageQuerySortOrder =

    EnableComputedFields = 1

    IndexDBF = 1

    PackDBF = 0

    LongQueryDBF = 1000

    TCPIPTimeOut = 300

    FailHoldOff = 60

    RetryDelay = 100

    RetryForwardFailed = 0

    ImportExportDragAndDrop = 0

    QueueSize = 128

    WorkListMode = 1

    WorkListReturnsISO_IR_100 = 1

    DebugLevel = 5

    Prefetcher = 0

    LRUSort =

    AllowTruncate =

    DecompressNon16BitsJpeg = 1

    UseBuiltInDecompressor = 1

    IgnoreOutOfMemoryErrors = 0

    PadAEWithZeros = 0

    FileNameSyntax = 4


    # Importconverters

    ImportConverters = 1

    ImportConverter0 = ifequal "%u","DCMSND"; compression as


    UTF8ToDB = 1

    UTF8FromDB = 1


    # Configuration of compression for incoming images and archival

    DroppedFileCompression = uj

    IncomingCompression = uj

    ArchiveCompression = as


    # For debug information

    PACSName = WL

    OperatorConsole = 127.0.0.1

    DebugLevel = 5


    # Configuration of disk(s) to store images

    MAGDeviceFullThreshHold = 30

    MAGDevices = 1

    MAGDevice0 = C:\dicomserver\conquestdicomserver\data\


    #LUA

    [lua]

    ModalityWorklistQueryResultConverter0 = Data.StudyInstanceUID = genuid()


    [lua]

    Association=local AE,IP,P,C= get_amap(1); if Association.Caller==AE and Association.ConnectedIP~=IP then servercommand('put_amap:'..AE..','..Association.ConnectedIP..','..P..','..C) end


    [lua]

    ModalityWorkListQueryResultConverter0 = Data.ReferencedStudySequence = nil; Data.ReferencedPatientSequence = nil;


    [lua]

    ModalityWorkListQueryResultConverter0 = Data.ReferencedStudySequence = nil; Data.ReferencedPatientSequence = nil; Data.TransferSyntaxUID = '1.2.840.10008.1.2'


    [lua]

    QueryWorklistConverter0 = Data.ScheduledProcedureStep[1].ScheduledProcedureStepTime = ''


    Could you give me suggestions or recommendations? Thanks to all

  • Belenlller

    Changed the title of the thread from “Worklist Problemas” to “Worklist Problem”.
  • When the fluro asks the Workliste this comes out in the Log


    [WL] UPACS THREAD 303: STARTED AT: Wed Aug 05 11:52:05 2020

    [WL] A-ASSOCIATE-RQ Packet Dump

    [WL] Calling Application Title : "FLURO "

    [WL] Called Application Title : "WL "

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

    [WL] Number of Proposed Presentation Contexts: 1

    [WL] Presentation Context 0 "1.2.840.10008.5.1.4.31" 1

    [WL] Server Command := 0020

    [WL] Message ID := 000f

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

    [WL] 0000,0100 2 US CommandField 32

    [WL] 0000,0110 2 US MessageID 15

    [WL] 0000,0700 2 US Priority 0

    [WL] 0000,0800 2 US DataSetType 258

    [WL] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"

    [WL] (ModalityWorkListQuery) search level:

    [WL] 0002,0010 17 UI TransferSyntaxUID "1.2.840.10008.1.2"

    [WL] 0008,0050 0 SH AccessionNumber (empty)

    [WL] 0008,0090 0 PN ReferringPhysicianNa (empty)

    [WL] 0008,1110 0 SQ ReferencedStudySeque Sequence Item

    [WL] >0008,1150 0 UI ReferencedSOPClassUI (empty)

    [WL] >0008,1155 0 UI ReferencedSOPInstanc (empty)

    [WL] 0008,1120 0 SQ ReferencedPatientSeq Sequence Item

    [WL] >0008,1150 0 UI ReferencedSOPClassUI (empty)

    [WL] >0008,1155 0 UI ReferencedSOPInstanc (empty)

    [WL] 0010,0010 0 PN PatientName (empty)

    [WL] 0010,0020 0 LO PatientID (empty)

    [WL] 0010,0030 0 DA PatientBirthDate (empty)

    [WL] 0010,0040 0 CS PatientSex (empty)

    [WL] 0010,1030 0 DS PatientWeight (empty)

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

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

    [WL] 0010,21c0 0 US PregnancyStatus (empty)

    [WL] 0020,000d 0 UI StudyInstanceUID (empty)

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

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

    [WL] 0032,1064 0 SQ RequestedProcedureCo Sequence Item

    [WL] 0038,0010 0 LO AdmissionID (empty)

    [WL] 0038,0050 0 LO SpecialNeeds (empty)

    [WL] 0038,0300 0 LO CurrentPatientLocati (empty)

    [WL] 0038,0500 0 LO PatientState (empty)

    [WL] 0040,0100 0 SQ ScheduledProcedureSt Sequence Item

    [WL] >0008,0060 0 CS Modality (empty)

    [WL] >0040,0001 6 AE ScheduledStationAETi "FLURO "

    [WL] >0040,0002 18 DA ScheduledProcedureSt "20200805-20200805 "

    [WL] >0040,0003 0 TM ScheduledProcedureSt (empty)

    [WL] >0040,0006 0 PN ScheduledPerformingP (empty)

    [WL] >0040,0007 0 LO ScheduledProcedureSt (empty)

    [WL] >0040,0008 0 SQ ScheduledProtocolCod Sequence Item

    [WL] >0040,0009 0 SH ScheduledProcedureSt (empty)

    [WL] >0040,0010 0 SH ScheduledStationName (empty)

    [WL] >0040,0011 0 SH ScheduledProcedureSt (empty)

    [WL] >0040,0020 0 CS ScheduledProcedureSt (empty)

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

    [WL] 0040,1003 0 SH RequestedProcedurePr (empty)

    [WL] 0040,1004 0 LO PatientTransportArra (empty)

    [WL] 0040,3001 0 LO ConfidentialityConst (empty)

    [WL] Query On Modality WorkList

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

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

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

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

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

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

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

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

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

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

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

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

    [WL] Queried item 0040 0008 is not in the database

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

    [WL] Queried item 0040 1004 is not in the database

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

    [WL] 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.Modality, DICOMWorkList.ScheduledA, DICOMWorkList.StartDate, DICOMWorkList.StartTime, DICOMWorkList.PerfPhysic, DICOMWorkList.SchedPSDes, DICOMWorkList.SchedPSID, DICOMWorkList.SchedStati, DICOMWorkList.SchedPSLoc, DICOMWorkList.ReqProcID, DICOMWorkList.ReqProcPri

    [WL] Values: DICOMWorkList.ScheduledA = 'FLURO' and DICOMWorkList.StartDate >= '20200805' and DICOMWorkList.StartDate <= '20200805'

    [WL] Tables: DICOMWorkList

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

    [WL] 0008,0050 4 SH AccessionNumber "1000"

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

    [WL] (sequence is empty)

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

    [WL] (sequence is empty)

    [WL] 0010,0010 16 PN PatientName "Gustavo^Morales "

    [WL] 0010,0020 10 LO PatientID "000001c01 "

    [WL] 0010,0030 8 DA PatientBirthDate "19840308"

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

    [WL] 0010,2000 2 LO MedicalAlerts "- "

    [WL] 0010,2110 2 LO Allergies "- "

    [WL] 0020,000d 0 UI StudyInstanceUID (empty)

    [WL] 0032,1032 2 PN RequestingPhysician "- "

    [WL] 0032,1060 22 LO RequestedProcedureDe "Fluroscopia Estomacal "

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

    [WL] 0008,0060 2 CS Modality "XA"

    [WL] 0040,0001 6 AE ScheduledStationAETi "FLURO "

    [WL] 0040,0002 8 DA ScheduledProcedureSt "20200805"

    [WL] 0040,0003 6 TM ScheduledProcedureSt "131010"

    [WL] 0040,0006 2 PN ScheduledPerformingP "- "

    [WL] 0040,0007 2 LO ScheduledProcedureSt "- "

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

    [WL] 0040,0010 6 SH ScheduledStationName "FLURO "

    [WL] 0040,0011 6 SH ScheduledProcedureSt "FLURO "

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

    [WL] 0040,1003 0 SH RequestedProcedurePr (empty)

    [WL] Records = 1

    [WL] First record of cleaned response:

    [WL] 0008,0005 10 CS SpecificCharacterSet "ISO_IR 100"

    [WL] 0008,0050 4 SH AccessionNumber "1000"

    [WL] 0008,1110 0 SQ ReferencedStudySeque Sequence Item

    [WL] 0008,1120 0 SQ ReferencedPatientSeq Sequence Item

    [WL] 0010,0010 16 PN PatientName "Gustavo^Morales "

    [WL] 0010,0020 10 LO PatientID "000001c01 "

    [WL] 0010,0030 8 DA PatientBirthDate "19840308"

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

    [WL] 0010,2000 2 LO MedicalAlerts "- "

    [WL] 0010,2110 2 LO Allergies "- "

    [WL] 0020,000d 0 UI StudyInstanceUID (empty)

    [WL] 0032,1032 2 PN RequestingPhysician "- "

    [WL] 0032,1060 22 LO RequestedProcedureDe "Fluroscopia Estomacal "

    [WL] 0040,0100 0 SQ ScheduledProcedureSt Sequence Item

    [WL] >0008,0060 2 CS Modality "XA"

    [WL] >0040,0001 6 AE ScheduledStationAETi "FLURO "

    [WL] >0040,0002 8 DA ScheduledProcedureSt "20200805"

    [WL] >0040,0003 6 TM ScheduledProcedureSt "131010"

    [WL] >0040,0006 2 PN ScheduledPerformingP "- "

    [WL] >0040,0007 2 LO ScheduledProcedureSt "- "

    [WL] >0040,0009 0 SH ScheduledProcedureSt (empty)

    [WL] >0040,0010 6 SH ScheduledStationName "FLURO "

    [WL] >0040,0011 6 SH ScheduledProcedureSt "FLURO "

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

    [WL] 0040,1003 0 SH RequestedProcedurePr (empty)

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

    [WL] UPACS THREAD 303: ENDED AT: Wed Aug 05 11:52:05 2020

    [WL] UPACS THREAD 303: TOTAL RUNNING TIME: 0 SECONDS

  • But Fluro Works Know, I Add the folow Columns on de dicom.sql


    *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, 0x1010, "PatientsAge", 16, SQL_C_CHAR, DT_STR, "PID.9" },

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

    { 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" },

    { 0x0032, 0x1064, "--------", 0, SQL_C_CHAR, DT_STARTSEQUENCE, "---" },

    { 0x0008, 0x0100, "RPCSCodeValue", 8, SQL_C_CHAR, DT_STR, "---" },

    { 0x0008, 0x0102, "RPCSCodeScheme", 8, SQL_C_CHAR, DT_STR, "---" },

    { 0x0008, 0x0104, "RPCSCodeMeaning", 8, SQL_C_CHAR, DT_STR, "---" },

    { 0x0032, 0x1064, "--------", 0, SQL_C_CHAR, DT_ENDSEQUENCE, "---" },


    { 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, 0x0008, "--------", 0, SQL_C_CHAR, DT_STARTSEQUENCE, "---" },

    { 0x0008, 0x0100, "SPCSCodeValue", 8, SQL_C_CHAR, DT_STR, "---" },

    { 0x0008, 0x0102, "SPCSCodeScheme", 8, SQL_C_CHAR, DT_STR, "---" },

    { 0x0008, 0x0104, "SPCSCodeMeaning", 8, SQL_C_CHAR, DT_STR, "---" },

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


    { 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" }

    }

  • CT SCAN Not Working I Get this

  • Hi,


    I think you have to fill in:


    0020,000d 0 UI StudyInstanceUID (empty)


    You can get values out of conquest using:


    dgate64 --genuid:


    You can only use one


    ModalityWorkListQueryResultConverter0, and there you can also do it using lua function genuid().


    Marcel

Participate now!

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