All
Accepted answers
Steven Potashnyk · Mar 13, 2025 go to post

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, 2025 go to post

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 go to post 
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

Steven Potashnyk · Oct 29, 2019 go to post

Hello Jude

  • What is the error?
  • Do you have change control enabled?

if your environment has CCR enabled you may need to create a change session before running an update query.