Hi,

I wonder if anyone could help me.

I'm used to writing Microsoft SQL database queries, but at the moment I am also trying to write reports on an IRIS database (used to be cache) in Microsoft BIDS.

My chief headache is parameters. They don't behave the "normal way" in BIDS, in that you can't rename them. Therefore, referencing them in the main code is a nightmare for me.

Say my report has two parameters. If i want to refer to both in a dataset, I have to list them in the order they are in the report and both by using a question mark, ie:

WHERE
column1 = ?

and column 2 = ?

Hi Community,

We are pleased to invite all the developers to the upcoming InterSystems Analytics Contest Kick-off Webinar! The topic of this webinar is dedicated to the Analytics contest.

On this webinar, we’ll demo AtScale, InterSystems Reports (Logi), IRIS BI, IRIS NLP and answer the questions on how to develop, build, and deploy Analytics applications using InterSystems IRIS.

Date & Time: Monday, August 23 — 10:00 AM EDT

Speakers:  
🗣 @Carmen Logue, InterSystems Product Manager - Analytics and AI
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

Team,

I am trying to use Visual studio code(1.57) for class development and for compiling classes (intersystems tools extension) . It works.

Now, i would like to use TFVC (Team Foundation Version Control) for source control.  

I can see download option where i can manually download the Namespace as folder and classes as files.

Since whenever i save the file, it directly pushes the change to remote system. I am not sure where the local workspace is.

How to configure VS Code to track my changes and Check In / Check out the code.

Data transformations can be changed in Management portal, but the modifications are not synced with visual studio code. Classes are synced from VSCode to Iris. VSCode can take care of the git repository.

I am curious to know how people are developing data transformations on Iris with VSCode? Are you editing the DT classes with VSCode and forget about the UI? Are you exporting from management portal the files to VSCode directory? Are you using a source control hook?

Thank you

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Visual Studio Code for ObjectScript: Server-Side Source Control

Hey Developers,

New video is already on InterSystems Developers YouTube:

⏯ Visual Studio Code for ObjectScript: Choosing an IDE/Source Code Combination

I want to try SAM in AWS. I followed these steps:

docker pull store/intersystems/sam:1.0.0.115

git clone intersystems-community/sam: System Alerting and Monitoring (SAM) (github.com)

git clone https://github.com/intersystems-community/sam

tar zpxvf sam-<version>.tar.gz

tar zpxvf sam-1.0.0.115-unix.tar.gz

$ cd sam-<version>

cd /home/ec2-user/git/sam/sam-1.0.0.115-unix/

$ ./start.sh

In your browser, visit:
http://<ip-address-of-host-where-SAM-runs>:8080/api/sam/app/index.csp
You'll be prompted to login. You can use standard InterSystems IRIS credentials like _SYSTEM/SYS.

So I've got the IRIS AMI spun up in AWS EC2; it seems to be running fine.  
I've added an EBS volume to it for persistent storage, and now I'm pondering how to make it actually do something useful.  

What's the best way to do deploy code to this instance?  I can think of a few ways to do it, but what's the least painful way?  Push my code to an S3 bucket and figure out how to load it at system start?  Github project?  

I have described my efforts to optimize IRIS Mirror deployment in AWS ElasticContainer Service (ECS) in my prior article.

IRIS Mirror in the cloud (AWS) | InterSystems Developer Community | AWS
 

I have come to the opinion that IRIS Mirror is not as reliable as needed when deployed in ECS. The root of the problem is the fact that ECS randomly assigns one of the available IP addresses to each EC2 host or Fargate task it starts.

These get stored in iris.cpf file in MapMirrors section as shown here:

[MapMirrors.IRISMIRROR]

FAILOVER1=10.2ab.1cd.146,2188,,10.2ab.1cd.

Hey everyone as you may know I am a beginner and I am kindly asking for some assistance in a problem I have been solving. The problem is that I am calling a user defined function within a procedure called occupiedseatsAdj and the compiler comes up with this error. 

