Question

Benjamin De Boe · Nov 13, 2024

#Modèle de données #SQL #InterSystems IRIS

Hi,

A customer today asked whether we could offer anything like the nice lineage charts that dbt offers, based on SQL view metadata. They are very much aware of our dbt-iris adapter, but were asking in the context of their landing area, which combines foreign tables and views, ahead of possibly using dbt for onward transformations.

I didn't have anything to point at right away, but was wondering if any creative minds in the Developer Community would have looked into something like this, and used any data viz libraries to feed on the DependsOn keyword for SQL view classes that point at the tables they depend on. And while we're at it, a similar (or combined) type of analysis could be made for query statements as a whole, drawing from the INFORMATION_SCHEMA.STATEMENT_RELATIONS table. I'm curious if this resonates with the audience here, and if someone would have particular suggestions wrt the graphics libraries one might use to implement this.

Thanks,
benjamin

Discussion (0)1

Connectez-vous ou inscrivez-vous pour continuer

Question

Richard Prouvot · Nov 13, 2024

#SQL #Caché

I HAVE A NEW SQL CLASS THAT DISPLAYS ENTRIES BASED ON THE FIRST 2 NODES OF A GLOBAL. I FOUND OUT THAT THE CLASS ALLOWS FOR AN ADDITIONAL NODE(s) TO BE INSERTED IN THE "User Specification Node:" along the delimiter and the Piece in the NewStorage Map1 for "ModifyDDDD" shown below. it is not working.

^GBL("AA","SSSSSS")="1:1:1:1:"

^GBL("AA,"MD",1,1)="1:"

^GBL("AA,"MD","A",1)="0:"

I HAVE USED THIS:

<Data name="ModifyDDDD">
<Delimiter>":"</Delimiter>
<Node>"3,4"</Node>
<Piece>1</Piece>
</Data>

WHILE IT COMPILES IT DISPLAY NOTHING. MY QUESTION IS WHAT IS THE RIGHT SYNTAX AND PUNTUATION FOR THIS, PLEASE?

HOW DO I TYPE IN THE <Node> tag the proper formated data? <Node>"MD","A",1</Node> ??????

Since the class is build on the first 2 nodes, should it be <Node>"A",1</Node>

I tried many different combinations to no avail.

5 Comments

Discussion (5)2

Connectez-vous ou inscrivez-vous pour continuer

Question

Joost Platenburg · Nov 13, 2024

#CSP #InterSystems IRIS for Health #Caché

I'm trying to rewrite a legacy portal created with all .csp files into a portal written in .cls files. The problem I have is that the old cap pages use "csp:include page='page.csp'> tags. I'm trying to use the Include method that is in the %CSP.Page master page. It doesn't seem to insert the required file. Any suggestions?

<tr>

do ..Include("pubsub/portal/include/headLogoDXC.csp")

#;

</script>
</tr>

</table>

1 Comment

Discussion (1)1

Connectez-vous ou inscrivez-vous pour continuer

Résumé

Anastasia Dyubaylo · Nov 13, 2024

#Communauté des développeurs officielle #Résumé

導入方法

今回は、IdPとしてOKTAを使用してAuthorization Codeフローを行います。

OKTAでの設定内容

参考までに、今回使用した環境を後半に記載しています。

アプリケーションの起動

コンテナ化してありますので、コンテナのビルド環境をお持ちの方は、下記を実行してください。

Discussion (0)1

Connectez-vous ou inscrivez-vous pour continuer

Rechercher

Charting lineage across views and statements

SQL CLASS NODE SYNTAX

^GBL("AA","SSSSSS")="1:1:1:1:"

^GBL("AA,"MD",1,1)="1:"

^GBL("AA,"MD","A",1)="0:"

I HAVE USED THIS:

<Data name="ModifyDDDD">
<Delimiter>":"</Delimiter>
<Node>"3,4"</Node>
<Piece>1</Piece>
</Data>

%CSP.Page.Include doesn't seem to work

InterSystems Community Q&A Monthly Newsletter #42

IRIS+WSGIでOAuth2クライアントを実行する方法

導入方法

OKTAでの設定内容

アプリケーションの起動

Rechercher

Charting lineage across views and statements

SQL CLASS NODE SYNTAX

^GBL("AA","SSSSSS")="1:1:1:1:"

^GBL("AA,"MD",1,1)="1:"

^GBL("AA,"MD","A",1)="0:"

I HAVE USED THIS:

<Data name="ModifyDDDD"><Delimiter>":"</Delimiter><Node>"3,4"</Node><Piece>1</Piece></Data>

%CSP.Page.Include doesn't seem to work

InterSystems Community Q&A Monthly Newsletter #42

IRIS+WSGIでOAuth2クライアントを実行する方法

導入方法

OKTAでの設定内容

アプリケーションの起動

<Data name="ModifyDDDD">
<Delimiter>":"</Delimiter>
<Node>"3,4"</Node>
<Piece>1</Piece>
</Data>