Hi all, 

any news about support of the IRIS platform in the DBeaver?  I only found this  https://github.com/dbeaver/dbeaver/issues/6289  Github issue. They are waiting for a new version of the JDBC driver. 

Thanks for the answer

Hey Developers,

We're pleased to invite you to the upcoming InterSystems webinar called "What's New in InterSystems IRIS 2022.1"! 

Date: Tuesday, May 24, 2022
Time: 11:00 AM EDT

In this webinar, we’ll highlight some of the new capabilities of InterSystems IRIS and InterSystems IRIS for Health, including:

An anagram is a word or phrase formed by rearranging the letters of a different word or phrase, typically using all the original letters exactly once. For example, the word anagram itself can be rearranged into nag a ram, also the word binary into brainy and the word adobe into abode. Wikipedia

You will receive two strings returning true if the two arguments given are anagrams of each other. As usual shortest solution wins.

Hey Community, 

This session provides more detail about the Smart Data Fabric announcement at #VSummit'21: 

⏯ Introducing the Smart Data Fabric

We are experience this with our own web app and even the demo/template here: intersystems-community/iris-fullstack-template: This template shows you how to build, test and deploy a simple full-stack application using InterSystems IRIS REST API (github.com)

When changes are made to CSS or HTML files, we can see the changes are saved to file in the Docker container by visiting the command line.  However, after refreshing, clearing cache, etc. the changes don't appear on the web application in the browser.  Viewing the source css in the browser, we see it's the old file.

1. Fhir-client-java

This is a simple fhir client in java to practice with fhir resources and CRUD requests to a fhir server.
Note that for the most part auto-completion is activated.

GitHub

• 1. Fhir-client-java
• 2. Prerequisites
• 3. Installation
  • 3.1. Installation for development
  • 3.2. Management Portal and VSCode
  • 3.3. Having the folder open inside the container
• 4. FHIR server
• 5. Walkthrough
  • 5.1. Part 1
  • 5.2. Part 2
  • 5.3. Part 3
  • 5.4. Part 4
  • 5.5. Conclusion of the walkthrough
• 6. How to start coding
• 7. What's inside the repo
  • 7.1. Dockerfile
  • 7.2. .vscode/settings.json
  • 7.3. .vscode/launch.json

2.

1. Fhir-client-net

This is a simple fhir client in c# to practice with fhir resources and CRUD requests to a fhir server.
Note that for the most part auto-completion is activated.

GitHub

• 1. Fhir-client-net
• 2. Prerequisites
• 3. Installation
  • 3.1. Installation for development
  • 3.2. Management Portal and VSCode
  • 3.3. Having the folder open inside the container
• 4. FHIR server
• 5. Walkthrough
  • 5.1. Part 1
  • 5.2. Part 2
  • 5.3. Part 3
  • 5.4. Part 4
  • 5.5. Conclusion of the walkthrough
• 7. How to start coding
• 8. What's inside the repo
  • 8.1. Dockerfile
  • 8.2. .vscode/settings.json
  • 8.3. .vscode/launch.json

2.

Format Change in the ^mtemp and ^ERRORS Globals

InterSystems has several routines, methods and utilities that can create stack dumps.  Stack dumps are created in the ^mtemp(index) global by the %SYS.ProcessQuery:ExamStackByPid(.) classmethod as well as by some undocumented legacy entry points of the ^%STACK utility.  Stack dumps can also be created in the ^ERRORS(date,index) global by the ^%ETN trap routine, including additional entry points BACK^%ETN, LOG^%ETN, ^%ET and the Log() method of exception objects.

From  IRIS log, I found lots of following content

05/05/22-01:05:11:375 (16166) 0 [Generic.Event] ECP: Mirror Connection request from 'SM25SDLMIIRROR:LOCALHOST.LOCALDOMAIN:IRIS' (10.xxx.xxx.27:33040)

05/05/22-01:05:11:376 (16166) 1 [Generic.Event] ECP: Active server not defined, cannot redirect mirror connection

