How I can get current date/time on format YYYYMMDDhhmmss?

I tried $ZDATETIME($HOROLOG,8), but I got 20220606 17:59:56 and I want 20220606175956

Thanks

Hi guys,

A client want to programmatically list all namespaces and whether they are interoperability or not. Do we have apis or sql to do that? Thanks.

I've tried several methods of %SYS.Namespace but did not find it yet. Also when I use sql to select from %SYS.Namespace through jdbc, it always return an empty result set.

Hi there,

I'm passing a JSON object to the server as such:

{"key":"value","key":"value","key":"value"}

From the client:

- Build object

object=JSON.stringify(object)

-pass to server side method as %String

On the server:

s object={}.FromJSON(object)

Instead of getting something like

object=<OBJECT REFERENCE>[2@%Library.DynamicObject]

I get

object="991@%Library.DynamicObject"

I can't access that object using %Get as if says invalid OREF.

I've set the object passed a string to a global and debugged a bit on command line and was successfully able to convert to a dynamic object and use the %Get method to get the

Hi developers!

Here is the score of technical bonuses for participants' applications in the InterSystems Grand Prix 2022 programming Contest!

Hey Developers,

Let the voting week begin! It's time to cast your votes for the best applications in the Grand Prix Programming Contest!

🔥 You decide: VOTE HERE 🔥

     
How to vote? Details below.

IRIS Megazord

In the first article about IRIS Megazord, Henrique explains what drove us to create such an application. It basic is a composition of these previous project which we did:

• History Monitor
• Message Viewer
• ZPM Explorer

But we also started the development of a new feature, called Flow Editor. In this article we are going to know more about it.

IRIS Flow Editor

The aim of this feature is to test a new way to create IRIS Interoperability productions, as Henrique explained in the previous article.

In this way, users are presented to a graphical editor in which they can express information

It is very interesting to compare different BI technologies. It is curious to me what the differences are in functionality, development tools, speed and usability.

For this application, I chose a dataset with water conditions in various European countries. This is an open source dataset containing observational data from 1991 to 2017.

The team and I decided to make a model based on this BI dataset using IRIS BI, Tableau, PowerBI and InterSystems Reports (powered by Logi Reports).

For the frontend, we made a web interface in PythonFlask via Embedded Python.

The result, by the way, can be seen on

About the job

The ideal candidate will be responsible for conceptualizing and executing clear, quality code to develop the best software. You will test your code, identify errors, and iterate to ensure quality code. You will also support our customers and partners by troubleshooting any of their software issues.

Responsibilities

• Detect and troubleshoot software issues
• Write clear quality code for software and applications and perform test reviews
• Develop, implement, and test APIs
• Provide input on software development projects

Application at yann.decambourg@synodis.fr  - www.synodis.fr

Qual

Thanks to @Yuri Marx we have seen a very nice example for DB migration from Postgres to IRIS.
My personal problem is the use of DBeaver as a migration tool.
Especially as one of the strengths of IRIS ( and also Caché) before is the availability of the
SQLgateways that allow access to any external Db as long as for them an access usinig 
JDBC or ODBC is available. So I extended the package to demonstrate this.

Hey Community,

Exciting results from a massive workload to test InterSystems API. We'll describe how we're trying to push the boundaries of the current technology in the public cloud:

⏯ Running Large-Scale Rest API in the Cloud

Hi Guys,

So I've been following this guide in using a %Library.ResultSet with a  ClassName / QueryName as described in the first example.

https://docs.intersystems.com/irislatest/csp/documatic/%25CSP.Documatic…

The code I've got so far doesn't work and is as follows:

set rs=##class(%ResultSet).%New()
set rs.ClassName="GMECC.DocmanConnect.Tables.vwNewGPs"set rs.QueryName="GetRows"set sc=rs.Execute("a")  If$$$ISERR(sc) Do DisplayError^%apiOBJ(sc) Quitwhile rs.%Next() { do rs.%Print() }		

And the referenced class is

Class GMECC.DocmanConnect.Tab

Maternal Risk can be measured from some parameters well known to the medical community. In this way, in order to help the medical community and computerized systems, especially AI, the scientist Yasir Hussein Shakir published a very useful dataset for training ML algorithms in the detection/prediction of Maternal Risk. This publication can be found on the largest and best known data repository for ML, Kaggle at https://www.kaggle.com/code/yasserhessein/classification-maternal-healt….

About the Dataset

Many pregnant women die from pregnancy issues as a result of a lack of

I have been developing this project for many years. He helps me a lot in my daily work as a DBA and full stack developer. This project has grown into a platform on which many of my other projects are based. You can read more about the project in the article. And I proposed this project for the contest, maybe it will be useful to you.

A few months ago, Jose and I were discussing the article Video Smart Data Services (Vision & Demo) from @Amir Samary and during that discussion, we started wondering what kind of feature would be nice to have on a future IRIS solution. 

One of the desired features is to have an IRIS iPaaS solution as I questioned here in this comment.

These last months gave me the opportunity to work with different projects and technologies, and put me in touch with applications like Tray.io or Workato, and now I can see how great an IRIS iPaaS solution could be.

IRIS Interoperability has much potential, an

