Is it possible to integrate Microsoft Dynamics with Ensemble?

I try to create a column with computeonchange.

Its works with CREATE TABLE sql command, but if i use ALTER TABLE ADD COLUMN sql command this computeonchange doesn't works.

any reason why?

example:

CREATE TABLE MyStudents ( Name VARCHAR(16) NOT NULL, surname VARCHAR(16))

alter table MyStudents add column fullname Varchar(50) COMPUTECODE { SET {fullname}={Name}_ "?" _{surname}} COMPUTEONCHANGE (Name,surname)

insert into SQLUser.MyStudents (Name, surname) values ('name1',null)

update MyStudents set name = 'name' where name = 'name1'

Introduction

In InterSystems IRIS 2024.3 and subsequent IRIS versions, the AutoML component is now delivered as a separate Python package that is installed after installation. Unfortunately, some recent versions of Python packages that AutoML relies on have introduced incompatibilities, and can cause failures when training models (TRAIN MODEL statement). If you see an error mentioning "TypeError" and the keyword argument "fit_params" or "sklearn_tags", read on for a quick fix.

Has anyone noticed weird behavior when upgrading to HealthShare Health Connect 2024.1?

Wednesday I upgraded our TEST environment from IRIS for UNIX (Red Hat Enterprise Linux 8 for x86-64) 2022.1.4 (Build 812_0_22913U) [HealthConnect:3.5.0-1.m1] [HealthConnect:3.5.0-1.m1] to IRIS for UNIX (Red Hat Enterprise Linux 8 for x86-64) 2024.1 (Build 267_2U) [HealthConnect:3.5.0-1.m1].

Some of our Business Processes have been throwing...

Hi guys,

Apparently, I'm doing something wrong. Opened the InterSystems IRIS Cloud SQL, clicked on View Purchase Options and got an error:

Something tells me that contacting AWS customer support won't help. What should be my steps to get access to it to try it out?

Hello!

Trying to delete txt file in folder: /tmp/test

Good morning,

We would like to share with you a doubt, and we would appreciate if you could read and answer us.

Currently we have a file titled: "Imagen PatientID 9358340 PatientName Milagros ReasonForStudy 350290 InstitutionName 350290 StudyDate 20220927.xml" , in which we have the following InstitutionName:

<DicomAttribute keyword="InstitutionName" tag="00080080" vr="LO">
<Value number="1">350290</Value>
</DicomAttribute>

I am receiving batched results in an EDIFACT file. I need to debatch and send individual HL7 out. I have built a DTL to read the first instance of a result from EDIFACT and that generates an ORU^R01 as desired, but I have no idea how to make the DTL loop and send multiple HL7 messages outbound.

Is it possible to call java programs inside SQL statements, like the new LOAD Data, or is this just internal?

Afternoon all,

Is there a way (at SQL level) to script out the definition of a Cache stored procedure from within SQL?

In SQL Server, I would do...

Select * from INFORMATION_SCHEMA.ROUTINES where ROUTINE_NAME = 'my_sproc_name'

But cant find anyway to do this in cache.

Note, its an old version of Cache, so "INFORMATION_SCHEMA" is not available.

I am trying to see the SQL definition in the sproc from SQL itself.

Thanks all

Olá pessoal,

Compartilho material de um curso desenvolvido por mim, espero que possa ajudar a comunidade.

English:

Hi folks,

I share material from a course developed by me, I hope it can help the community. The material is in Portuguese.

Link: https://www.linkedin.com/posts/cristianojs_material-te%C3%B3rico-activity-6608421528906285056-sr8E

Presenter: Alain Houf
Guest Speaker: Joop van Uden of Philips Healthcare
Task: Evolve your data model as you build your application
Approach: Provide a real-world example of how to leverage the flexibility of the document data model and how to easily integrate it into existing environments

Description: Come and learn how you can leverage new technology like the document data model in your current environment. We will explore a customer use case that managed to include this brand new technology within weeks in their current application stack and start to benefit from it.

Problem: Tools that help you build a stable backend, sometimes are in the way when you need to evolve.

Solution: Use flexible data models like the document data model for areas where you have to evolve constantly and mix and match it with the power of the OO and relational model.

Dependencies: Most value if session "The Power of Handling Data without a Schema" was attended before.

Content related to this session, including slides, video and additional learning content can be found here.

Hello everyone,

My team is currently developing guidance and best practices for the generation, storage, and deployment of TUNE TABLE statistics across development and production environments. With that in mind, we want to get an idea of what methods teams in the field have developed for handling this data. In particular, we’d like to know the following:

I receive request xml object as

pRequest =

<getURL>
<Url1><![CDATA[https://test/cs/icdfg?&RevisionSelectionMethod=LatestReleased&allowInter...
</getURL>

I need to send this to a stream

Set XmlStream = ##class(%Stream.GlobalCharacter).%New()

// how do I send my pRequest into XmlStream ??

Do httpRequest.EntityBody.CopyFrom(XmlStream)