Could any one explain a little bit for me?

Hi Community,

The InterSystems Learning Website has many important iterative courses. So if you want to learn about InterSystems and start to work with InterSystems this is the path:

Overview:

• Resources and hands-on path for mastering source coding with the InterSystems IRIS: https://gettingstarted.intersystems.com
• Introduction to InterSystems Products and Technologies: https://learning.intersystems.com/course/view.php?id=1168&ssoPass=1

Fundamentals:

• InterSystems ObjectScript Basics: https://learning.intersystems.com/course/view.php?

This is a benchmark built in python and objectscript in InterSystems IRIS.

The objective is to compare the speed for sending back and forth a thousand request/message from a BP to a BO in python and in objectscript.

See https://github.com/LucasEnard/benchmark-python-objectscript for more information.

IMPORTANT : Here are the results of time in seconds, for sending 1000 messages back and forth from a bp to a bo using python, graph objectscript and objectscript.

String messages are composed of ten string variables.

Hi Community,

We're pleased to invite all the developers to the upcoming InterSystems Grand Prix Contest 2022 kick-off webinar!

We'll share the details of our mega Grand Prix Contest 2022 and describe how you can win up to $22,000 in prizes! Unlike our other InterSystems Developer Community contests, this contest allows you to use any element of our data platform - IntegratedML, Native API, multi-model, Analytics and NLP, Open API and Interoperability, IKO, etc - in your project.

In this webinar, we'll talk about the topics to expect from participants and show you how to develop, build and deploy applications on InterSystems IRIS data platform.

Date & Time: Monday, May 9 – 11:00 AM EDT

Speakers:  
🗣 ​​​@Alex Woodhead, InterSystems Technical Specialist
🗣 ​​​@Bob Kuszewski, InterSystems Product Manager
🗣 @Jeff Fried, InterSystems Director of Product Management
🗣 ​​​@Dean Andrews, InterSystems Head of Developer Relations
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

Hi Community, 

See how you can develop in Python and connect to InterSystems IRIS® data platform with PyODBC and the Native API: 

⏯ Using Python to Connect to InterSystems IRIS

Hey Developers, 

See how you can get high-performance relational access using SQL to manage data within your InterSystems products: 

⏯ Using SQL with InterSystems IRIS

Hi folks!

Sometimes we need to import data into InterSystems IRIS from CSV. It can be done e.g. via csvgen tool that generates a class and imports all the data into it.

But what if you already have your own class and want to import data from CSV into your existing table?

There are numerous ways to do that but you can use csvgen (or csvgen-ui) again! I prepared and and example and happy to share. Here we go!

Hi developers!

InterSystems Grand Prix unites all the key features of InterSystems data platforms!

Thus we invite you to use the following features and collect additional technical bonuses that will help you to win the prize!

Here we go!

• InterSystems FHIR  - 5
• IntegratedML - 4
• Native API - 3
• Interoperability - 3
• Production EXtension(PEX) - 4
• Embedded Python - 5
• Adaptive Analytics (AtScale) Cubes usage - 4
• Tableau, PowerBI, Logi usage - 3
• InterSystems IRIS BI - 3 
• Docker container usage - 2 
• ZPM Package deployment - 2
• Online Demo - 2
• Unit Testing - 2
• First Article on Developer Community - 2
• Second Article On DC - 1
• Code Quality pass - 1
• Video on YouTube - 3

Recently our team have been getting requests to pickup a large amount of data from API nightly (e.g. using ODATA to loop through pages) and placing that into MS SQL databases.

My question is, what is considered the best practice to get data from API and route to external SQL database WITHOUT persisting any messages/traces etc?

At the moment my thinking would be to write a service that triggers an action once a day to an EnsLib.HTTP.OutboundAdapter, then map the HTTP response into a linked table (via method to keep the operation clean that managed the gateway on the way in and out of the method).

What it the best method to call an object without ID but having RowID

SET task.Title = ##class(RESTAPI.TITLE).%OpenId(obj.Title)

