New post
User bio
404 bio not found
Member since May 9, 2017
Posts:
Steven has not published any posts yet.
Replies:
show all 6
Steven Potashnyk · Mar 13

You will find the String "07/03/2025" is not recognised as a date when using a JDBC connection :

You will need to pass Logical or the date as an ODBC/JDBC with a format of "yyyy-mm-dd"

-- Passing Date as String : '07/03/2025'
select * 
from SQLUser.PA_Adm
where PAADM_AdmDate = '07/03/2025'
-- ERROR
--SQL Error [400] [S1000]: [SQLCODE: <-400>:<Fatal error occurred>]
--[Error: <<ZODAT>%rtpcHelper1+1^%sqlcq.Config.cls43.1>]
--[Location: <ServerLoop>]
--[%msg: <Error: '07/03/1025' is an invalid ODBC/JDBC Date value>]

--Passing Date as String : '2025-01-01' (ODBC/JDBC format)
select * 
from SQLUser.PA_Adm
where PAADM_AdmDate = '2025-01-01'
--Executes without error

--Passing Date as Logical : +$H (67278)
select * 
from SQLUser.PA_Adm
where PAADM_AdmDate = +$H
--Executes without error
Steven Potashnyk · Mar 11

There is not enough infromation in the post to really give you guidance.   As Timo mentioned iService ticket may be a better approach to get help. A few things to look at

  1. Check to see what values are being saved in the print history.  if you can see values populating in P1-P9 then Trakcare technically should pass them off to Logi.
  2.  Check the Logi reports configuration in Trakcare. Ensure its configured correctly for the environment.
  3. Put some debug into the stored procedure being called from the Logi Catalogue to see if the parameters are being passed.
Steven Potashnyk · Jul 18, 2021 
Select FACIL_DESC as "Hospital Type"
From SQLUser.CT_Hospital
JOIN SQLUser.PAC_FacilityType on (HOSP_FacilityType_DR=HOSP_FacilityType_DR)

output :

Private Hospital
Private Day Facility
Other
Public Hospital 
Public Day Facility

or the easier approach is using the arrow syntax

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=GSQL_implicitjoins

Select HOSP_FacilityType_DR->FACIL_DESC
From SQLUser.CT_Hospital

Hope this helps

Certifications & Credly badges:
Steven has no Certifications & Credly badges yet.
Global Masters badges:
Steven has no Global Masters badges yet.
Followers:
Steven has no followers yet.
Following:
show all 1
Evgeny S.