I use the following code to check the last modified date of file which is on a network shared folder (eg: "\\someserver\subfolder\foobar.txt")

set##class%File

if the file is not available or does not exists, DateModified property return a negative value (which is fine). I use that property to quickly check if file has been modified and need to be imported.

Here is the issue: sometimes, accessing DateModified

Is there a way to add specific table permissions to a security role programmatically? I'm working on scripting some of the initial setup work when we sell certain add-ons to our software, and I see how I can assign resources to a role and give it a description, but I don't see how I tell it that this role gives the user, for example, SELECT privileges only on the invoices table, or SELECT, INSERT, UPDATE, and DELETE.

Hi Community,

In this video, you will learn about exciting new ways to perform analytics using data in your HL7® FHIR® repository:

⏯ InterSystems IRIS FHIR SQL Builder: Sneak Peek @ Global Summit 2022

Do we have REST API documentation to retrieve the data available in InterSystems Cache.

I am looking for APIs that will help me to pull the data available in InterSystems Cache.

Today we will talk about Adaptive Analytics. This is a system that allows you to receive data from various sources with a relativistic data structure and create OLAP cubes based on this data. This system also provides the ability to filter and aggregate data and has mechanisms to speed up the work of analytical queries.

Let's take a look at the path that data takes from input to output in Adaptive Analytics. We will start by connecting to a data source -  our instance of IRIS.

Hi Community ,

Can anyone please explain how to use EnsLib.EMail.AlertOperation operation to send notification to my email id when any error occurs in my production?

Please give any example how to use EnsLib.EMail.AlertOperation operation class

Thanks,

Smythee

A mistake happened and records were assigned the wrong assigning authority name: PID3.4.

Everything else  was correct. This resulted in duplicate records. Ex

Record 1: MRN1 has AA1 and clinical data

Record 2:  MRN1 has AA2 and the same clinical data as Record 1 + more clinical data that is not in Record 1

I would like to remove Record 2 ensuring that there are no orphan records left.

Should I use a merge transaction? If so, which one? The ones that I have seen expect a different MRN in the MRG segment. These records have the same MRN. What would be the best approach?

Thank you for reading!

InterSystems is pleased to announce the 2022.2 release of InterSystems IRIS Data Platform, InterSystems IRIS for Health, HealthShare Health Connect, and InterSystems IRIS Studio are now Generally Available (GA).

2022.2 is a Continuous Delivery (CD) release. Many updates and enhancements have been added in 2022.2, in SQL management, cloud integration, Kafka and JMS adapters, the SQL Loader, and other areas. The new Columnar Storage has been released, but it stills an experimental feature.

Release Highlights

Platform Updates

InterSystems IRIS Data Platform 2022.

Hey Developers,

We're pleased to invite you to join the InterSystems webinar on Building and Enabling Healthcare Applications with HL7 FHIR!

Date: Wednesday, November 09, 2022
Time: 1:00 PM Eastern Standard Time
Duration: 30 minutes

VetsEZ is looking for an InterSystems Technology Platform - Practice Lead to serve our Federal healthcare customers. As a lead systems integrator, VetsEZ has been delivering large-scale implementations for various federal customers, including the Department of Veterans Affairs (VA), with the world's largest footprint of InterSystems technologies. InterSystems Technology Platform comprises core technologies, including HealthShare, Caché, IRIS, Ensemble, DeepSee, and iKnow.

VetsEZ is seeking a full-time remote InterSystems HealthShare / IRIS Architect to design and deliver integrated health solutions for our federal healthcare clients with a focus on automation and semantic interoperability. This role focuses on understanding complex technical and business requirements and translating them into highly scalable, robust integration architectures. Act as a technical lead, and mentor team members while maintaining a hands-on role.

The candidate must reside within the continental US.

The topic of for/while loop performance in Caché ObjectScript came up in discussion recently, and I'd like to share some thoughts/best practices with the rest of the community. While this is a basic topic in itself, it's easy to overlook the performance implications of otherwise-reasonable approaches. In short, loops iterating over $ListBuild lists with $ListNext or over a local array with $Order are the fastest options.

As a motivating example, we will consider looping over the pieces of a comma-delimited string.

In our latest episode of Data Points, I had a conversation with Carmen Logueand Mary Ann Fusi about Adaptive Analytics and Smart Data Fabrics. A lot has changed and improved since the last time we discussed this product on the podcast, so take a listen!

With IRIS 2021.1, we released a significant revision our SQL utilities API at %SYSTEM.SQL. Yes, that's a while ago now, but last week a customer asked a few questions about this and then @Tom Woodfin applied gentle mental pressure ;-) to make me describe the rationale of these changes in a little more detail on the Developer Community. So here we go!

Is there any way to connect PHP Laravel 8 and Cache DB.

I am tried with one post found in DC, but that is not working for me also.

https://github.com/jeandormehl/laracache

If anyone has any suggestions please help me out in this. 

How can get support on IRIS? 

Hello 

I have a class to render reports as  pdf. My problem that arabic characters in report replaced with ####. 

Please find my code below

