PacsOne Server Forum Index PacsOne Server
Welcome to PacsOne Server Users Bulletin Board
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

modality worklist query

 
Post new topic   Reply to topic    PacsOne Server Forum Index -> Installation Trouble
View previous topic :: View next topic  
Author Message
stejeda



Joined: 09 Feb 2005
Posts: 6

PostPosted: Thu Feb 10, 2005 3:31 pm    Post subject: modality worklist query Reply with quote

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
Back to top
View user's profile Send private message
pacsone
Site Admin


Joined: 30 Sep 2003
Posts: 3015

PostPosted: Thu Feb 10, 2005 3:59 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
stejeda



Joined: 09 Feb 2005
Posts: 6

PostPosted: Fri Feb 11, 2005 7:15 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
pacsone
Site Admin


Joined: 30 Sep 2003
Posts: 3015

PostPosted: Fri Feb 11, 2005 9:02 pm    Post subject: Reply with quote

You can click on the Modality Worklist link from the Main Menu.
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    PacsOne Server Forum Index -> Installation Trouble All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group