Query Error when creating Lab Requisition

kevin_ytc · February 17, 2020, 1:23pm

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

stephenwaite · February 17, 2020, 1:26pm

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

kevin_ytc · February 17, 2020, 1:50pm

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

stephenwaite · February 17, 2020, 1:52pm

ok but table name is requisition

kevin_ytc · February 17, 2020, 1:56pm

thought of that… its not there.

stephenwaite · February 17, 2020, 2:02pm

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;

kevin_ytc · February 17, 2020, 2:10pm

Nice! Thanks! I’ll keep you posted!

kevin_ytc · February 17, 2020, 2:40pm

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?