Query Error when creating Lab Requisition

Support
#21

I guess another question is, if there are multiple labs/procedures, how would we select the one to print through lab requisition?

#22

that’s a javascript error and not that important so you can turn off the debugging errors now

sure, try disabling and reenabling and then look for the table in mysql

#23

Rgr. Enabled and reenabled, had authorization error that resolved when I logged out nad logged back in and completed the task before the session timed out (I’ll be glad to get rid of the token!)

No Lab Req form table

24%20
24%20684×1370 149 KB
39%20
39%20684×670 49.7 KB

#24

ok but table name is requisition

#25

thought of that… its not there.

#26

weird, you can manually build it

CREATE TABLE `requisition` (
  `id` bigint(19) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  `req_id` varchar(90) NOT NULL,
  `pid` int(11) NOT NULL,
  `lab_id` bigint(35) NOT NULL
) ENGINE=InnoDB;
#27

Nice! Thanks! I’ll keep you posted!

#28

That works! That lets me create the requisition with the barcode. Last question for this part is how to select a procedure if there are multiple orders?

1 Like