Hi, 

I'm currently looking to deploy a production with readymade auditing functionality. I can currently call user defined audit entries using  $SYSTEM.Security.Audit() but I'm finding to display these posts properly I need to create User-Defined Audit Events on the management portal, otherwise they are displayed as "UserEventOverflow"/"AddedUnknownUserEvent" .

Hi developers!

Could you please advice what is the easiest way to download globals from a particular server?

I have the access to it, I know which globals I need to download/copy (5-7 globals per name). This is to perform then analysis in IRIS BI.

We have this intermittent issue with a particular supplier message , just wondering if anyone has further insight around the two errors we get when we see this. 

We use the out of the box TCP hl7 adapter. 

We first seem to get this incomplete hl7 message resulting in an error like 

Discarding leftover input 'MSH|

This is not unexpected as the final obx has not dot the description of OBX:2.2 ect. 

OBX|53|TX|NCDAC^

The next message will have the error 

👁️‍🗨️ With the InterSystems IRIS Supply Chain Orchestrator, you can visualize your supply chain data in real-time and get actionable insights.

🌐 Start by exploring use cases and architecture of the InterSystems IRIS® for Supply Chain platform, then create KPIs and analyze supply chain issues (learning path, 1h 15m).

Looking for someone who has a proven resume with InterSystems and Ensemble Experience.

Ideal Qualifications: Ensemble Experience + working with InterSystems DTL for HL7 Transactions.

Work Type: Consultant at $50-$60/hour DOE

Job Location: Remote

Work Category: Healthcare

Responsibilities: work with InterSystems Ensemble Productions for HealthCare.

Qualifications: 3+ years working with InterSystems Ensemble.

US Citizens only.

If Interested: email pbrown@cybercodemasters.com with your latest resume reflecting InterSystems + Ensemble and provide your phone number.

It's time to announce the Winners for July! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in July:

🥇 @Luis Angel Pérez Ramos
🥈 @Muhammad Waseem
🥉 @Padmaja Konduru 

 Learn more about the competition and our awesome winners below.

Hey Community,

Watch this video to learn how to build and run machine-learning models using InterSystems IRIS Cloud IntegratedML using the example of 15,000 rows of data from New York City taxi rides to predict the tip for a given ride:

⏯ Building Models with IntegratedML in the Cloud

There is an exciting new Organizational Dashboard feature available within CCR.  This new functionality allows users to get a wholistic view of the CCR usage within their organization, allowing things like:

• See warnings for when organizational usage patterns need to be adjusted
• View total CCR volume
• Explore the most active CCR Systems
• Identify DB version of various Environments
• Discover which Systems are no longer active and are candidates for Depreciation
• List the CCR Client Tool update dates to see what is out of date (to be released shortly)
• Examine number of active CCR users, their CCR activity volume and which of them are Perforce users
• Correct ItemSets which are troubled across all Systems

Developing with InterSystems Objects and SQL – IN PERSON September 11-15, 2023   9:00am-5:00pm US-Eastern Time

• This 5-day course teaches programmers how to use the tools and techniques within the InterSystems development environment to build high-performance transactional applications. Learners build a complex application using an IDE, object-oriented design, SQL and unit testing.
• This course is applicable for users of InterSystems IRIS Data Platform and Caché.
• Many benefits are offered by being physically in the classroom with our instructors for a more personalized educational experience.

Hi Guys,

below is a javascript sample code in one of my methods in a CSP page where I'm loading some data from a global to a Javascript arrays, the problem is that if I call the method with do (d ..mymethod()) everything works fine but calling it with Job (J ..mymethod()) it seems that the javascript part is not working, is there a way to fix this?    

The reason why I'm using Job call because I need it to run in background and not to hold other processes.  

&js<
    Sensor='#(Sensor)#';
    maindatafx[Sensor].push(ConvertArr((Fdte),'#(FXData)#'))
