Announcement Evgenia Kurbanova · Dec 8, 2021

Hi Developers, 

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

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

🥇 @Robert Cemperex Senior Sales Engineer from InterSystems, Austria

🥈@Oliver WilmsIntegration Engineer, Take2 Consulting, USA  

🥉 @Mary GeorgeTeam Lead, Barts Health NHS Trust UK 

 

Learn more about the competition and our awesome winners below.

6
0 409
Announcement Anastasia Dyubaylo · Dec 28, 2021

Hey Developers,

Thanks to everyone for participating in the Advent of Code 2021and coding in InterSystems ObjectScript! We're pleased to introduce the winners and distribute all the prizes! 

Big applause goes to these developers: 

   @Kevin An (w/ repo)

   @Yuval Golan (w/ repo)

   @Oliver Wilms (w/ repo)

We'd also like to reward another developer who conquered Embedded Python and made all 25 challenges on it. Please welcome:

   @Robert Cemper (w/ repo)

6
0 435
Discussion Evgeny Shvarov · Dec 28, 2021

Hi developers!

We launched the datasets contest.

And one of the important questions that need to be covered is dataset licensing.

There are two general cases:

a) a dataset you take from another place in public Internet or private network/person.

b) a dataset you create by yourself or own for any other reason.

We decided to follow the principles and considerations that data.world site introduces for datasets' licensing.

2
0 321
Question Ephraim Malane · Dec 23, 2021

Hi all

We are looking into automating worklist report SQL queries that we run manually on InterSystems IRIS platform but we would like to have them run on a Java application.

This means we must have a way to get our java application to talk to IRIS in order for those queries to run. Please advise on how to go about this?

Regards,

Ephraim Malane

3
0 314
Question Craig Clifford · Mar 4, 2021

We have an interface that need to be disabled then re-enabled when it starts to queue up. I wrote the following code to do this functionality in a process. This works in our development domain, but in production it says it fails to disable the job - it only shuts down the interface without updating the production/starting the interface back up. Error message: "Failed to stop job '36831290' within 60 seconds. Status '<unknown>" 

Is there something wrong with how I'm trying to do this? 

set tSC = ##class(Ens.Director).EnableConfigItem(itemname,0,0) 

set tSC =

3
0 411
Question Cristiane Ferreira Mello · Dec 23, 2021

I need to send the data from a view that returned NULL, but is going as empty. The fields are of type String.

I'm using: 

