Pesquisar

Question
· Sep 17, 2024

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
Discussion (7)1
Log in or sign up to continue
Question
· Sep 17, 2024

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
Discussion (5)4
Log in or sign up to continue
Question
· Sep 17, 2024

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
Discussion (8)3
Log in or sign up to continue
Announcement
· Sep 17, 2024

[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! 👍

Discussion (0)1
Log in or sign up to continue
Digest
· Sep 17, 2024

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!