Kidney Disease can be discovered from some parameters well known to the medical community. In this way, in order to help the medical community and computerized systems, especially AI, the scientist Akshay Singh published a very useful dataset for training ML algorithms in the detection/prediction of kidney disease. This publication can be found on the largest and best known data repository for ML, Kaggle at https://www.kaggle.com/datasets/akshayksingh/kidney-disease-dataset.

About the Dataset

The kidney disease dataset has the following metadata information (source:

I think each of us has on the computer directories with photo files of relatives and friends, music albums of favorite bands and singers, as well as e-book libraries. I also have them, and I came up with the idea to implement a convenient interface for these files. You can read more about the project in the article. And I proposed this project for the contest, maybe it will be useful to you.

Hi, what’s the best way to check if your query return 0 records?

If$$$ISOK(sc) 	
    		{
   	   		 	Set tResult = sqlStatement.%Execute()
   	    
    			WHILE tResult.%Next()
    			{
					set tRecords = tResult.%ROWCOUNT
   		        }

				if (tRecords = "")
				{
					write"no records" 
				}
			}

Hi Community,

Recently, I migrated a series of Objectscript repositories from XML to UDL format.
After the migration, I was a bit disappointed by the presentation on the GitLab web interface.

Since Objectscript syntax is supported by GitHub, I thought It would be also supported by GitLab. Unfortunately, the library used by GitLab to highlight the code does not have an extension to support Objectscript.

GitLab uses the library Rouge, which can highlight over 200 languages. This is a library written in Ruby (see the GitHub page), but Objectscript is not in the list.
So, I decided to develop an

Hi developers!

What is the easy way to know what are the images available at containers.intersystems.com?

Diabetes can be discovered from some parameters well known to the medical community. In this way, in order to help the medical community and computerized systems, especially AI, the National Institute of Diabetes and Digestive and Kidney Diseases published a very useful dataset for training ML algorithms in the detection/prediction of diabetes. This publication can be found on the largest and best known data repository for ML, Kaggle at https://www.kaggle.com/datasets/mathchi/diabetes-data-set.

The diabetes dataset has the following metadata information (source:

IRIS Interoperability formerly known as Ensemble comes with many built in adapters. It does not have a service or adapter to receive mail. I have written email service to receive mail messages via SMTP which can be passed to email operation.

Now I want to load-test a production which sends messages to an external mail server using email operation. The mail server team does not want me to send them thousands of messages.

I created iris-mail app to have a substitute mail server.I updated the server and port settings in the email operation.

My team works on an IRIS interoperability solution which is running on Red Hat OpenShift container platform. I want to test how many messages can be processed by the running webgateway pods and compute pods with data being stored in the mirrored data pods.

In order to push IRIS out of its comfort zone, I deployed multiple feeder containers and scheduled tasks on each feeder to send a load of messages at the same time.To get to the next level of testing, I want to have multiple types of test files available on demand.

The annual competition for InterSystems IRIS developers is coming! 

We're super excited to invite you all to join the Grand Prix contest for building open-source solutions using InterSystems IRIS data platform! 

New developers are welcome to join --> create an account now.

🏆 InterSystems Grand Prix Programming Contest 🏆

In prizes: more than $22,000

Contest running: May 9 - 29, 2022

Voting period: May 30 - June 5, 2022

Hey Developers, 

Join us as we share lessons learned from standing up the initial InterSystems cloud offerings. We'll cover the challenges of standing up a SaaS and how to meet them:

⏯ Running InterSystems IRIS Workloads in the Cloud: Lessons Learned

Hi Developers!

This is yet another short post that is intended to simplify developers' life. Now we'll talk about how to make GitHub run unit tests with every push to the repository by adding just one file to the repo. For free.  On Github Cloud. Sounds great, isn't it?

It is possible and very easy to do. Credit goes to @Dmitry Maslennikov (and his repo), ZPM Package Manager, and GitHub Actions.  Let's see how this all works!

There is a popular package "WebTerminal". It is excellent in most situations.
Except:

• running system commands in your operating shell is not so easy
• as it communicates to the IRIS host over HTTP and WSS it consumes 2 connections
  • With only 5 connections in the community license (and the "Grace Period of CSP")
  • you can hit the limits rater fast: 2 Webterminals + 1 SMP and you are done
• WebCommand is a pure CSP page consuming just 1 single connection
• WebCommand allows multiple ObjectScript command lines running in sequence
• With $ or ! your command goes to Operating System same as with

One of the crucial business dimensions is the dimension “Where”.It is necessary to know where a customer was born or where he lives.Where will the order be delivered?Where have there been more sales, and where can we sell more?Where are our stores located?From Where is the customer accessing our e-commerce?These and other principal questions use the “Where” dimension.Today the best service to provide geographic accuracy and quality for these data is Google Maps.

Hi Community,

We're pleased to invite you to the upcoming webinar in Spanish called "SAM: Monitoring InterSystems IRIS with Grafana and Prometheus".

Date & Time: June 15, 4:00 PM CEST

Speaker: @Pierre-Yves Duquesnoy, Sales Engineer, InterSystems Iberia

How do I use ANSI escape codes to produce green text in InterSystems IRIS terminal?