From what I understand I can call a user defined function from within a procedure (correct me if I am wrong) as shown below. Is this the correct way or should I create a .Mac file and include it somewhere within the above mentioned cls file ?

I have been working on redesigning a Health Connect production which runs on a mirrored instance of Healthshare 2019. We were told to take advantage of containers. We got to work on IRIS 2020.1 and split the database part from the Interoperability part. We had the IRIS mirror running on EC2 instances and used containers to run IRIS interoperability application. Eventually we decided to run the data tier in containers as well. Later we switched from using EC2 instances to Fargate “server-less” compute.

The first installment of this article series discussed how to read a big chunk of data from the raw body of an HTTP POST method and save it to a database as a stream property of a class. The second installment discussed how to send files and their names wrapped in a JSON format. 

Now let’s look closer at the idea of sending large files in parts to the server. There are several approaches we can use to do this. This article discusses using the Transfer-Encoding header to indicate chunked transfer. The HTTP/1.1 specification introduced the Transfer-Encoding header, and the RFC 7230 section 4.1 described it, but it’s absent from the HTTP/2 specification. 

It's possible to enable Ctrl+C / Ctrl+V in IRIS Terminal for Windows.

To do that, open Terminal and select Edit > User Settings and enable Windows edit accelerators. This setting specifies whether the Terminal enables the common Windows edit shortcuts (Ctrl+C, Ctrl+V, Ctrl+Shift+V), in addition to the basic Terminal edit shortcuts (Ctrl+Insert and Shift+Insert).

After that Ctrl+C / Ctrl+V would work.

Also <SYNTAX> errors after incorrect copy/paste go away.

Docs.

Hi.

Does anyone have experience with JDBC connection from Android to IRIS?

Regards,

Matjaž

I'm wanting to write a query in SQL that will return a row with a count for each day for a given month or year for a specific operation or configname.  The following is a start but I'm not finding what I want in the documentation to parse out the TimeLogged field of the table.  Nay help is appreciated.

SELECT count(TimeLogged), ConfigName
FROM Ens_Util.Log
where TimeLogged like '2021-07%'
and ConfigName = 'operation_Name'
group by TimeLogged

Hi developers, 

We have just published an update to the Deltanji version control extension for Visual Studio Code.

When used in certain Deltanji workflows, triggering an automatic checkout on first keystroke could result in the developer working on an outdated copy of the code and only being notified of this later when saving their changes. In order to prevent this from happening checkout now reloads the document immediately. 

Error messaging has been improved in two areas - when attempting to cancel code that is not checked out, and when trying to register new code onto a withdraw system. 

We have also improved interoperability between the Deltanji extension and the InterSystems ObjectScript one, as well as its handling of multi-component objects.

If you're already a user of Deltanji then your extension with automatically update. You can find out more information on Deltanji and the latest release here. 

Hi, Is there a way to connect to a MYSQL ODBC? I tried using the SQL Connect class but getting an error.

Set conn=##class(%SQLGatewayConnection).%New()
Set sc=conn.Connect("databasename","username","password")

&sql(insert into ORDERS (column1, column2, column3, column4, column5) values(:value1,:value2,:value3,:value4,:value5))
s sc=res.Close()
Set sc=conn.Disconnect()

But I am getting an error :

Please can you advice how I can do this?

Alerts are automatic notifications triggered by specified events or thresholds being exceeded.

InterSystems Documentation

I have a Business Service connected to a machine with ~100 sensors. BS receives sensor values once a second.

