This is the third article in our short series around innovations in IRIS SQL that deliver a more adaptive, high-performance experience for analysts and applications querying relational data on IRIS. It may be the last article in this series for 2021.2, but we have several more enhancements lined up in this area. In this article, we'll dig a little deeper into additional table statistics we're starting to gather in this release: Histograms

I am working in Intersystems Healthshare product.

I want to clear the message logs from a particular interface (Service,process,operation).

In intersystems we have the option to purge the data for all interfaces for the corresponding time but I want to clear the data logs for particular interface only.

Please let me know how to approach this scenario.

Hey everyone,

Need to change your PRIMARY email address (login email) and not lose all your activity on the Developer Ecosystem resources: Community, Global Masters, and Open Exchange?

It's easy! We will take care!

1️⃣ We will correctly transfer all your information from the old DC account to the new one.

All your posts, comments, mentions, likes, etc. will be saved on the new account.

Do you know if any InterSystems product is compromised due to the Log4j vulnerability?

Hi members,

I have these data :

and need to exploit the first character of cot field (Library CDU classification) like this :

I get this result... it's approximatively what I want... but I need it in just one line !

With mySQL I get it with just GROUP BY rcddate

Hey InterSystems Community,

I noticed something interesting in regards to business rule editing. Whenever you use the Management Portal or Studio to edit a business rule, the " characters gets escaped to a ".

Which results in the following code:

Hello programmers I would like to build a simple app where I could register data from a user like a name, age, and the phone just to practice, but for that, I would like to build the frontend and backend and also I need to be able to insert, update and delete information.
Does anyone have any recommendations for me on how I could do that using Intersystems IRIS?

Server Manager 3.0 Preview, my entry for the InterSystems Security Contest, is now making use of a cool new feature of Visual Studio Code version 1.63 - support for pre-release extensions.

I've been accessing Cache tables from a developer/reporting side, but am now involved in a project to create a data warehouse for our application. I'm trying to find a query I can use to return the sizes of all the tables in the database, so we can identify the largest tables and handle those individually. Can someone give me a query I can run against our Cache database to return the sizes of all the tables from largest to smallest?

Thanks for the help

Using Prometheus to monitor Caché ，when config application /metrics done， Prometheus connection error: “server returned HTTP status 404 Not Found”

Hello, everyone,

I have the problem that when trying to connect to the SFTP server the error appears, the user and password are wrong. However, these are correctly stored under login data and I entered! SFTP in SSL Config. The connection works wonderfully with Filezilla. Anyone else has a tip for me?

greeting

Hello all,

First time post and newer to Cache/ObjectScript in general, please keep it in mind!

Newbie

I am currently running a docker image with Iris 2021.1 and I would like to install node js on to it. I have had a look at the instructions on the intersystems online learning portal and I must say its very confusing. Some of the documentation says that you can only install it on 2019. Other parts say that it doesn't matter and you can install it if you have a dev directory. I checked my dev directory and there it isn't there. Sadly this is very inconsistent. Does anyone know if it is possible to install on the above mentioned version of Iris ?

Hey Developers,

We're pleased to invite you to the upcoming "Backup. From Dusk till Dawn" webinar by InterSystems Russia on December 15 at 10:00 (UTC+3, Moscow time)!