Here's a simple indirection snippet. It fails with <UNDEFINED> error and I'm not sure why.
ClassMethod ind()
{
kill info
set active = 1
set reactive = 2
for i="active","reactive" {
set info(i)= @i
}
zw info
break
}
I'm getting this exception: <UNDEFINED>zind+5^test.Client.1 *active
In this series of articles, I'd like to present and discuss several possible approaches toward software development with InterSystems technologies and GitLab. I will cover such topics as:
In the previous article, we covered Git basics, why a high-level understanding of Git concepts is important for modern software development, and how Git can be used to develop software. Still, our focus was on the implementation part of software development, but this part presents:
For the FIleSpec on a file service can you use a multiple wildcard values like *CLINICALENCOUNTER*.xml?
It seems like you are restricted to a single wildcard value.
Hi,
I have a custom classes that that I use with
Weirdly the management portal is not drawing the the lines between my process and operation when viewing my production on the ' Ensemble > Production Configuration' screen. Clicking the green dot flashes the 'computing connections' message, and highlights my operation, but no lines get rendered:
Hi Community!
Here is a digest of the Developer Community postings in February 2019.
Most viewed
How to Develop InterSystems Applications in Your Favorite IDE 240
Apache HTTPD Web Server Configuration for HealthShare 230
Alternative to using % to make a variable public 151
VSCode-ObjectScript next release 0.7.9 129
How to return JSON Array in SQL request for a List Property? 122
Tools and Framework Development and Deployment Guidelines . What is The Best Approach? 117
Consume data from websocket 114
What are the pros and cons of keeping INT code 112
Accessing the lock table and another process's variables, potentially on a different server 107
InterSystems IRIS Example Reference Architectures for Amazon Web Services (AWS) 105
Ethereum Adapter for InterSystems IRIS Data Platform 101
Using Oauth2 with SOAP (Web)Services 61
See the details below
We are currently on 2015.2.2 and in schema structures for vs 2.6 HL7 I do not have a ORU^R40. Its for a GE Device alarm. Has anyone hear of this structure, have a way to export it, and can send it to me so I don't have to build from scratch?
Thanks
Scott
Hi Community!
Good news! We have a new release of InterSystems Open Exchange.
This release comes with some better options to expose your solutions and tools.
What's new?
✓ Embedded videos;
✓ Screenshots;
✓ Download stats.
See the details below.
I like to know if COS has a PGP library for encryption and decryption messages received from an SFTP connection. We have interfaces that we used BouncyCastle in C# but would like a native library for COS.
I'm connecting to a remote device using TCP. It has a binary protocol.
set host = ""
set port = ""
set io = $io
set device = "|TCP|7000"
set timeout = 2
open device:(host:port:"M")
use device:(/IOT="RAW")
read string:timeout
use io
zzdump string
The problem is when reading from it, I get a 0A (also known as 10 or \n or linefeed) byte, which terminates the read.
Expected output:
0000: 42 00 7B 0A 11But I get this output:
0000: 42 00 7BHow can I fix that?
Some additional info:
Good afternoon,
We have a very old version of Ensemble with one of our clients and they have no desire to upgrade anytime soon. We have gotten the all-clear to purge really old messages from the database, changing the days kept from 60 to 30. The option to Compact/Truncate is displayed in this version of Ensemble, but does not execute as it mentions not being actually present in this version.
There is an option in ^d DATABASE that restores unused space, however this does not return nearly as much free space as the refined Compact/Truncate procedure.
My question is: Is it possible to Compact/Truncate properly in Ensemble 2013?
Many thanks and kind regards, Alexi Demetriou
I have an existing table, and I've added an array property to it that I need to populate.
The issue is that I can only use SQL to insert into the table due to access reasons.
For example:
Class Package.Tables.Person Extends %Persistent
{
Property Name As %String(MAXLEN = "");
Property Address As Array of Package.Datatypes.Address;
}
Class Package.Datatypes.Address Extends %SerialObject
{
Property AddressType As %Integer;
Property StreetAddress As %String(MAXLKEN = "");
}
So the projected tables are:
Package_Tables.Person
Package_Tables.Person_Address
Now via ObjectScript it's as easy as
Hi Dev Community,
My team is currently working on a project where we need to post pdf documents to a 3rd party REST API.
The API specifies a field in the JSON request message to contain the 'physical content' of the file as an array of bytes, example of the JSON request as follows - data truncated for readability purposes:
{
"CaptureSource":2,
"RecipientID":"ID34",
"Document": {
"Guid":"5D847A4E9CC1485382DC4A5F5DC80D6C",
"EventDate":"2019-01-14T13:23:46",
"FileExtension":"pdf",
"FileContent":"JVBERi0xLjQNCiXi48/TDQoxIDAgb2JqDQogIDw8DQogICA......"
},
"ActionRequired":false,
This is the first in a pair of articles on SQL indices.
Hi Community!
Please welcome a new video on Developer Community YouTube Channel:
Developing with FHIR - REST APIs
Hi All,
I need to transfer the sub-directories and their contents from a SFTP server to a shared directory while maintaining the structure.
I can do it without maintaining the structure.
Best Regards.
Michel.
P.-S. : files are HL7 messages.
Have any idea for add default page to web application in csp menu
&?
InterSystems is currently verifying InterSystems IRIS 2019.1 with Windows Server 2019. This work is scheduled to complete by the end of January 2019. In the second half of this month InterSystems will add Caché/Ensemble 2018.1.2 to be verified on this platform.
As we get closer to the completion of those tasks, I will update this post with information on release dates, and which products and version will support Windows Server 2019.
I am taking over a production system that had some HSLIB and other database routine and class files modified. However, I do not know what was modified .
I developed a routine that allows me to load each database in our production instance and compare it against a default instance using the SIZE attribute. This allowed me to generate a list of files where the .INT file size in production does not match the file size in the default instance. However, doing a spot check of the .cls or .mac files indicates that in some cases these files are identical, just the intermediate files are different.
What I would like to do is export these files (.cls, .int, .mac) to XML, placing the files from production in one folder and the files for the default instance in another. After I can use something like BeyondCompare to better identify what has changed.
In my code I currently use the following to get information about a routine where p = the name of the routine
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'
this not updates fullname column value....
but it's works with a create table command.
CREATE TABLE MyStudents ( Name VARCHAR(16) NOT NULL, surname VARCHAR(16), fullname Varchar(50) COMPUTECODE { SET {fullname}={Name}_ "?" _{surname}} COMPUTEONCHANGE (Name,surname) )
In this series of articles, I'd like to present and discuss several possible approaches toward software development with InterSystems technologies and GitLab. I will cover such topics as:
In the first article, we covered Git basics, why a high-level understanding of Git concepts is important for modern software development, and how Git can be used to develop software.
In the second article, we covered GitLab Workflow - a complete software life cycle process and Continuous Delivery
Greetings, InterSystems community!
I am pleased to announce that the web terminal project, Caché WebTerminal version 4 gets its release! After long period of enhancing this web application from 2013, it came to the version 4, which features major stability and security improvements, intelligent autocomplete and syntax highlighting, convenient SQL mode and a lot of other useful features.
The goal of this article is to spread the knowledge about this project over the InterSystems community.
Hi,
I know of the existance of (ELEMENTS) to create an index from a list, but I actually would like to index the content of an element of a list. Is it possible?
My scenario:
Class:
Property Test As list of TestList;
Test.List:
Property Name As %String;
Property Surname As %String;
I would like to have an index based on the TestList.Name. If I try using
Index NewIndex On Test(ELEMENTS)
it will create an index with Name and Surname in it, but I just want to have an index with the name. Is it possible?
Hi,
When Creating a custom security role, what privileges do I need to add to it, in order for the users that I grant him the role, to be able to use
dynamic SQL to perform read only queries on all tables in a namespace?
I have a security role, that contains the %Service_SQL privilege,
And yet when I connect to a terminal and try to run an SQL query using dynamic SQL , I get a "user is not privileged for the operation" error.
reading the documentation , I understand that %Service_SQL privilege privilege is not enough, but I don't understand what privilege to add,
I can't add specific tables in the "SQL Tables" section of the role definition, I need all the tables to be accessible.
this the documentation I mentioned:
https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...
Regards,
Nael
Hi, I have a CSV file with a list of 5000 records in the following format
Name, Acc, division
Eric, 1234, 567
John, 1235, 987
Peter, 3214, 879
I just want to copy the Acc, division to a global so eventually the global would be like the following:
^People("Customers", "Acc.division")
Can you advice on how I can perform this from the terminal? This is a one time task. I want to read all the values from the csv file and insert them into the global
Regards,
Eric
InterSystems has corrected a defect that impacts the use of X.509 private keys stored in Caché, Ensemble, and Health Connect, but only in 2018.1.1, on any platform.
This defect does not affect new installations of 2018.1.1, only upgrades to that version. It affects WS-Security, not SSL/TLS Configurations.
InterSystems has corrected a defect that can result in data integrity problems in environments that use InterSystems mirroring in conjunction with parallel dejournaling. This problem exists for currently released Caché and Ensemble versions beginning with 2017.2 and for InterSystems IRIS Data Platform version 2018.1.
There have been some very helpful articles in the community that show how to use Grafana with IRIS (or Cache/Ensemble) by using an intermediate database.
But I wanted to get at IRIS structures directly. In particular, i wanted to access the Cache History monitor data that is accessible by SQL as described here
https://community.intersystems.com/post/apm-using-cach%C3%A9-history-mon...
and didn't want anything between me and the data.
I already had class queries that returned the data i wanted, so i just needed to embed them in an REST class that returned JSON. I haven't included my class Grafana.MonitorData because it could be anything but i can if people want it
Hi,
I am having a problem in REST service when de-serializing JSON using a nested Property.
I am new to Intersystems and my first time creating REST Service. I setup Atelier dev environment. The worst IDE I have ever worked in. I was able to attach to a process in the debug perspective and step through the code, but one cannot see contents of variables nor print anything to the console, so it is useless as a debugging tool. When looking at a variable all it displays is its type of the variable and if I try to "watch" I get:
An internal error occurred during: "Label Job".
java.lang.NullPointerException
SO I am unable to solve the issue I am having with the JSON in my REST service due to being unable to debug properly, so I will appreciate any help on this. I try to explain the issue
I'm trying to test SOAP integration by using one Ensemble production to send a SOAP message to another production, but I'm seeing the following error when I try to pass a message between the two:
ERROR #6248: SOAP response is a SOAP fault: faultcode=Server
faultstring=Internal Server Error
faultactor=
detail=
<error xmlns="http://tempuri.org">
<text>ERROR #7900: Service 'SOAP' not enabled for application '/csp/healthshare/hspc/'</
</error>
I'm following this guide to creating a service, and I've done the following steps which I expected to enable SOAP
Hello Gentlemen,
As you can read on the title, my question is to know how to retranslate the hl7 message into a string and so to remove the '\E' that are inside. A example/picture worth more than a thousand word.
OBX|1|RP|ECG||CARDIO ECG^APPLICATION^PDF^^\E\\E\sitehopital.org\E\files\E\cardio\E\022018\E\GE274583.PDF|
As you can see, the escape character \E is used by hl7 message in the purpose to authorize a character '\' just but I don't want it in my program... Is there any function that retranslates this format into a "normal" format?
Faithfully,
Thomas
