查找

質問
· 2024年9月17日

Stored procedure for insert into and select from tables

How to add the following to a stored procedure (Cache Studio)
1. Select from a few tables and insert result into a TABLEA.
2. Then select data from the TABLEA, apply some SQL logic, insert results into TABLEB.
3. SELECT * FROM TableA
    UNION ALL
    SELECT * FROM TableB

7 Comments
ディスカッション (7)1
続けるにはログインするか新規登録を行ってください
質問
· 2024年9月17日

Can I use a DTL for any HL7 message without specifying a DocType?

I have a theory that I could use an HL7 Data Transformer in a rule without specifying a specific DocType. I want to use the same DTL for a variety of different DocTypes. Here is my very simplistic DTL so far:

Class OrdRes.TestTransform Extends Ens.DataTransformDTL [ DependsOn = EnsLib.HL7.Message ]
{
    Parameter IGNOREMISSINGSOURCE = 1;
    Parameter REPORTERRORS = 1;
    Parameter TREATEMPTYREPEATINGFIELDASNULL = 0;
    XData DTL [ XMLNamespace = "http://www.intersystems.com/dtl" ]
    {
        <transform sourceClass='EnsLib.HL7.Message' targetClass='EnsLib.HL7.Message' create='new' language='objectscript' >
            <assign value='source' property='target' action='set' />
            <assign value='"test"' property='target.{MSH-4}' action='set' />
        </transform>
    }

}

For the more visual people:

 But when I test this with any HL7 message I get the error

ERROR <Ens>ErrGeneral: Cannot recognize path before DocType is set

Is there not a way to write a DTL for any HL7 message without specifying the DocType? And also, am I referencing the field correctly with target.{MSH-4}? I want to use the segment name and position instead of the field name since I'm not using a DocType.

5 Comments
ディスカッション (5)4
続けるにはログインするか新規登録を行ってください
質問
· 2024年9月17日

Cache-2018.1.9

Hi, Support Team

I´m working with Cache for many years, currently i have running version cache-2018.1.7.721.0-win_x64.exe

However we are facing some compatibility/requirements challenges, in that way i´m hereby request your support to provide next version/build of Cache 2018.1 (e.g cache-2018.1.9.xxx.x-win_x64.exe )

Nevertheless , I already downloaded IRIS for testing purpose if can also provide trial/limited licence for detail testing will be apreciated.

 

Thanks in advance for your attention.

Regards

Rajendra

8 Comments
ディスカッション (8)3
続けるにはログインするか新規登録を行ってください
お知らせ
· 2024年9月17日

[Video] Chatbots are all the RAGe: Generative AI with InterSystems IRIS

Hey Developers,

Play the new video on InterSystems Developers YouTube:

⏯ Chatbots are all the RAGe: Generative AI with InterSystems IRIS @ Global Summit 2024

Discover the capabilities of InterSystems IRIS Vector Search, including integrating dense vector storage and search with InterSystems IRIS SQL for advanced semantic search and other GenAI application patterns. This video will illustrate how Vector Search powers Retrieval-Augmented Generation (RAG) for chatbots, presenting practical use cases that transform your data and applications with AI innovations.  

Presenters:
🗣 @Thomas Dyar, Product Manager, Machine Learning, InterSystems
🗣 @Alvin Ryanputra, Systems Developer, InterSystems  

Enjoy watching, and get ready for more videos! 👍

ディスカッション (0)1
続けるにはログインするか新規登録を行ってください
ダイジェスト
· 2024年9月17日

Final Call: Employee-Only Video Demos Contest!

Dear colleague,

This is your final call to enter the Employee-Only Video Demos Contest! 🎥 You have until September 22, to create and upload your demo video (up to 10 minutes) on any topic related to InterSystems products and services.  

Every participant is guaranteed a gift, and you also stand a chance to be one of the contest winners! 🎁

For more info, including contest guidelines and prizes, please check out the Insider Article.

Don’t miss out – show off your skills and creativity!