I have tried using %OpenId() but it returns null

Any help would be grateful thank you.

I am sure I came across this in the past with Cache and just saw this again in IRIS.

When rebuilding or swapping a DAT file for a database it retains the Resource of the DAT file, not the Resource of the Database it is being used for.

For instance, if I have a local Database called APP with a resource %DB_APP and I want to refresh the data from another Database called TEST that has a Resource %DB_TEST I can just copy the DAT file from the TEST folder to the APP folder.

No Database settings are changed and it is all done with either IRIS down or the databases dismounted.

Hi.

Is it possible to set in XData mappings (or any other way) to serialize the property value as display value rather than value it self?

Regards,
Matjaž

Hi

I have an a Ens.Request subclass (Invoice) that has a relationship property to another persistent class (InvoiceItems), with properties of its own and the inverse relationship defined referring back to Invoice. 

When building a DTL with these classes, the Relationship’s inverse relationship (Invoice, within InvoiceDetails) is displayed.   

Can this be hidden ? 

thanks

Given the following requirements about a WebSocket client:

• Start with the production automatically
• Try to re-establish a lost connection periodically
• Send an Ens.Request to another production item when a message is received from the WebSocket server

Where in the production does the WebSocket client need to live?

This year at Global Summit we will have several members of the InterSystems internal applications team (AppServices) on site to present topics of interest to developers.  There will be General Sessions that we teach on a number of topics related to tools we're launching to the OEX, knowledge gained based on migrating our Caché app portfolio to InterSystems IRIS, best practices for following OWASP Top 10 with ObjectScript, and a survey of the application landscape offering services to our customers and prospects.

Hi Community,

Imagine enabling your application to read text to your customer? This is now possible with the new IRIS feature, Embedded Python. With this new functionality IRIS can natively run any open source or commercial Python libraries natively. gTTS (https://pypi.org/project/gTTS/) is a free library that transforms text into audio using the Google Translate service.

How to

Just pass the text by parameter and gTTS returns an mp3 file with the text transformed into audio. That is, your application can play the audio of any text! See how to do it:

1. Go to https://openexchange.intersystems.

Given I have a property 

Class All.AllBooks Extends %Library.Persistent
{

Property ID As %Integer;

Property Title As User.Book;

}

In the class method

ClassMethod GetABookById(id As %Integer) As %Status
{

SET MyBooks = ##class(All.Allbooks).%OpenId(id)

SET obj = {

     "ID" : (MyBooks.%Id())

     "Title" : (MyBooks.Title)

}

WRITE obj.%ToJSON()

Quit 1
}

How do Access the foreign key in JSON() data

Hey Community, 

New video is already on InterSystems Developers YouTube channel:

⏯ Embed Business Intelligence into your Applications with InterSystems IRIS

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

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 1.1?

You’ll notice performance improvements for the Grafana dashboard graphs, especially when working with large data sets.  If you’re upgrading from SAM 1.

Hi.

I'm trying to serialize property of type %TimeStamp in SQL statement with JSON_OBJECT, but I get a raw string instead of JSON DateTime format string. %JSONExport method on the same object works fine.

Any ideas?

Regards,
Matjaž

Hello,

I tried to search the forums but couldn’t find an answer for my need.

I’m building a logging module in Ensemble which could be used to log information about different integrations triggered in our environments. In my first version, the logging module logs straight to messages.log, and it’s working fine for the time being. The logging module is used to log process level information related to integrations with different log levels (info, debug, warn, error, etc.).

Good afternoon,

I'm trying to take an unformatted social security number and insert the dashes into it.  I'm getting a value in PID-19 like this:  "123456789" and would like to use a data transformation to set the value in PID-19 to "123-45-6789". 

I can't find any insert or append functions and I can't find anything in the Intersystems doc repository that would do this.  Can someone help point the way for me please?  I would like to keep this as a "set" action in my DT.  I'm a little new to calling classes so it would be helpful if you included some syntax that would go in the "Value" field.