#InterSystems IRIS for Health

Hi Community,

I am attempting to create a new table by executing a SELECT statement that involves joining multiple tables. However, I encountered an error during execution: '( expected, AS found^Combined AS.' I would also like to create a cube based on this SQL table. However, during the cube creation process, I am prompted to specify a source class, and I'm unsure which class to use as it requires an existing class. Could you please help me identify the issue with the table creation, and provide guidance on selecting the appropriate source class for the cube creation?"

Working on a custom view for LookupSettings.cls. I've added code to adda Change Log entry into the table when rows are added/updated. I'm trying to do the same for when rows are deleted. How can I pull the key & value for the row when it is selected for delete /un-delete? The variable rowData is used a pointer for the row index. I know I'm missing something simple...

Hello All.

In need of some help.

We are currently migrating Interfaces from JCAPS to HealthConnect 19.1 and have done a lot of work on our Dev server. I am looking to copy/export this work over to the Test server and have managed to export the production and Rules, HL7 custom Schemas etc. The only thing left now are the Data Transformations but so far I can only find ways of copying the transformations over individually. Is there some way to copy all of the transformations we have produced in our namespace to another server in one go?

Thanks

Hi,

i have a DTL with generic source request (Inbound TCP).

i have added a parameter in the request class and compiled.

how do i now refresh or resync the DTL so that i see the new added field in the source.

Thanks

Hello, guys!

I'm facing a problem when I compile my code in Atelier (version 1.3) when connected to an Iris Community instance in Docker container.

When compiling, the code is synchronized with the server correctly, however, in the IDE, the code is inserted into the class again.

Class after compile:

I am trying to create a database using python. The example shows setting a Name string and a Properties object containing Directory=.

; Use class methods to create an instance
 %SYS>s Name="ABC"
 %SYS>s Properties("Directory")="c:\abc\"
 %SYS>s Status=##Class(Config.Databases).Create(Name,.Properties)
 %SYS>i '$$$ISOK(Status) w !,"Error="_$SYSTEM.Status.GetErrorText(Status)

How do I update and pass the Directory property using Python?

I want to convert the image to base64.

I have only a remote image URL.

please suggest the solution with allow cors origin.

您好，我想问一下为什么我无法通过Iris中的内置转换模板将从HAPI-FHIR服务器下载的患者资源转换为SDA格式。它总是表明缺少某个默认值，或者这就是我们需要更改格式吗？我想问一下我们如何快速创建自己的映射，以及如何通过json将所需的数据转换为sda并将其存储在iris中，然后我们可以通过齐柏林飞艇进行调用，非常感谢您解决我的问题问题

Transaltion for the question:

Hi

Upon creating namespace I selected same database for both Globals and Routines. How can I separate both the databases. Please note that I already have data and code saved in database.

Thanks

Does InterSystems have any best practices for deploying IRIS into Kubernetes? For example one question we have is should IRIS have a dedicated AKS cluster or can it be added to an existing cluster?

David

Hello,

I am new to this forum. So please let me know if this is not the place to post these questions.

I have heard from some previous Intersystems presentations that FHIR profile validation before posting to FHIR server (using $validate) would be available in IRIS for Health. How do I confirm if this functionality is available and if so, on which version of IRIS?

Thanks

I'm trying to connect to a MySQL database through a SQL Gateway (type JDBC) on a MacBook M1. Can't get the connection working, anybody any experience on this topic?

What are other's thoughts, opinions and experiences going from CSP to RESTful services, specifically when it comes to reusing code in CSP files?

One could define a method in CSP as follows:

<script language="cache" method="SubmitSomethingAwesome" arguments="aswesomeId:%Numeric">

And it's generated in csp.mycsppage.cls ascsp.mycsppage.SubmitSomethingAwesome(awesomeId as %Numeric).

Have people had success defining there rest call by calling the generated CSP classmethod?

Things that work well I've found:

Morning everyone,

I would appreciate some advice please- hopefully there is plenty of experts out there.

We are setting up an sFTP share between hospital trusts here in the UK and I have set the outbound operation up using a custom extension of EnsLib.HL7.Operation.FTPOperation.

We are configuring a VPN tunnel to run between the sites also so there is a bit of firewall / network routing to take place to enable the connection but to add in a complication we are on a mirrored cluster and usually present on a Virtual IP address.