SET tSC  = ##Class(%ZEN.Auxiliary.jsonProvider).%WriteJSONStreamFromObject(.tSteamJson,pObj,,,,"e")
{
    "altura": "",
    "atendimento_id": "3060382",
    "data_atualizacao": "2021-12-16 10:39:12.0",
    "data_coleta": "2021-12-16 10:37:00.0",
    "data_liberacao": "2021-12-16 10:39:12.0",
    "dor": "1",
    "dor_nr_seq_result": "",
    "escala_dor": "",
    "escala_temp": "C",
    "freq_cardiaca": "80",
    "freq_respiratoria": "22",
    "glicemia_capilar":
9
0 2056
Article Sylvain Guilbaud · Oct 6, 2016 3m read

to dismount/mount a database, use Dismount() and Mount() methods in SYS.Database class available in %SYS namespace.
NB: the database ID is its Directory

You'll find  some examples of how to dismount/mount and check if a database is mounted (Mounted=1) or not (Mounted=0), and quickly see all the attributes of a database (via zwrite)


%SYS>set db="/opt/irisapp/data" 

%SYS>w ##class(SYS.Database).%OpenId(db).Mounted                     
1
%SYS>w ##class(SYS.Database).%OpenId(db).Dismount()
1
%SYS>w ##class(SYS.Database).%OpenId(db).Mounted   
0
%SYS>w
2
1 2907
Question Maxim Berezkin · Dec 24, 2021

Hello!

I send request: 

set hr=##class(%Net.HttpRequest).%New()
set hr.Server = "server.com"
set hr.Location = "method?param=value"
do hr.EntityBody.Write("{ "name": "value" }")
set tSC=hr.Send("POST")
But when request incoming to server.com URI = "method
%3Fparam%3Dvalue".
How I can 
disable urlencode params in URI, so that the URI remains "method?param=value"?

7
0 853
Article Oliver Wilms · Dec 24, 2021 4m read

One of my colleagues had developed an interface in Health Connect (HealthShare 2019.1) to add large amounts of data to an external SQL Server database.The data comes from many text files with delimited rows and data for one table per file.There is a business process to read a file line by line and send an Insert Request to an operation.The request contains an Insert statement like ‘Insert into TABLE columns (col1, col2, … colZ) values (val1, val2, … valZ).’ The Health Connect operation utilizes Outbound SQL Adapter to insert one row into a table per request.

0
0 400
Question Pavithra Rajamohan · Dec 24, 2021

Hello,

I am in the process of trying to create a GIT repository and I am struggling to export all the relevant classes from Studio, as I only have access to Studio and not able to export via the Management Portal. Does anyone have any suggestions as to how I can export from Studio as one project to include all the relevant folders and its associated classes?

Are there also any recommended documentations/links you would suggest to help me get a better understanding of  GIT and how it works etc?

Thanks!

Pavi

1
1 496
Announcement Anastasia Dyubaylo · Nov 22, 2021

Hey Community,

Welcome to the second InterSystems technical article writing competition! Write an article on any topic related to InterSystems technology:

🎄 InterSystems Tech Article Contest: Christmas Edition 🎄

Duration: November 25 – December 25, 2021

Prizes for everyone: Everyone who publishes an article on Dev Community during this period will receive a special prize pack!

Main Prizes: Apple AirPods Max / Oculus Quest 2 (VR Headset) / Amazon Kindle / Apple AirPods Pro / Raspberry Pi

Join our new contest and your content will be seen by over 55K monthly readers! Details below. 

10
1 1057
Article Iryna Mykhailova · Dec 22, 2021 6m read

As you can see in my profile I teach at a university and I wanted to share my take on teaching IRIS (or Caché before it).

It’s been some time but I remember seeing a series of articles by @Yuri Marx earlier this year about the course “Developing with InterSystems Objects and SQL”. He actually gave a brief description of what’s done on Day 1, Day 2, and Day 3 with comments from instructor @Joel Solon. And I thought to myself, it may be interesting to share my experience.

6
2 461
Announcement Jose-Tomas Salvador · Dec 22, 2021

Just wanted to give visibility to a place in GitHub where everybody can publish Enhancement Requests, Ideas and Innovations that would be great to have in our InterSystems Technology ecosystem.

If you want to add your enhancement request, or take a look and see if there is already there and vote for it, contribute, etc..., click on this link. That doesn't guarantee that Product Management decides to go on that direction, they have to balance many things to decide our products roadmap, but having the direct input from our Community is invaluable.

Come on! Go for it and make your suggestions!

1
0 311
Question Jimmy Christian · Jun 16, 2021

Hello Community,

I am trying to insert multiple values in a table. Below is the simple sql statement.

Insert Into TableX

values ('Name', 'Address', 'Phone')

How can i do multiple inserts(rows) in one single statement?

Values are not in another table, so i cannot use Select into.

Thanks,

Jimmy Christian.

14
0 1108
Article José Pereira · Dec 22, 2021 5m read

What about having your IRIS REST APIs scanned every push you did and being reported on possible vulnerabilities? This is what I am going to show you in this article.

Recently, we had the Security Contest with amazing applications and examples showing how to improve security on your IRIS solutions. One of such examples was the zap-api-scan-sample, made by me and my colleague Henrique Dias. Our application shows how to use the OWASP ZAP API scanner to perform security tests on your REST APIs OpenAPI definitions generated by IRIS.

Now, we did an improvement on such example, using ZAP GitHub Action

0
0 1620