Hi, I'm still very much new at Ensemble DTL. I am trying to set up an algorithm that requires loading fields from an OBX into an Array. I don't think that I know how to iterate through the OBXs. I know that there is a "for loop", that I will try to play with, but in the mean time, could someone tell me what is wrong with the following?
For example the code below works when I hard code the number 1 in OBXgrp(1)
I am converting an object to json, but in the result a "_class" property appears, is there any way to remove this?
.png)
Result:
.png)
Hi,
How do I generate JSON strings instead of integers, as follows:
{ "MyProperty":"1"}
all we seem to be able to generate is
{ "MyProperty":1}
Its for an api that requires the former and as the former is valid JSON I'm surprised I am having so much trouble.
(Obviously I'm new, please be kind :D
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
Does anyone know if there is a table or query to get the Application Error Log (^ERRORS) by SQL?
cache 2017.2 windows 10
Is there any way to change the sql Shell interface to output a <TAB> between the fields instead of outputting one or more spaces between columns
I needed to run an sql ( that took a while to run) and then cut and paste the generated output into excel, trouble was the paste into excel was not very good for columns when there's spaces used between the columns
kev
I am having difficulties with using the ..Strip() function in my DTL to strip the slash ( / ) from the phone number portion of an x12 834. There are very few records that have the slash in the phone number, so I am trying to filter out any characters other than numbers so that all phone numbers are formatted 1112223333.
Here is the code portion of the strip:
Set HomePhone ..Strip(source.{loop2000(k1).loop2100A.PER:CommunicationNumber},"*AW","-()/").
I am then checking the length of HomePhone.
Hello,
I work with IRIS for Health 2020.1 and I attempted to set up Enterprise Systems to populate Message Bank. I see entries in Message Bank Event Log from the defined Enterprise Systems. I can browse Messages going back before I set up Enterprise Systems using Enterprise Message Viewer. However, I find no messages in Message Bank Viewer. Do I need anything extra to archive messages?
Hi Community!
How can I enable IRIS Text Analytics (formerly known as iKnow) in a given Namespace programmatically?
Hi all,
any news about support of the IRIS platform in the DBeaver? I only found this https://github.com/dbeaver/dbeaver/issues/6289 Github issue. They are waiting for a new version of the JDBC driver.
Thanks for the answer
We use the %Net.FtpSession class to perform FTPS file transfers. This has worked fine with Implcit FTPS servers but crashes when trying to connect to an Explicit FTPS server. Explicit FTPS has a slightly diffferent negotiation in the intitial connection and different ports.
Has anyone gotten Explicit FTPS working with the Cache classes?
I have been looking into using abstract classes and methods. In other languages, if a superclass is defined as abstract, subclasses inheriting from the superclass will not compile until all abstract methods have been implemented in the subclass.
I have created the following classes to try this in Cache:
{
I'm trying to get a count of specific message type with a specific entry and thought I could build the query in Message Viewer but this does not provide counts (as far as I am aware). So when I take the SQL from 'Show Query' it omits the segment criteria as the code shows below.
I have attached the criteria that has been excluded. Is this possible?
Thank you
Hi!
I need to export some data from a table on CACHE and then import this data to a POSTGRESQL table.
Is this possible? I know I can export this data as a CSV format, but I prefer if there is a way to export that data as SQL format.
Thanks!!!
Hello people!
I am Brazilian and I am starting to work with the latest version of CACHE, and I would like to know where I can see an example of a TRIGGER, I would like to validate the fields before writing the actual data in the database.
in advance, thank you very much! and sorry for any mistake in concordance in english
Iris for health has a wizard or procedure to create a fhir database and expose as rest service?
Hi,
Can anyone point me to an example of a DTL & Class method that can pull a base64 encoded PDF out of a MDMT02 message?
This is really asking for two things;
- how to make a DTL that extracts a specific subfield of an HL7 2.3 message into a message of its own,
and
- how to transform an base64 encoded document into its original binary form for writing to a file.
I'd also love to see an example of an HL7 2.n MDM^T02 ==> HL73.ITK2 non-coded CDA
Hello Community,
I hope you're going well.
I am programming a daily reporting that will send by e-mail when people will add a dashboard as favorite by clicking on the star :.png)
I asked Intersystems WRC on how to automatically generate a report with some line coding, but I heard there is no way to do this without a headless Browser.
What is the shortest frequency of time I can set to have Cubes rebuilt.
Is it possible to create a scheduled task programmatically without using the management portal "Task Scheduler Wizard"?
Once created the scheduled task would then be editable in the Wizard as normal for other users.
Thanks,
Conor
I face the challenge to have a bunch of classes on IRIS and CACHÉ in parallel
until all systems are migrated to IRIS.
Applying changes in Caché development environment and moving to IRIS is no problem
But if I have to apply a fix on IRIS there seems to be no clean way back to Caché.
where can I find a list of all command line utilities with a short description?
I'm looking for some existing solutions to compare 2 global structures.
- by subscripts
- if subscripts match then by content.
Hi,
I am attempting to set up a security role for our support team so they can have read access to the production and messages.
I have given the role RW rights on the resource associated with the database. However, when I log into Management Portal and select "Ensemble", the "Available Ensemble namespaces" list is empty.
What permissions do i need to set to be able to navigate to the production?
Thanks in advance,
Carl
Edit:
Is it possible execute create table from management portal?
I tried this:
CREATE TABLE SQLUser.Teste(ID INT NOT NULL, coluna1 VARCHAR(255), coluna2 VARCHAR(255), coluna3 VARCHAR(255), coluna4 VARCHAR(255)CONSTRAINT TestePK PRIMARY KEY (ID))
Error message:
.png)
I send ORUs to a process where a transform is applied before sending the message to a process where the routing is handled. A recent request was made that when OBR:25="D" the message is also be faxed with transforms that have some similarities to the original, but not exactly the same. I copied the DTC, made the alterations, and created a separate rule to handle it. However, when I run a message through with a "D" in OBR:25, it is only sent to the routing process once.
Hello, guys!
I'm facing a problem when I compile my code in Atelier (version 1.3) when connected to an Iris Community instance in Docker container.
When compiling, the code is synchronized with the server correctly, however, in the IDE, the code is inserted into the class again.
Class after compile:
I want to map global ^myUnitTests(ID)={Start}_"^"_{JOB} where {Start} and {JOB} are two properties and ID is determined by $Increment(^myUnitTests).
I defined this class but it will not compile:
