InterSystems IRIS for Health

Syndicate content 1 

Description

INTERSYSTEMS IRIS FOR HEALTH InterSystems IRIS for Health™ is the world’s first and only data platform engineered specifically for the rapid development of healthcare applications to manage the world’s most critical data. It includes powerful out-of-the-box features: transaction processing and analytics, an extensible healthcare data model, FHIR-based solution development, support for healthcare interoperability standards, and more. All enabling developers to realize value and build breakthrough applications, fast.

Learn more

Sorting: By Date

Hi All,

I have two tables LB_TestSet and LB_Transfer

LB_Transfer has a list if TestSet row IDs, so i am doing the following join

SELECT 
LBTS_RowID,
,LBTS_CollectedDate
FROM SQLUser.LB_TestSet 
JOIN SQLUser.LB_Transfer ON ($LISTBUILD(LBTS_RowID) %INLIST LBTR_TestSetList)
WHERE LBTS_CollectedDate BETWEEN '2019-01-01' AND  '2019-05-10'

 

Without the date filter the query returns data, but if i add the date filter no data is returned

I also tried using %INTERNAL, %EXTERNAL TO_DATE('2009-01-01','YYYY-MM-DD')

Continue Reading
Rizmaan Marikar's picture
Post by Rizmaan Marikar 14 May 2019
Last answer 21 May 2019
0   0 3
2

answers
0

comments

152

views

0

rating

Hi There ,

     We are trying to do a small POC trying to integrate NHS Careconnect with Ensemble/Healthconnect. Does anyone have implemented this before. It would be good that you provide some suggestions  or any sample implementation. It would be good to get suggestions any  interesting use cases 

within NHS England for the POC.

Continue Reading
Soundar Aswin's picture
Post by Soundar Aswin 9 April 2019
Last answer 24 April 2019 Last comment 1 May 2019
0   0 2
1

answers
1

comments
90

views

0

rating