PacsOne Server

[stejeda]

When I perform a modality worklist query for CT as a modality and 'today' as the other parameter, this is what I get:

Error executing SQL query: insert into procedurecode set value='CTCHESTS',designator='LOCAL',version='',meaning='CT CHEST W/O',studyuid='1.2.840.113745.101000.1133000.38385.4839.304080';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCHESTC',designator='LOCAL',version='',meaning='CT CHEST W',studyuid='1.2.840.113745.101000.1133000.38390.4259.306838';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTABDC',designator='LOCAL',version='',meaning='CT ABDOMEN W',studyuid='1.2.840.113745.101000.1133000.38377.4331.298320';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTAPC',designator='LOCAL',version='',meaning='CT ABDOMEN & PELVIS W',studyuid='1.2.840.113745.101000.1133000.38390.5552.307205';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTSFTNECKC',designator='LOCAL',version='',meaning='CT SOFT TISSUE NECK W',studyuid='1.2.840.113745.101000.1133000.38390.5899.307270';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCAC',designator='LOCAL',version='',meaning='CT CHEST & ABDOMEN W',studyuid='1.2.840.113745.101000.1133000.38323.6485.266305';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTABDC',designator='LOCAL',version='',meaning='CT ABDOMEN W',studyuid='1.2.840.113745.101000.1133000.38354.3680.282354';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCHESTS',designator='LOCAL',version='',meaning='CT CHEST W/O',studyuid='1.2.840.113745.101000.1133000.38360.4272.286275';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTABDSC',designator='LOCAL',version='',meaning='CT ABDOMEN W & W/O',studyuid='1.2.840.113745.101000.1133000.38390.4498.306949';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCHESTS',designator='LOCAL',version='',meaning='CT CHEST W/O',studyuid='1.2.840.113745.101000.1133000.38383.3938.302071';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTABDC',designator='LOCAL',version='',meaning='CT ABDOMEN W',studyuid='1.2.840.113745.101000.1133000.38384.4281.303119';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTABDC',designator='LOCAL',version='',meaning='CT ABDOMEN W',studyuid='1.2.840.113745.101000.1133000.38390.4647.306990';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTPELVC',designator='LOCAL',version='',meaning='CT PELVIS W',studyuid='1.2.840.113745.101000.1133000.38384.6638.303577';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCHESTC',designator='LOCAL',version='',meaning='CT CHEST W',studyuid='1.2.840.113745.101000.1133000.38384.4799.303247';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTHEADS',designator='LOCAL',version='',meaning='CT BRAIN W/O',studyuid='1.2.840.113745.101000.1133000.38384.5243.303309';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCHESTSC',designator='LOCAL',version='',meaning='CT CHEST W & W/O',studyuid='1.2.840.113745.101000.1133000.38385.3797.303787';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCAC',designator='LOCAL',version='',meaning='CT CHEST & ABDOMEN W',studyuid='1.2.840.113745.101000.1133000.38377.6112.298739';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTHEADS',designator='LOCAL',version='',meaning='CT BRAIN W/O',studyuid='1.2.840.113745.101000.1133000.38390.6332.307358';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCHESTS',designator='LOCAL',version='',meaning='CT CHEST W/O',studyuid='1.2.840.113745.101000.1133000.38382.5286.301407';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTABDS',designator='LOCAL',version='',meaning='CT ABDOMEN W/O',studyuid='1.2.840.113745.101000.1133000.38384.6758.303600';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCHESTC',designator='LOCAL',version='',meaning='CT CHEST W',studyuid='1.2.840.113745.101000.1133000.38385.4458.303969';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTPELVC',designator='LOCAL',version='',meaning='CT PELVIS W',studyuid='1.2.840.113745.101000.1133000.38385.4784.304069';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTAPSC',designator='LOCAL',version='',meaning='CT ABDOMEN & PELVIS W & W/O',studyuid='1.2.840.113745.101000.1133000.38377.6845.298955';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCHESTS',designator='LOCAL',version='',meaning='CT CHEST W/O',studyuid='1.2.840.113745.101000.1133000.38389.4773.305929';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTCAC',designator='LOCAL',version='',meaning='CT CHEST & ABDOMEN W',studyuid='1.2.840.113745.101000.1133000.38388.4250.304769';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTAPC',designator='LOCAL',version='',meaning='CT ABDOMEN & PELVIS W',studyuid='1.2.840.113745.101000.1133000.38389.5989.306266';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTHEADS',designator='LOCAL',version='',meaning='CT BRAIN W/O',studyuid='1.2.840.113745.101000.1133000.38388.5070.304991';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTAPS',designator='LOCAL',version='',meaning='CT ABDOMEN & PELVIS W/O',studyuid='1.2.840.113745.101000.1133000.38388.5476.305072';: Unknown column 'designator' in 'field list'

Error executing SQL query: insert into procedurecode set value='CTLUMBS',designator='LOCAL',version='',meaning='CT LUMBAR SPINE W/O',studyuid='1.2.840.113745.101000.1133000.38389.5059.306037';: Unknown column 'designator' in 'field list'

Remote Modality Worklist SCP IDXMWS returned 29 worklist items:Patient Identification Patient Demographic Scheduled Procedure Step Scheduled Protocol Code Sequence Requested Procedure Requested Procedure Code Sequence Imaging Service Request
Patient's Name HUNSINGER ALICE
Patient ID 2710200
Patient's Birth Date 19640801
Patient's Sex F
Requested Contrast Agent N/A
Scheduled Station AE Title IDT
Scheduled Procedure Step Start Date 20050210
Scheduled Procedure Step Start Time 072000
Modality CT
Scheduled Performing Physician's Name ADRIANO RUBEN D MD
Scheduled Procedure Step Description CT CHEST W/O
Scheduled Procedure Step ID 17519
Scheduled Station Name Central CT
Scheduled Procedure Step Location N/A
Pre-Medication N/A
Scheduled Procedure Step Status N/A
Code Value

[pacsone]

Yes, this is a bug in the current 2.1.2 version of PacsOne Server premium edition as another user has reported it:

http://www.pacsone.net/forum/viewtopic.php?t=211

To fix this, you can either wait for the next release, or edit the script remoteWorklist.php and modify line 269 and 270 as follows:

designator -> schemedesignator
version -> schemeversion

[stejeda]

It worked; somewhat. I got rid of the error messages but now I'm only getting the details on one item although it's telling me that 12 items were returned. How do I see the others?

[pacsone]

You can click on the Modality Worklist link from the Main Menu.