検索 | InterSystems Developer Community

Please note that this post is obsolete.

Question

Vishnu G · Dec 14, 2022

#HL7 #InterSystems IRIS for Health

Does InterSystems has CDS Hook implementations?
if yes, where I could get the details.

7 Comments

Discussion (7)3

Discussion

Ben Spead · Dec 9, 2022

#ChatGPT #Generative AI (GenAI) #InterSystems IRIS

After seeing several article raving about how ground-breaking the recent release of ChatGPT is, I thought I would try asking it to help with a Caché newbie question: How do you find the version of InterSystems Caché?

To be honest, I was quite surprised at what the chat bot told me:

Not going to lie - I was impressed! I tried several other searches with regard to InterSystems IRIS version number and was told to use $zv. I did a google search for part of the answer it gave me and I came up with zero results - this is synthesized information and not just copied and pasted from InterSystems docs (I couldn't find the string in our docs either).

What do you want to try asking ChatGPT about technological know-how?

12/11/22 UPDATE:

As is clear from the screenshot, I was playing with this on my phone and didn't properly vet the answer on an actual Caché instance. I fell prey to the observation made in the article linked in the comments w.r.r. ChatGPT answers being banned from StackOverflow: "But Open AI also notes that ChatGPT sometimes writes "plausible-sounding but incorrect or nonsensical answers." " So my respect for its technical answers has diminished a bit, but overall I am still rather impressed with the system as a whole and think it is a pretty big leap forward technologically. Thanks for those who chimed in!!

10 Comments

Discussion (10)2

Article

Dzmitry Rabotkin · Dec 3, 2022 2m read

Open Exchange

#Docker #InterSystems IRIS for Health

Hi, I would like to tell you how easy it is to spin up IRIS for Health docker container in compute engine(VPS) in google cloud.

I know that to run IRIS for Health in AWS is pretty simple and straightforward, but I wanted to tried if its same easy in GCP environment.

Create vm instance. 2GB RAM is more than enough.

I used Debian 11 as Linux distro.

Standart persistent disk is cheaper.

Don’t forget to allow http, https traffic

Last thing for setting up virtual machine is allow external ports in firewall rules.

I allow here only 52773 which is for web user interface. My Kotlin app will run on same vm and use 1972 internally, so I didn’t allow it too.

Let’s Install docker-compose then run IRIS:

sudo apt install docker-compose

sudo docker run --name iris -d --publish 1972:1972 --publish 52773:52773 containers.intersystems.com/intersystems/iris-community:2022.1.0.209.0 --check-caps false

I found that command in InterSystems documentation pages here: https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls?KEY=ACLOUD

I only added 2 things:

1. “-d” after name of container “iris” which means run in detached mode. So container will still run on background after you close SSH shell.

2. “- -check-caps false” at the end. I immediately found it in this article which was very helpful. https://community.intersystems.com/post/using-intersystems-iris-containers-docker-201014

sudo docker ps

Container is up and running just with 1 command:

Now check UI in browser:

This link I found at Intersystems documentation pages: https://docs.intersystems.com/irisforhealthlatest/csp/docbook/DocBook.UI.Page.cls?KEY=GSA_USING_PORTAL
http://35.222.2.215:52773/csp/sys/UtilHome.csp

35.222.2.215 is external ip of my Virtual machine.

52773 port we exposed with docker run command.

Default Login: SuperUser

Password: SYS

Now you have to change default password:

Congratulations, you are logged in:

ATTENTION: don't forget to delete VM instance, so you lose money on hosting.

Conclusion:

In this article I only covered how to run IRIS for Health community edition docker container in google cloud linux environment. Other part of my Kotlin/Intersystems journey will be in description of our project Dia Bro App. Please check it up and vote if you like the idea.

Discussion (0)1

Article

Megumi Kakechi · Nov 28, 2022 2m read

#SQL #Tips & Tricks #InterSystems IRIS #InterSystems IRIS for Health

Question:

IRISでは、PostgreSQLやMySQLで使うことができる、開始位置や取得件数を指定する LIMIT句やOFFSET句をサポートしているでしょうか？

Answer:

※2025/4/17更新：IRIS2025.1 以降のバージョンでは、LIMIT/OFFSET句をサポートするようになりました。ご参考

残念ながらサポートしていません。
ただ、代わりに使える同様の方法がありますのでご紹介します。

以下のようなSQLクエリをIRIS SQLで行うとします。

SELECT *
  FROM Sample.Person
ORDER BY Name
 LIMIT 3 OFFSET 5

---------------------------------------------------------------------------------
1. サブクエリとビュー ID (%VID)を使用する方法
---------------------------------------------------------------------------------

IRISでは、ビューまたは FROM 節のサブクエリで返される各行に整数のビュー ID (%VID) を割り当てることができます。
%VIDを使用すると、以下のサンプルのようにして同様のことが実現できます。
※%vidについて

SELECT *, %vid FROM (SELECT top all ID, Name
                     FROM Sample.Person
                     ORDER BY Name) v
WHERE %vid BETWEEN 6 AND 8
// 6番目から3つ分 --> 8番目まで

---------------------------------------------------------------------------------
2. OFFSET目までのデータを除いて TOP する方法
---------------------------------------------------------------------------------

SELECT TOP 3 ID, Name FROM Sample.Person WHERE ID NOT IN (SELECT TOP 5 ID
                 FROM Sample.Person
                 ORDER BY Name)
ORDER BY Name

---------------------------------------------------------------------------------
3.row_number() 関数を使用する方法
---------------------------------------------------------------------------------

IRIS 2021.1以降でサポートされるようになったウィンドウ関数の ROW_NUMBER() を使用して実現することも可能です。

SELECT * FROM (
  SELECT row_number() OVER (ORDER BY Name) AS rn, ID, Name
  FROM Sample.Person 
) AS e 
WHERE e.rn BETWEEN 6 AND 8 ORDER BY Name

是非お試しください。

Discussion (0)0

Question

William Glover · Nov 24, 2022

#InterSystems IRIS

As the title says I want to be able to hide code I deploy to TIe.

3 Comments

Discussion (3)1

検索

Does InterSystems has CDS Hook implementations?

Can ChatGPT be helpful to an developer using InterSystems technology?

Guide how to run and use IRIS for Health docker image in GCloud

IRIS SQLでは LIMIT/OFFSET句のような機能をサポートしていますか？

Is there a way of masking code in studio, such as password protection or with user rights?