Several conditions determine if a Business Serviceshould raise an alert (it's a list of: sensor id > threshold).

I have three questions:

1.  Should I write these conditions as a business rule and call this rule from the Business Service, and if the rule returns 1 call SendAlert? Or is there some other way to do that?

Introduction

This is a csvgen UI frontend in Angular 8. The aim of this project is to easily import csv file to Iris from a web ui.

Demo

Install with ZPM

It will automatically install the dependency of csvgen and sslclient

zpm "install csvgen-ui"

This will create two new endpoints :

• One for the Rest API for uploading files

• /api/{namespace}/csvgen/

• One for the UI

• /csp/{namespace}/csvgen/index.html

Stand alone demo on docker

Run the server

docker-compose up -d

UI

The UI is per-namespcae, this mean it will be available only for the namespace where csvgen-ui is install.

Hi Developers!

InterSystems IRIS online documentation is temporarily available here.

UPD: https://docs.intersystems.com/ is available.

Hi developers!

Do you know a CRM that is built with InterSystems IRIS or Caché or Ensemble on a backend?

Hi,

While starting newly created production I am getting below error:

17:14:05.498:Ens.Director: ERROR <Ens>ErrProductionSuspendedMismatch: Production 'Training.NewProduction' was suspended, a new production of a different name can not be started.

Please note that I  can start and stop 'Training.NewProduction' successfully but still the status of the Training.NewProduction'  is suspended.

Thanks

Continuing the description of work on the use of the openhl python module in productive mode.

Since the version of iris with Embedded Python, does not yet have a final release, it is already necessary to use it in production now. We decided to back up the service for exporting requests to a xlsx file on a separate server, and save the query result in a global in a separate database.

This database was made networked, local for the service server and remote for the product server. The communication between the prod server and the service was implemented using a rest service.

Hi All I am a beginner and I am learning Objectscript and I would appreciate a steer regarding a problem I am solving.

The issue I have spent some time on resolving without success is that I have the stream listed below and as you can see it has some gaps in it.

Stream

das
is
wp

dsa
nmk

Here is the import method

IF ##class(%File).Exists(dir) '=1 {
    write !, "Unable to Open: "_dir
    QUIT
} ELSE {
    write "File: "_dir_" is open"
}
// instantiate a new class called file
set file = ##class(%Stream.FileCharacter).%New()
// create a new variable called sc
set sc = file.

Being equipped by science and technology, human being have walked a long way by great inventions such as steam-engines or aeroplannes; while after decades, people gradually recognize that single creation could not lauch an industry-boom again. That is why and when, technologies grow up with a community, where are we now=P. An eco-system of technology would be born with the power of a system and grow up with the power of system-science, such as InterSystems, with which seated the letters "s-y-s-t-e-m". Graduated with M.S.

Hi developers!

How to build an analytics solution with InterSystems IRIS?

To begin with, let's agree on the points of what is the analytics solution - and this could be a very wide topic. Let's limit the set of solutions to those you can present in the Analytics contest.

There are three kinds of analytics solutions that we will review here: monitoring, interactive analytics, and reporting. 

Monitoring

The typical monitoring solution consists of an online dashboard with KPIs that are being actively updated.

The key use case is of monitoring is to visually observe the KPI of fresh data every moment to react in case of an emergency.

Interactive Analytics

This solution supposes a set of interactive dashboards with filters and drill-downs.

The key use case is to explore the data with filters and drill-downs making business decisions upon graph and table data visualization.

Reporting

Reporting solution provides a set of static (usually) reports in a form of HTML or pdf documents that deliver the data in graph and text form in a predesigned form and could be sent via email.

The typical use case of a reporting system is to obtain reports on a given period that will illustrate the status of the product, process, service, sales, etc that is crucial for the business.

How InterSystems products could be used to build such solutions? Let's discuss this below!

Hi Community, 

See a demonstration of InterSystems IRIS Adaptive Analytics and get a detailed description of this new offering for analytics end-users:

⏯ Demonstration: Adaptive Analytics in InterSystems IRIS

Hi!

I'd like to know if the VALIDATE MODEL statement in IntegratedML performs a cross validation (CV) procedure internally. If it doesn't, is there a ready to use method for CV?

Thanks!

Hey Developers,

Watch the new video on InterSystems Developers YouTube:

⏯ Adaptive Analytics in InterSystems IRIS

Hi community,

This is another article about how to perform actions that you can do in the web portal but via code.

Today.... Add a default setting value by code