Rechercher

Article
· Août 9, 2024 1m de lecture

VS Code ObjectScript extension 2.12.6 and later can optionally display server documents read-only if source control class reports them as such

A nice feature that we recently added to version 2.12.6 of the VS Code ObjectScript extension is controlled by this new setting:

objectscript.serverSourceControl.respectEditableStatus

When set true in JSON, or checked in the Settings Editor, a server-side file will be read-only if the source control class for the namespace reports that it is not editable.

This option may be of particular interest to users of our Deltanji source control product, particularly when used in combination with the Deltanji extension for VS Code. Once set, managed documents have to be explicitly checked out via the context menu option Deltanji adds, instead of the checkout being triggered implicitly by the first edit. Operating this way combines well with Deltanji's concept of a "favorite" change request, which streamlines the checkout procedure but until now tended to lead to accidental checkouts that the user would then need to cancel.

Discussion (0)1
Connectez-vous ou inscrivez-vous pour continuer
Annonce
· Août 9, 2024

[Vidéo] SQL on FHIR au service de la logistique hospitalière

Salut la Communauté!

Profitez de regarder la nouvelle vidéo sur la chaîne Youtube d'InterSystems France :

📺 SQL on FHIR au service de la logistique hospitalière

Intervenants : 
🗣 Luc Chatty, CEO, Fyrstain
🗣 @Guillaume Rongier, Ingénieur Commercial, InterSystems

Découvrez un cas d'usage de SQL avec FHIR pour la gestion des déplacements des ambulances autour d'un hôpital ainsi que l'affichage des informations sur une carte interactive.

Abonnez-vous à notre chaîne youtube pour plus de vidéos et restez à l'écoute !

Discussion (0)0
Connectez-vous ou inscrivez-vous pour continuer
Article
· Août 9, 2024 2m de lecture

WebTerminal is broken on IRIS 2024.2

I'm posting this for the benefit of WebTerminal users who have upgraded to the recently-released IRIS 2024.2 -- (Build 247U) Tue Jul 16 2024 09:52:30 EDT -- or are considering doing so.

That version of 2024.2 contains a change (DP-432503) which requires that the user under which the Web Gateway initially connects to IRIS (usually CSPSystem) must have READ permission on the database hosting the dispatch class of the REST web application.

For cases where that is not true an error is raised, but this returns an HTTP 404 status to the caller instead of the expected HTTP 401.

Apparently the problem will be fixed in 2024.3, reference DP-432898 / ALI048 : REST Login endpoints to return 401 HTTP error instead of 404, but as a Continuous Delivery (CD) release 2024.2 won't get a maintenance release correction.

Workaround is to arrange for CSPSystem to have READ permission on the database of the namespace you installed WebTerminal in.

Here's how I did it:

  1. Create a new security resource %DB_WEBTERMINAL and set the WEBTERMINAL database to use this instead of %DB_%DEFAULT.
  2. Create a role %DB_WEBTERMINAL that gives the role-holder RW access to the %DB_WEBTERMINAL resource.
  3. Create another role (I called mine DBread_WEBTERMINAL) that gives the role-holder only R access to that resource.
  4. Give the CSPSystem user the DBread_WEBTERMINAL role. This works around the 2024.2 bug.
  5. Edit the /terminalsocket web application and add %DB_WEBTERMINAL to the Application Roles tab. This step is necessary because WebTerminal initially runs its websocket process as UnknownUser and needs to update state information in its database even before it switches to run as the authenticated user.

An easier but less secure technique would be:

  1. Create a new security resource %DB_WEBTERMINAL with RW public privileges, then set the WEBTERMINAL database to use this instead of %DB_%DEFAULT.

More details at https://github.com/intersystems-community/webterminal/issues/155

2 Comments
Discussion (2)2
Connectez-vous ou inscrivez-vous pour continuer
Question
· Août 9, 2024

About Designative Reference column

when doing ETL process from cache database to mysql database(ods) and to another mysql database(dwd).

There are  lots of DR columns in one table.

In the first step we need two databases to be totally consistent(ods=cache database)

However, the DR column in another database lost its meaning and become to normal number.

In the last step we do the data governance in ODS to DWD. My question is how to write sql without many `join` in this step.

Discussion (0)1
Connectez-vous ou inscrivez-vous pour continuer
Article
· Août 9, 2024 36m de lecture

Text to IRIS SQL with LangChain:Pythonプログラミングコンテスト受賞作品紹介!

開発者の皆さん、こんにちは!

この記事は、2024年7月に開催された「InterSystems Pythonプログラミングコンテスト2024」でエキスパート投票、コミュニティ投票の両方で1位を獲得された @Henry Pereira さん @José Pereira さん @Henrique Dias さんが開発された sqlzilla について、アプリを動かしてみた感想と、中の構造について @José Pereira さんが投稿された「Text to IRIS with LangChain」の翻訳をご紹介します。

第2回 InterSystems Japan 技術文書ライティングコンテスト 開催! では、生成AIに関連する記事を投稿いただくと、ボーナスポイントを4点獲得できます📢 @José Pereira さんの記事を💡ヒント💡に皆様の操作体験談、アイデアなどを共有いただければと思います。

開発されたアプリSQLzilla についての概要ですが、Open Exchangesqlzilla のREADMEに以下のように紹介されています。

「SQLzilla は、Python と AI のパワーを活用して、自然言語の SQL クエリ生成を通じてデータ アクセスを簡素化し、複雑なデータ クエリとプログラミング経験の少ないユーザーとの間のギャップを埋めます。」

1 Comment
Discussion (1)1
Connectez-vous ou inscrivez-vous pour continuer