Discussion
· Jun 29, 2023
The idea for iris-user-manager

I want to deploy IRIS apps running in containers in Kubernetes with user accounts configured.

I have a %ZSTART routine which looks for an XML file with Users export data and if the %ZSTART routine finds this file, it imports it. This Users export data can be obtained by running a class method.

I have defined a task which can be scheduled or run on demand. This tasks imports user data from an XM file.

In Kubernetes I can provide a ConfigMap to stage the Users data for the %ZSTART routine.

1 2
0 163

Hi,

InterSystems IRIS has long supported the obvious translation functions required to for converting to upper or lowercase to enforce case-insensitive string comparison (e.g. in ObjectScript with $zconvert) and sorting (e.g. with SQL collation functions, not to be confused with NLS collation). Customers in international contexts have at times used custom workarounds to also treat accent insensitivity or even more advanced normalization duct tape. We’re looking to address such use cases at the system and SQL level to increase convenience for this international audience, which is well represented on the Developer Community.

1 5
0 245

Hi folks!

I'm playing with IRIS interoperability at the moment and it turned out that Data Transformation cannot be the element of production by itself.

It can be called either from data rule or from business process.

But why?

What if I just want to change the message with the transformation and transfer the message somewhere else? Why the overhead with Rule or Business process?

1 1
0 144

Once again I would like to know, if there are any plans to make Java libraries available through normal channels like public mvnrepository, like the whole world it's doing, where anyone can find any JDBC driver to any database in the world but InterSystems.

Currently there is only some useless garbage. There are just very empty files. What was the point of posting it there?

1 9
0 151

Hi, Community!

Have a question for general discussion.

In ObjectScript we have cls for classes and mac code, which both compile into int code.

Is there any reason when you use mac instead of cls for non-persistent classes?

For me the benefits for cls are:

1. Inheritance and other OOP features

2. Auto-documented code

For mac one visible benefit is easier call in terminal:

do method^Utils(p1,p2)

vs

1 43
1 2.6K

I've been preparing to take the InterSystems HL7 Interface Specialist certificate and on the page that explains the cert it lists one in-person class and one online course. I've been through the suggested online course but when I read through the practice questions there are a lot of things that aren't covered or mentioned in that course. Naturally I could go digging through the documentation but there is no specific guidance about what things to study.

1 6
0 72

Hi Community!

In the previous announcement, we asked you what are your thoughts regarding the new rubric Water Cooler Talk - basically a moderated (possibly biweekly) discussion about some programming topic not directly related to the InterSystems products. Since the majority reacted positively, we'd like to invite you to write the topics that interest you in the comments to this post and mention if you would like to lead the discussion.

1 5
0 386

Hi Community!

There are two general ways to execute arbitrary SQL in serverside ObjectScript code: EmbeddedSQL and ObjectScript SQL a.k.a. Dynamic SQL.

E.g. if we want to get the value of the property of instance with a certain ID using SQL we can do:

&sql(SELECT Name INTO :name FROM Sample.Person WHERE ID=1)

write name

Same result with %SQL.Statement:

set rs=##class(%SQL.Statement).%ExecDirect(,"SELECT Name as name FROM Sample.Person where ID=1")
  do rs.%Next()
  write rs.name

1 2
0 899

Hi Community! Many of you have seen the Data Points podcast episodes that we have been releasing since February. I mentioned previously that I planned to pose an open question to the community about topics you might like to hear in a podcast episode. Let us know in the comments if there are any conversation points you would find particularly interesting, and we can try to include some conversations with experts on said topics!

And in case you missed it, check out Episode 12 about the all-new chat bot on InterSystems websites!

https://5e18edf067eb59-03854285.castos.com/player/212752
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 130

Hi folks!

We have a bunch of templates on OEX that provide a handy foundation for building a particular application with IRIS. And the basic principle of each and every template is that we take vanilla IRIS images, load code, and files into the image using Dockerfile, and create a new docker image as a solution. And then we develop running this image and rebuilding it when returning to development.

Some developers ask me why we need to build the docker image to work with the code. Indeed, if at the end of the day I need to develop a ZPM package and not a docker image why don't run the vanilla image and load the code and everything in it?

The problem I have with the building image approach is that often I can wait a lot to build an image and it fails on some Objectscript problem in the source that I cannot fix as the image is not building. and

Any thoughts? How do you develop with docker?

1 4
1 317
Discussion
· Jan 25, 2021
web service api consumed license

1) Does web service access consume license?

2) In web service program, we used a connection pool to reuse the session id, but it doesn’t work, the license consume increased quickly, it seems connection pool didn’t work, do you have any sample to do it?

1 1
0 196

Hi, Community!

Open Exchange (OEX) is getting more and more popular and more and more developers consider publishing their apps in the public package manager registry.

This is really great!

So the topic of thoughtful naming convention is getting more important and even critical. Let's discuss?

1 6
0 374

When I'm asked questions about SQL, I like Intersystems staff at the WRC, generally ask about the Query Plan. My feeling is that even before you run a query you should examine the results of Show Plan to confirm that the code is going to give me the results in the manner I would expect. If I expect it to leverage an index and I see that it is not then I go back and look at what I might have done incorrectly and try to re-write the query to get the index behavior I'm looking for. To that end, there's a poll below to ask you if think moving the Show Plan button as the first button would be

0 0
0 142

In a healthcare setting we've an Ensemble namespace through which passes a key HL7 feed (the ADT feed from our PAS). It is split up, transformed and passed on to multiple downstream systems. We consider the feed going to each downstream system an interface. Each interface is developed as separately as possible - typically as a separate branch of our git repo (which we access via VS Code).

0 0
0 202

Hello,

First of all thanks for reading this post and thanks for replying:

I think it could be obvious or a little bit naive but I was wondering if a software developer needs as a must or should get his/her own personal laptop or computer, appart the one from their own bussiness or company?

What laptop or computer would you recommend for personal use? For general purpose: programming, leisure, surfing the net, etc.

Thanks for your replies.

Greetings.

0 5
0 232