#Ensemble

Hi Guys,

Can I insert a new row and enforcing my own ID not the default id increment?

&sql(INSERT INTO Sample.Person
(ID,Name,SSN)
VALUES ('205','Swift,Jonathan','111-22-3333'))

IF (SQLCODE = 0) {
Write "New Person inserted with ID: ", %ROWID,!
}
else
{WRITE !,"SQLCODE=",SQLCODE," ",%msg }

Hi, I updated the schema on our live node, but the change did not occur on the mirror server. Is there some setting that I need to enable? Everything else seems to be updating but the schema has not

Can you advice on what I could be missing or is this something that is known?

Regards,

Eric

Now that I have SAM up and running, out of the box I would like to add some Application Metrics. Does anyone have templates, or have suggested classes that someone could use to add custom metrics to SAM? Maybe we should start a repository somewhere? Or would someone be willing to share custom metrics on the Open Exchange?

What I am looking to do is capture the overall HL7 message and header count per day.

I want to write the values that are stored in an array into the OBX 5 field. The text in MyArray(1) will go in the the first OBX 5 field. Then the text in MyArray(2) will populate the next OBX 5 field.

My question is how do you format the Set > Action Tab > Value entry so that it pulls the data from MyArray(source.{PIDgrpgrp().ORCgrp().OBXgrp().OBX:SetIDOBX})

If interested email to me at jwalkerbdrsolutionsllc.com

hi,I meet a problem,i want to move huge data from ensemble to oracle.it`s about 3years business data.i have tried some case！

1. EnsLib.SQL.OutboundAdapter

i parse the data one by one,and translate it into inser or update sql statement then write to Oracle，it·s most slowly，and take more disk space。

2.save the data to a new table，and then use dbeaver transport data to oracle。

3.user linktable. save object as insert，but，i can·t user %openid method.

I am updating the PV1 segment with values from the database but when I get two values back I dont know how to separate them with a tilde and insert. Any advice for me on that?

so if I get two values returned

my PV1.7 segment should be :

My current code is as below: It works fine for one value, but when there are more than 2 values returned I need to find a way to include it

I'm trying to send a message into a production on change a persistent object.

And when I change an object using SQL - I get an error,
when change the object using objectscript - I get a message (but not an error or exception)
But the most interesting - everything works fine (the object has been changed, and business service receives data)

Persistent class

Hello!

In a transformation (DTL) I create an XML and pass it to an EnsLib.EDI.XML.Operation.FileOperation.

The receiver does not accept an empty tag (eg <Analysis/>) that is created automatically
if the tag has no values ​​in underlying tags. I have tried with action='remove' in transformation
and other things but it only clears the content.

Hi all, My first post. I hope I have created it correctly.

Our team is looking to increase the number of characters in our Ensemble 'Categories' for Services, Processes and operations.

We are doing this to better identify things like Vendor, Message type and integrated application names...

One of our team members thought his might increase processing overhead and a discussion ensued that was not resolved.

my thoughts...

Hi,

I want to know if anyone tried calling a CDS service from Healthshare/Ensemble. Will that be similar to any other API or is there anything different in constructing CDS Hooks and consuming the CDS Cards received in the response?

I'm a beginner with Health connect. Trying to create a bi-directional interface. is there a specific class I should use on the business operations/services?

Hi,

I've added a REST service which worked fine on our test system but failed on the production environment because UnknownUser does not have %All set and I really don't want it set on production (in fact I've also switched it off on test).

Is there a way to allow a single REST service to have unauthorised access?

I was thinking adding a resource/role to UnknownUser specifically for that service but I've never touched on Users/Roles/Resources so I'm struggling to work out what needs adding where.

Thanks

Hi Guys,