InterSystems IRIS Cloud SQL is a fully managed cloud service that brings the power of InterSystems IRIS relational database capabilities used by thousands of enterprise customers to a broad audience of application developers and data professionals. InterSystems IRIS Cloud IntegratedML is an option to this database-as-a-service that offers easy access to powerful Automated Machine Learning capabilities in a SQL-native form, through a set of simple SQL commands that can easily be embedded in application code to augment them with ML models that run close to the data.

Today, we announce the Developer Access Program for these two offerings. Application developers can now self-register for the service, create deployments and start building composable applications and smart data services, with all provisioning, configuration and administration taken care of by the service.

Hi community,

I would like to know how to know which users did patient searches on clinical viewer.

I tried checking the audit database but I cannot seem to know if it's logged there and under which event.

Please advise how to go about this.

Regards,

Ephraim Malane

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

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

🥇 @YURI MARX GOMES, Software Architect, YM Services, Braz

🥈 @Prashanth Ponugoti, Technical Architect, Optimus IT Infra Ltd, London, United Kingdom

🥉 @Djeniffer Greffin, Soluctions Architect, Sabin Medicina Diagnóstica, Brazil

Learn more about the competition and our awesome winners below.

I have an SDA feed from an Edge server that eventually is fed into HSHI / Analytics. This edge server is loading up patient demographics (in the Patient object), which feeds the HSAA.Patient table in HSHI / Analytics.

However, we have other edge servers also feeding into the same HSHI database, and these other edge servers have better demographic information.

I have a Read-Only Reporting Async with a Remote Database defined to a non-mirrored database on the primary failover member. I would like to update the non-mirrored database on the primary from the async; so far all my attempts fail with *protect* errors.

I found this page

https://community.intersystems.com/post/execute-method-failover-member-m...

I've got a class that extends FTP.PassthroughService and utilizes the FTP.InboundAdapter. In Business Service, I have the FilePath set as /tmp and the subdirectory level = 1. How can I access the current file path (/tmp/subdir1) when there are files in /tmp/subdir1/test.txt for example? The ..Adapter.FilePath only returns the FilePath setting in the Business Service/Adapter but not the subdirectory level. Of note, it is a SFTP connection. I can access the %Net.SSH.SFTP from

the file being created on the FTP server will have a format that includes the current date I would like to pull this file off the FTP while ignoring other files on the same location.

Inbound Service Class

I would like to find the file on the FTP that is being created using Todays date. But it appears that the wildcard are not recognizing the file format:

Hi,

This is available on github and wairing for approval on the Open Exchange.

It allows you to

I have a batch and would like to see the records in it on a terminal

First will use .%OpenId(Id) then will want to get the first record something around GetAT(1) with this I get the object reference but will actual need to see the data any help

Hi, Community!

Over 600 different authors posted anything on Developer Community in 2016.

Developer Community contains some brilliant pieces of content because of you. Thank you!

With one of the latest DC releases we introduced "Member Follow" functionality, so you can open any members' page, follow him and be subscribed to all his new posts and comments.

Just to give you ideas who to follow in 2017 here is top 10 authors in 2016 for several nominations ;)

All the nominations do not include postings within Developer Community tag or group.

Hi -

If you have Cache installed on a Cent OS machine, and you want to switch the OS to Red Hat 7, and your Caché is installed on a non-OS drive, do you need to reinstall Caché?

I don't think so, but I wanted to check

As we keep updating our software, we often realize that we require more and more modern solutions. So far, only one major piece of our software relies on reading barcodes in documents and images. Since Cache did not have a means of reading barcodes in the past, we have always achieved our goals by using a Visual Basic 6 application. However, it is no longer an ideal solution because it is currently complicated to maintain it. IRIS also lacks this capability, but it has recently got an option that makes up for it: embedded Python!

In this article, we will analyze the intricacies of setting up tables and graphs to improve the readability of data.

Logi offers a rich set of data visualization tools. You can find anything from a wide variety of chart templates to custom CSS styles. Understanding the assortment of settings and options can be quite difficult. First, we will create a chart and a table with default settings, and give them a presentable look using InterSystems Reports (powered by Logi Report).

Hello

We have a solution with an EnsLib.EMail.InboundAdapter as services that scan a mailbox on incoming mail with attachments.

When a new email arrives, the service sends the request (with a property %Net.MailMessage) to the process. In the process, we try to loop through and retrieve part 2 which we assume is the file.

set Part = pRequest.Mail.Parts.GetAt (2)

We can read out the file name:
Set FileName = Part.FileName

But how, and is it possible, to save the attached file to disk drive?