Hi community members!

I'm testing some functionalities about Foreign Tables and it works smoothly with PostgreSQL database, but I found out an issue with MySQL database, I followed the documentation:

Hi Community,

Watch the latest video on InterSystems Developers YouTube:

⏯ Understanding the Structure of HL7 FHIR Resources

https://www.youtube.com/embed/7q8EpeubhA8
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

Hello everyone,

I am working with InterSystems IRIS and seeking guidance on how to perform specific tasks related to the FHIR SQL Builder using commands or code, rather than the graphical user interface (GUI). The specific tasks I am trying to accomplish are:

Will it hurt anything if I disable the user that installed IRIS, within IRIS? Does this cause a problem with background processes running or with the restart? I know the _Ensemble user is used to start/stop/restart objects within IRIS, just didn't see anything in the documentation about the user that installed IRIS.

Thanks

Scott

I'm trying to execute SQL on a EC2 via SSM:

import boto3

instanceid = "i-123456789"
sql = """SELECT path FROM Security.Applications WHERE ID = '/csp/sys'"""
template = """su - irisusr -c 'cat << EOF | iris sql iris -U %SYS
                """ + sql + """
                        q
                        EOF'
                       """
template = [line.strip() for line in template.splitlines()] 
template = """\n""".join(template) 
ssm_client = boto3.client('ssm') 
response = ssm_client.send_command(
            InstanceIds=[instanceid],
            DocumentName="AWS-RunShellScript",
            Comment=AWS,
            Parameters={'commands': template})

Hi

We are just looking to migrate to IRIS under windows and as the IRIS databases are 8k just wondered if anyone has configured windows with a block size for the database drive other than the default 4k.

Any thoughts ?

cheers

Gary

Hello,

I am still trying to figure that Calculated Measure stuff and I hope to learn from you. I have several cubes I am trying to create calculated measures using the Calculated Member Expression.

I have a cube called Cards. There is a measure called count that give total cards count of 15,000. There are two dimensions I am considering. One is the CreditGrade (A, B, C, D, nograde) and the other is the date of the scoredate.(2000-2015).

The CreditGrade dimension has two hierarchies. H1 being the creditnumber and H2 being the CreditGrade (The one I need).

We receive a JSON message containing an element which is larger than the system long string size. We are using Ensemble HealthShare v2017 which prevents us from using the %GET method as it doesn’t allow us to define the output as a Stream. We are instead trying to the read the contents of the JSON message using Readline function, and store the value into an instance of the %Stream.GlobalCharachter class, and then read from the instance of that class and write the contents of that element into a HL7 Message.

We released a new version of ZPM (Package Manager)

New in this release:

1) Interoperability support - support for dtl, bpl, lut, esd, x12 in module.xml

Now it's allowed to refer to DTL and BPL files. ZPM stores and uses them as CLS.

I'm looking for a means to dynamically specify and/or limit the data from the source that goes into a cube at build time.

I have a single data class that defines my source, and as the data within this table/collection grows/changes over time, I would like to be able to control which records actually make it into the indexed cube, but I'm having a hard time (short of defining a stored procedure to use instead of the extent query) for populating my cube indexes.

InterSystems is proud to sponsor NUS Health Hack 2025 and invite innovators, developers, startups and health tech professionals to join this exciting digital health tech hackathon!

Organized by the National University of Singapore - Yong Loo Lin School Of Medicine, this hackathon will take place from February 8th to March 29th, 2025, and will bring together an incredible mix of healthcare professionals, developers, students, startups and tech companies driving innovation in the industry.

Why Join?

• Make an Impact: Solve real-world healthcare challenges.
• Network: Collaborate with like-minded professionals, innovators, and industry leaders.
• Get Support: Access guidance from mentors throughout the 4-week development phase.

InterSystems is providing access to our Vector Search technology, which participants can leverage for their projects. Plus, our tech mentors will be available to offer support throughout the event. Learn more about the InterSystems challenge and prizes here.

How It Works

Hello. On some hosts, IRIS in containers.intersystems.com/intersystems/iris-community:2024.1 falls with a core dump.

auser:~$ docker run --rm -it --entrypoint=""  containers.intersystems.com/intersystems/iris-community:2024.1 bash
irisowner@6170dcdbe77c:~$ iris start IRIS
Illegal instruction (core dumped)

Coredump stack:

The first developer preview of InterSystems IRIS 2024.2 and InterSystems IRIS for Health 2024.2 has been posted to the WRC developer preview site. Containers are not available for this preview, but we’ll be sure to post them next ti