linechartdatafx[Sensor

Hey Developers,

Watch this video to learn more about the FHIR, how it came to be and the future of the standard:

⏯ The Concept of FHIR: A Healthcare Data Standard Designed for the Future

InterSystems Change Control: Tier 1 Basics - Virtual  September 6-8, 2023   9:00am-5:00pm US-Eastern Time (EDT)

• This course – consisting of 3 days – teaches Change Control Record (CCR) application users how to safely and efficiently progress code changes as well as changes made to interoperability components such as productions and data transformations. By the end of training, learners will be able to leverage the workflow and documentation tools, use CCR Transport to move changes, follow best practices to prevent crises, and debug common errors.

Hello Everyone,

Last month, we asked for input from the IRIS community regarding exam topics for our InterSystems IRIS SQL Specialist and Expert exams. We will close the window for providing feedback on the exam topics on Thursday, August 31st, 2023. Thus, if you would like to have your say in what topics are covered on the exam, this is your last chance!

To show our appreciation for helping us validate our exam design, we will hold a raffle where 15 survey respondents will be chosen to receive a $50 gift card. The gift card is a Tango Card that can be redeemed at any number of online retailers.

Hi Team,

Is there any way to take a clone object of executed query result of %SQL.Statement 

Set statement= ##Class(%SQL.Statement).%New()
Set pre = statement.%Prepare("Select * From TableName")
Set  result = = SQl.%Execute()
Write result.%ConstructClone(,.cc) ; ConstrcutClone was overridden in the class %SQL.StatementResult

I can loop result.%Next() multiple times if clone was taken from the object

We are updating a C# module which creates consumes an OdbcConnection from System.Data.Odbc.  This module used to create a DSN-less connection through the InterSystems Cache driver, and we are updating it to call the IRIS ODBC35 driver following migration of the target database.

hi， I followed the example of the system and wrote a method to connect to an external database to obtain a result set, but I couldn't get the result. can anyone please help on this.

/// correct
ClassMethod PersonSets(name As %String = "", state As %String = "MA") As %Integer [ ReturnResultsets, SqlName = PersonSets, SqlProc ]
{
		// %sqlcontext is automatically created for a method that defines SQLPROC

		// SQL result set classes can be easily prepared using dynamic SQL. %Prepare returns a
		// status value. The statement's prepare() method can also be called directly.

Hi Community,

Whenever I insert a decimal value with trailing zero(ex:12.0000) value in my JSON object dynamically through %Set method. It truncates the trailing zeros. However If I use literal constructors { } It working as expected.  So, In my case the JSON will be generated dynamically. I can't go with "Curly Bracket { } " and the JSON schema not string as well.
Is there any way to fix this?

    set json = { "decimal": 12.000}
    zw json
    set json1= ##Class(%DynamicObject).%New()
    do json1.%Set("decimal", 12.000) ; this is consider as string
    do json1.

Hello,
I would like to do the following :

set name = $name(^A)
for i=1:1:10
{
    set $qsubscript(name, i) = "TEST"_i //dream code that does not work
}
set @name = "" //will create ^A("TEST1", "TEST2", "TEST3", ... , "TEST10") = ""

Unfortunately, unlike $PIECE(), $QSUBSCRIPT() is not bidirectional.

Is there a way to do what I described, in a clean way ? (something supported by the system) 

I would like to avoid :

- using a custom made solution (eg: appending keys one by one to a string, adding commas when needed) unless it's failproof (eg: can deal with commas in keys, non string

Hi,

i'm starting to try to switch to VS Code with ISC integration plugins.
Everything seems fine until i get to and environment with CCR enabled. I can't open any class in RW and i don't know how to check the class out.

Is it supported? What do i need to do to use it?

Thanks

Pietro

As noted in the previous article Native API has some limits.
So I did some research on a more Terminal-like interface that
provides me with access like a console or the IRIS terminal
to allow my  $QUERY over a global and other nice commands
that are not supported/mapped in NativeAPI for ObjectScript.

The basic tools are well-prepared and available.

• Connection() creates a fully operational and stable partition for me
• Function() allows calling any routine or method I need
• similar ClassMethodValue and ClassMethodVoid

There is just no method CommandLine and some already prepared code is needed.

I have tried many methods from super classes of %CSP.REST but I can't find a method I can override that will run after the %response object is created so I can set a header that is common to each implementation method.  It's one line of code in each method to set the header but it would like to make it super easy, simple and just have a method that runs on, before, after the implementation method to set this common header (we want to return the API version in each responses HTTP headers.

Any ideas?

InterSystems IRIS Adaptive Analytics version 2023.2 is now available from the InterSystems Software Distribution site.  This new release brings along some great enhancements included with our partner AtScale's Version 2023.

Hi All! For those of you who are early adopters of Health Connect Cloud, you might be interested in our latest video -- a tutorial on how to create firewall rules, as well as obtain important network addresses, in your Health Connect Cloud deployments. Let us know if you have questions or interest in learning more about Health Connect Cloud.

InterSystems Kubernetes Operator (IKO) 3.6 is now Generally Available.  IKO 3.6 adds significant new functionality along with numerous bug fixes.  Highlights include:

• Easily include Web Gateway sidecars for compute and data nodes.

If you hold the InterSystems HL7 Interface Specialist certification, you can potentially get recertified and have your certification expiration date extended by five years by beta testing our new InterSystems HL7 Interface Specialist Recertification project. The project includes hands-on exercises to validate core skills for developers who use InterSystems products to build and test HL7 v2.x productions. During the beta period, which extends until October 31, 2023, anyone who holds the credential is eligible to try the project, and the standard $150 fee is waived for candidates.

We are about to embark on a development where we'll be taking HL7 messages and generating PDF reports from them. We are wanting to future proof our development efforts within the constraints of our currently deployed platform and future upgrade options. We are currently running on Ensemble 2018, though an upgrade to Iris is anticipated - at some indeterminate point in the future. We are aware of Zen Reports and InterSystems Reports (Logi) as technology options, but are also unclear on some details. A roadmap and guidance from those who've done this kind of thing before would be great!

I'm doing a REST service. A method has as body parameter a JSON corresponding to a class A.

In my production I have class A so that I retrieve the parameters using a dynamic object, such that:

Set body = ##class(%DynamicObject).%FromJSON(%request.Content)
Set myObjectA = ##class(A).%New()
Set myObjectA.Id = body.Id
Set myObjectA.Name = body.Name
Set myObjectA.Date = body.Date
Set myObjectA.Salary = body.Salary

I would like to know if I can avoid doing the manual mapping, doing a casting, since I am sure that FromJSON will return a class A. Something like this:

Set myObjectA = ##class(A).

Web Server Type: Microsoft Web Server: Microsoft-IIS/10.0 .

Error from Gateway  - IRISCONNECT : Error Writing to InterSystems IRIS
Cannot Write Data : IRISconnectSend(): 0 Error Code: 0 (IRISconnectErrorString="SSL/TLS error in SSL_write(), SSL_ERROR_SYSCALL: I/O error (10053)")
lencoded
Accept: text/html,application/xhtml+xml,application/xml;q=0.

Error from HOST System to CSP Gateway : 403 Forbidden Error.

Error from IIS Logs : 403 16

What could be the Root Cause and Resolutions ??

Hi all,

I'm working on a routing rule for Ens.Alert. I'd like to add some text to the email alert but I'm having trouble formatting the text. I want a new line after the original alert with my own text. I will attach a screenshot. Looking at the "assign" line, I'm looking for what I need to use in place of  "\r\n" to make a new line. 

(I had troubles uploading the screenshot, but the only thing that is missing in the picture is the end of the sentence and an ending ")

Best,

Erin

I successfully setup a REST web application with JWT enabled, which is fantastic.  My next configuration 'challenge' is to add 2FA to this REST app.  First question first - is this possible with the OpenAPI generated /login?  The end goal is to build out a SPA (React) using /login for the JWT and adding the Auth bearer token for api calls.  I'd like to prevent the token generation until the 2FA is satisfied - or generate the token, but test if the 2FA is satisfied before allowing calls forward.  Hope that's clear.