#dim stream as %Stream.Object set report = $classmethod($piece(reportClass, ".cls"), "%New")
set report.RUID = RUID set %response.ContentType = "application/pdf"

set sc = report.GenerateReportToStream(.stream, 2) return:$$$ISERR(sc) sc
do stream.OutputToDevice()

return $$$OK

Your help is appreciated.

Hi Community,
Watch the recording of the Second Community Roundtable: "What is the best source control system for development with InterSystems IRIS?" 

Some great discussions have been started during this roundtable. We invite you to continue these discussions. in the comments to this post.

Tell us, which source control you use and why – in the comments to this post. 

Hi

I'm thinking to deploy healthshare using kubernetes. Has any one done this before? How will the TCP listeners in healthshare work with kubernetes? Will they automatically create a service endpoint so that I can route traffic?

Please advise me on how to think about this.

Thanks

Hi Community,

Please welcome the new video on InterSystems Developers YouTube:

⏯ Getting To Know FHIR - The Best Explanation of FHIR They've Ever Heard @ Global Summit 2022

A new release of ZPM has been published 0.5.0

New in this release

• Added support for Python's requirements.txt file
• Using tokens for publishing packages
• Fixed various issues

Python's requirements.txt

Now, if your project uses Python embedded and requires some Python's dependencies, you can add requirements.txt file to the project, as usual for any Python project, file have to be in the root of a project next to module.xml. And with load command or install command, ZPM will install dependencies from that file with using pip.

1. iris-dollar-list

Interpretor of $list for python named DollarList.

This interpretor was made because :

• I wanted to use $list in python.
• Embedded Python do not support $list.
• The native API version do not support embedded $list in $list.

This is a work in progress. For now, it only support embedded $list in $list, int and string.

WIP float,decimal,double

This module is available on Pypi :

pip3 install iris-dollar-list

It is compatible with embedded python and native api.

Hello all; I am using a one-to-many relationship.  I have a Claim (one), in a relationship with Lines (many), but the Claim is storing a list of Lines IDs, rather than the Lines storing the Claim Id.  This seems upside down, and not what I expected.

Class Claim

{
    Relationship ClaimLineRel as ClaimLine [Cardinality = many, Inverse = Claim];
}

Class ClaimLine
{
    Relationship Claim as Claim [ Cardinality = one, Inverse = ClaimLineRel, OnDelete = cascade];
    Index ClaimIndex on Claim;
}

But the storage globals for Claim show data in the ClaimLine spot:

^ClaimD(1)=$lb("",$lb(2,3).

In Cache 2018, we were using a macro in a query that looked like this:

select $$GetExtraSQL^GetExtra('B',bddtl.odnumb,bddtl.odsnum,bddtl.oddsc1) as "Description", * from sqluser.bddtl

We could save that query as a view, and there was no problem with it.

In IRIS, if we put that query into SQL in the management portal, it still works, but if we save that query as a view, when we try to run a query on that view, we get a big error message:

ERROR #5540: SQLCODE: 400 Message: Process 604526 failed to compile Cached Query Class %sqlcq.R001.

Good morning, evening, night,... 

A small reflection/question for today... it's true that new IRIS for Health (I4H) releases are more and more powerful each time regarding FHIR capabilities. Nowadays it allows us to consume FHIR resources with extrem easiness, we can connect with end-points in external FHIR servers very easily and make I4H act as passthrough or consume their resources... or, even more, we can define, configure and run a FHIR repository in, literally, less than 5 minutes.

This is the tenth in a series of releases that are part of the developer preview program for 2022.2. Future preview releases are expected to be updated biweekly and we will add features as they are ready. Please share your feedback through the Developer Community so we can build a better product together.

As usual,  CD releases come with classic installation packages for all supported platforms, as well as container images in Docker container format.  For a complete list, refer to the Supported Platforms document.

Hi all.

I have a scenario where I am receiving NACKs and I'd like to adjust the error handing of the operation based on the content of the NACK.

For example, I could receive the following and want to move onto the next message:

MSH| ^~\&|||||20221025083135.489+0100||ACK ^A02^ACK|9271|D|2.5.1
MSA|AE|1664378390234
ERR|||207 ^Application internal error ^HL70357^^^^^^Cannot transfer patient, encounter is cancelled.|E

However, I could also receive the following and want to keep retrying:

MSH| ^~\&|||||20221014103828.043+0100||ACK^A03^ACK|1049|D|2.5.1
MSA|AE|1665740278804
ERR|||207^Application internal error^HL70357^^^^^^ISPN000427: Timeout after 15 seconds waiting for acks. Id=114232207|E

Adding VSCode into your IRIS container

One of the easiest ways to setup repeatable development environments is to spin up containers for them. I find that when iterating quickly, it was very convenient to host a vscode instance within my development container. Thus, I have created a quick container script to add a browser-based vscode into an IRIS container. This should work for most 2021.1+ containers.

Hi Community, 
Let's meet virtually at our first Community Roundtable! This will be a 45-minfriendly discussion on a given topic: VSCode vs Studio. 
Imagine that we just gathered together to share our thoughts, experiences, tips, and tricks. If you want to discuss specific questions within a given topic - please share them in the comments.
Watch recording: