If one of your packages on OEX receives a review you don't get notified by OEX only on YOUR package.
​​​So @Evgeny Shvarov  suggested publishing my monthly summary of reviews here in DC.
It reflects my experience with the status I found at the time of my review.

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

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

🥇 @Robert Cemper, ex Senior Sales Engineer from InterSystems

🥈 @Sergey Mikhailenko, Chief Specialist, AO Mosvodokanal

🥉 @Henry Pereira, Technical Leader, BPlus Tecnologia
 

  Learn more about the competition and our awesome winners below.

InterSystems is proud to announce the developer preview program for the 2022.3 releases. Many updates and enhancements have been added in 2022.3 and there are also brand new capabilities, such as the new FHIR SQL Builder, improvements for Columnar Storage, and support to Oracle Linux 9 (not in this first preview).

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.

The build number for this developer preview release is 2022.3.0.539.0.

As usual,

Developers, we have prepared a tutorial to get you started with InterSystems Adaptive Analytics powered by AtScale. In it, in addition to setting up AtScale and working with data cubes, we will also touch on methods of working with InterSystems Reports and other analytical systems.

Now the course is ready and we want to conduct a pilot training course on a small group of volunteers (3-5 people).

The course will be held in the form of two-hour classes for three consecutive days from 11/14/2022 to 11/16/2022.The time range is approximately 2pm to 6pm UTC+4 (Dubai).

Hello,

searching messages in our Message Bank is quite slow, often runs into timeout.

I wanted to perform a tune table on Ens_Enterprise_MsgBank.MessageHeader because this apparently has not been done yet - the Tune Table utility shows no entries for selectivity, etc.

I tried

w $SYSTEM.SQL.Stats.Table.GatherTableStats("""Ens_Enterprise_MsgBank"".MessageHeader")

and got this error message

Table 'Ens_Enterprise_MsgBank.MessageHeader' is mapped to a readonly datababase.No tuning will be performed.0 ЉpTable 'Ens_Enterprise_MsgBank.MessageHeader' is mapped to a readonly datababase.

Hello fellow developers!

When developing with ObjectScript Package Manager, one crucial thing is the package version, which we place in the module.xml file. When we add changes to the package and are ready to publish a new version of the package in the registry, we also need to increase the version number. This is clear, but it is annoying, and we can often forget to do that. 

This small article will help you to automate such a process.

want to use IIS as a web server and has configured both IIS & CSP Gateway unfortunately getting this error message . 

Hi,

when I using ObjectScript Trigger Code , I want to get whether the fields has changed by using "{fieldName*C}" ,  actually, fieldName in "{fieldName*C}" is a real field name ,but in my code, fieldName is a variable as follows:

SET stat=##class(%SYSTEM.SQL).GetColumns(tableName,.byname,.bynum,1)
		IF stat=1{
			SET i=1WHILE$d(bynum(i)){
				SET xColName=bynum(i)
				SET valComp={xColName*C}
				
				IF valComp=1{
					SET oldVal=1//{xColName*O}SET newVal=2//{xColName*N}
					&sql(INSERTINTO Yan.LogTableExt(Parref,ProperName,OldValue,NewValue) VALUES

InterSystems is pleased to announce the release of System Alerting & Monitoring (SAM) version 2.0.

What is SAM?

SAM marries IRIS’s standards-based Monitoring API and Log Monitor with familiar industry standard tools like Grafana and Prometheus to create a basic monitoring and alerting solution for IRIS clusters.

For more on SAM, see the System Alerting and Monitoring Guide.

What’s new in SAM 2.0?

The industry standard tools that SAM relies on have all been upgraded. 

Configuration Export & Import – You can now export your SAM configuration and re-import it into another SAM instance.

Hi Everyone! 
Join us on Global Masters for a fun and spooky celebration of the Halloween season. 
Complete all challenges in "It's a Halloween season 🎃" channel to enter a raffle for our new prizes 🎁 - a plush blanket and a laptop desk. 

> Go to Global Masters <

<assign value='source.{ORC:FillerOrderNumber}' property='target.{OBR:FillerOrderNumber}' action='set' />
<assign value='##class(%IO.FileStream).%New()' property='tempStream' action='set' />
<assign value='tempStream.Open(,"NEWR")' property='Status' action='set' />
<foreach property='source.{OBXgrp()}' key='g1' >
<foreach property='source.{OBXgrp(g1).OBX()}' key='s1' >
<if condition='source.{OBXgrp(g1).OBX(s1):ValueType} = "ED"' >
<true>
<assign value='SetID + 1' property='SetID' action='set' disabled='1' />
<assign value='"1"' property='target.{OBX(1):SetIDOBX}' action='set' />
<assign

Hi Guys,

My understanding is that SQL gateway connection is a way where you can have two ensemble instances where in instance A you can have a class and then you create a connection from instance B and you can run queries for that table from instance A into B?

But as I checked the doc, it says that SQL gateways is a way to just import data from an instance to another?

Thanks

Hi developers!

As a follow-up to my previous post on the Node.js Native API, I created a quick poll because it may be interesting to see what technologies developers are using in their applications around the world with IRIS & Caché. I put a poll below, just check all boxes you have used or plan to use with InterSystems technology.

Thank you all for your cooperation!

I would like to access discarded messages from a specfic process, is there any method that allows for this?

Alternatively what table holds this info so I can query it?

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in October 2022:

Hi,

I have installed Visual Studio on my PC and connecting to IRIS on my Linux server.

I have installed the InterSystems extensions.

I click on the InterSystems icon on left->Click on "Choose Server and Namespace" -> Pick my server myTrak.

However I get this error:
request to https://mytrak:52773/api/atelier/ failed,
 reason: write EPROTO 18648712:error:100000f7:SSL routines:OPENSSL_internal: WRONG_VERSION_NUMBER:../../third_party/boringssl/src/ssl/tls_record.cc:242:

Does anyone know how to fix this?

----

Visual Studio 1.69.2
Extensions
==========
InterSystems Language Server 2.1.3
InterSystems

Hello DC Members,

Please welcome the new video on InterSystems Developers YouTube:

⏯ Ten Times Faster Queries with Columnar Storage @ Global Summit 2022

HealthShare Patient Index November 29-December 1, 2022   9:00am-5:00 US-Eastern Time (EST)

• This 3-day course teaches the installation, configuration, and use of HealthShare Patient Index.
• Day one focuses on patient identification issues, and the tools that can be used for reviewing records identified by the system for human attention.
• This session is appropriate for both technical staff and administrative staff who manage patient identification issues.

Building and Managing HL7 Integrations November 28-December 2, 2022   9:00am-5:00 US-Eastern Time (EST)

• This healthcare-focused five-day course teaches implementation partners, integrators and analysts how to rapidly build HL7 integration solutions.
• Students build a production that processes and routes HL7 messages.
• Students learn how to work with the pre-built HL7 business services, business processes and business operations to receive and send HL7 messages.
• Students also learn how to transform HL7 messages using graphical tools in the Management Portal.

Hi

Can anyone explain how to display custom icons in a TablePane?

Andy

Recently there was an internal email thread on which SMTP server to use in demos. I thought I'd share the comments from that thread:

• Person 1: I tried gmail  (smtp.gmail.com, port 465) this morning, it works fine.
  To use gmail, you must enable 2-step verification for your google account and generate App password. https://support.google.com/mail/answer/185833?hl=en

• Person 2:  I use https://www.hmailserver.com 

• Person 3: I, too, use hMailServer as a local SMTP server on my demo VMs, with a mail client (usually Outlook) also on the VM.So no need to connect out to an SMTP server on the Internet.

Can you get a boolean response in the same way you can with a Business component using ##class(Ens.Director).IsItemEnabled(component).

Or even use this method for getting the adapter state?

Hi Guys,

I've a task scheduler that is stuck in Running is there a way for force stopping it?

Thanks

Hi Community:

Thought you might be interested in this new partner we just signed in Sydney -- PainChek® Ltd , the Australian-based developer of the world’s first pain assessment and monitoring application for smartphones. Its software-as-a-service, artificial intelligence platform uses smart devices with cameras to accurately evaluate pain levels. 

PainChek is using InterSystems IRIS for Health™ and integrating its application with electronic medical record (EMR) systems – including InterSystems TrakCare®.

In Australia, New Zealand, the United Kingdom, and Singapore, PainChek’s application is

How do I create recursive classmethod which stop all methods from running when condition are meet?

ClassMethod workpieceUnit(mainArticle As%String, article As%String) As%String
{
	
	&SQL(SELECT unit->unitCode INTO :unitCode FROM production_article.composition WHERE mainArticle = :mainArticle AND article = :article)
	
	IF SQLCODE = 0
	{
		W !, "Has Value"QUIT unitCode
	}
	ELSE
	{
		SET sql = "SELECT article, unit->unitCode,  production_article.composition_sqlArticleCode(article, type) AS articleCode FROM production_article.composition WHERE mainArticle = "_mainArticle_" AND

Hi Community,

I am working on sending Gmail with error details when any errors occurs in the ensemble production.

I am facing the below issues while doing it

1.I have Ens.Alert (Business process) using the class Ens.Alerting.AlertManager and Emailoperation (Business operation) using the class EnsLib.EMail.AlertOperation. here my business process is not sending the Alarm request to business operation eventhough i am using rule to connect the business operation 

2.What are SMTP server details needs to given for Gmail?

Please let me know how to resolve these issues

Thanks,
Smythee

Hi,

I want to know how to add a class to IRIS namespace 'USER' using terminal.

How do I do this?

I know you can add this class using Visual Studio Code with the Intersystems extension installed on my PC and connected to an IRIS instance.

Is it possible to do this with terminal? From this prompt:
BASETC:USER>

I have a class like in this example:

Class ObjectScript.RightTriangle
{

/// Compute area and hypotenuse of a right triangle
ClassMethod Main()
{
    write !, "Compute the area and hypotenuse of a right triangle",
          !, "given the lengths of its two sides."
    ....
}
}

Hi Team,

How InterSystems cache calculate the license count based on process?

How to we determine the product required license count ?

Thanks

Rathinakumar

Hi, I have a laptop with a Core i5 processor, a workstation with AMD Athlon 3000G processor, and another workstation with AMD Ryzen 3900 onboard. I was succeded to install IRIS Health community on the laptop. On both AMD workstations the install process hangs. I've waited for 8 hours but with no avail. What could be wrong with AMD?

This is not an issue in ObjectScript, due to its typeless nature. But it's essential for external programming languages that care a bit more about types of variables.

And in any case, it's still reproducible in ObjectScript. I have table

CREATETABLE some_table (
        idINTEGERNOTNULL, 
        x INTEGER, 
        y INTEGER, 
        z VARCHAR(50), 
        PRIMARY KEY (id)
)

And data

INSERTINTO some_table (id, x, y, z) VALUES (1, 1, 2, 'z1');
INSERTINTO some_table (id, x, y, z) VALUES (2, 2, 3, 'z2');
INSERTINTO some_table (id, x, y, z) VALUES (3, 3, 4, 'z3');
INSERTINTO some_table (id, x, y, z) VALUES (4, 4, 5, 'z4');