Something like:
IRIS iris = IRIS.createIRIS(conn);
byte[] value={1,2,3,4}
iris.set(value,"^testglobal");
but this creates set ^testglobal = $c(1,2,3,4).
Hi,
In a Business Operation i have the following code.
I need the identity of the latest row inserted in a table in MSSQL.
i Have the following code:
---------------------------------------------------------
set insertmaster= "INSERT INTO dbo.dataMasterArchive(deviceToPatientLogID) values (?)"
set tSC = ..Adapter.ExecuteUpdate(.nrows1,insertmaster,pRequest.deviceToPatientLogID)
$$$ThrowOnError(tSC)
set sql ="SELECT SCOPE_IDENTITY()"
set tSC = ..Adapter.ExecuteQuery(.tResult,sql)
$$$ThrowOnError(tSC)
set maxID =
Hello.
I want to store a mailbox in Caché, persistently.
Does anyone have some code for downloading all messages from mailbox into Caché? And maybe automatic syncing after download? I know, there is %Net.POP3 but maybe someone has already done that.
Thank you.
Hi
I'm using a class which extends %XML.Adaptor adaptor and I want to create an XML file with multiple namespaces, like the following:
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> </soap>
However, I don't see how to do this with the code I have. So far, I have
Class GMMHTIE.Docman.Messages.Request.RequestWrapper Extends (%Persistent, %XML.Adaptor){ Parameter XMLNAME = "soap:Envelope";
Parameter NAMESPACE = "http://www.w3.Hey everyone,
Lots of new content to read! Thanks to our wonderful participants of the 2nd InterSystems Tech Article Contest!
So it's time to announce the best of them!
For those that, at some point, need to test what means that of ECP for horizontal escalability (computing power and/or users and processes concurrency), but they're lazy o have no much time to build the environment, configure the server nodes, etc..., I've just published in Open Exchange the app/sample OPNEx-ECP Deployment .
UnitedHealth Group is looking for an IRIS expert to help guide our development team, providing subject matter expertise and sound software design skills.
This is a permanent, full-time, 100% telecommuting position. The job will be a mixture of software design, consulting and hands-on development. The ideal candidate will have excellent communication skills, a solid understanding of computer science and be an energetic team player.
I need iterate multiple times the same ResultSet. How can I do a rewind on it?
Does someone knows if any Studio version or, if in its new versions, it will be able to recognize new Javascript statements like arrow function, let, const etc ?
let there be less <UNDEFINED> or <SUBSCRIPT> Errors in my life.
Hey Developers,
Learn about the latest updates to InterSystems HealthShare Health Insight and what is coming next:
We have a couple of systems that send us a URL link to a PDF instead of base 64 encoding it in the HL7 message. Has anyone ever tired to take that URL, and retrieve the file off of the server to save it off somewhere?
Hi Developers,
It's time to announce the Winners for November 2021! Please welcome our awesome Global Masters Heroes!
The storm of applause goes to these developers and their great contribution to DC in November 2021:
🥇 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria
🥈@Oliver Wilms, Integration Engineer, Take2 Consulting, USA
🥉 @Mary George, Team Lead, Barts Health NHS Trust UK
Learn more about the competition and our awesome winners below.
Hey Developers,
Thanks to everyone for participating in the Advent of Code 2021and coding in InterSystems ObjectScript! We're pleased to introduce the winners and distribute all the prizes!
Big applause goes to these developers:
@Yuval Golan (w/ repo)
@Oliver Wilms (w/ repo)
We'd also like to reward another developer who conquered Embedded Python and made all 25 challenges on it. Please welcome:
@Robert Cemper (w/ repo)
Hey DC members,
How could we make the Tech Article contest better? We want to hear from you all: both from our participants and from those who were unable to participate.
Please answer some questions to help us improve our writing contest!
👉 1-min survey: InterSystems Tech Article Contest #2 Survey
Hi developers!
We launched the datasets contest.
And one of the important questions that need to be covered is dataset licensing.
There are two general cases:
a) a dataset you take from another place in public Internet or private network/person.
b) a dataset you create by yourself or own for any other reason.
We decided to follow the principles and considerations that data.world site introduces for datasets' licensing.
Hi all
We are looking into automating worklist report SQL queries that we run manually on InterSystems IRIS platform but we would like to have them run on a Java application.
This means we must have a way to get our java application to talk to IRIS in order for those queries to run. Please advise on how to go about this?
Regards,
Ephraim Malane
We have an interface that need to be disabled then re-enabled when it starts to queue up. I wrote the following code to do this functionality in a process. This works in our development domain, but in production it says it fails to disable the job - it only shuts down the interface without updating the production/starting the interface back up. Error message: "Failed to stop job '36831290' within 60 seconds. Status '<unknown>"
Is there something wrong with how I'm trying to do this?
set tSC = ##class(Ens.Director).EnableConfigItem(itemname,0,0)
set tSC = ##class(Ens.Director).
I need to send the data from a view that returned NULL, but is going as empty. The fields are of type String.
I'm using:
SET tSC = ##Class(%ZEN.Auxiliary.jsonProvider).%WriteJSONStreamFromObject(.tSteamJson,pObj,,,,"e")
{
"altura": "",
"atendimento_id": "3060382",
"data_atualizacao": "2021-12-16 10:39:12.0",
"data_coleta": "2021-12-16 10:37:00.0",
"data_liberacao": "2021-12-16 10:39:12.Hi Developers,
New video is already on InterSystems Developers YouTube:
⏯ Embedded Python for ObjectScript Developers: Working with Python and ObjectScript Side-By-Side
If one of your packages on OEX receives a review you get notified by OEX only on YOUR package.
So @Evgeny Shvarov suggested publishing my monthly summary of my reviews here in DC.
It reflects my experience with the status I found at the time of my review.
to dismount/mount a database, use Dismount() and Mount() methods in SYS.Database class available in %SYS namespace.
NB: the database ID is its Directory
You'll find some examples of how to dismount/mount and check if a database is mounted (Mounted=1) or not (Mounted=0), and quickly see all the attributes of a database (via zwrite)
%SYS>set db="/opt/irisapp/data"
%SYS>w ##class(SYS.Database).%OpenId(db).Mounted
1
%SYS>w ##class(SYS.Database).%OpenId(db).Dismount()
1
%SYS>w ##class(SYS.Database).%OpenId(db).Mounted
0
%SYS>w ##class(SYS.Database).%OpenId(db).Hey Community,
Day by day, our team makes the DC site a better place for InterSystems developers. This release will show how we've improved the Developer Community recently.
The key features:
Learn more about our new features below.
Hello!
I send request:
set hr=##class(%Net.HttpRequest).%New()
set hr.Server = "server.com"
set hr.Location = "method?param=value"
do hr.EntityBody.Write("{ "name": "value" }")
set tSC=hr.Send("POST")
But when request incoming to server.com URI = "method%3Fparam%3Dvalue".
How I can disable urlencode params in URI, so that the URI remains "method?param=value"?
One of my colleagues had developed an interface in Health Connect (HealthShare 2019.1) to add large amounts of data to an external SQL Server database. The data comes from many text files with delimited rows and data for one table per file. There is a business process to read a file line by line and send an Insert Request to an operation. The request contains an Insert statement like ‘Insert into TABLE columns (col1, col2, … colZ) values (val1, val2, … valZ).’ The Health Connect operation utilizes Outbound SQL Adapter to insert one row into a table per request.
Hello,
I am in the process of trying to create a GIT repository and I am struggling to export all the relevant classes from Studio, as I only have access to Studio and not able to export via the Management Portal. Does anyone have any suggestions as to how I can export from Studio as one project to include all the relevant folders and its associated classes?
Are there also any recommended documentations/links you would suggest to help me get a better understanding of GIT and how it works etc?
Thanks!
Pavi
Hi Community,
New video is already on InterSystems Developers YouTube:
⏯ Updates on Security: OpenSSL and a New "Security" Database
we have a issue with just the 1 namespace, where users log using ldap but arent getting any roles assigned to them.
Ldap does work as the user account is created as a ldap user.
I have gone through the various settings to check that all is setup as required, but cant find a reason why the roles arent being assigned.
Hey Community,
Welcome to the second InterSystems technical article writing competition! Write an article on any topic related to InterSystems technology:
🎄 InterSystems Tech Article Contest: Christmas Edition 🎄
Duration: November 25 – December 25, 2021
Prizes for everyone: Everyone who publishes an article on Dev Community during this period will receive a special prize pack!
Main Prizes: Apple AirPods Max / Oculus Quest 2 (VR Headset) / Amazon Kindle / Apple AirPods Pro / Raspberry Pi
Join our new contest and your content will be seen by over 55K monthly readers! Details below.
As you can see in my profile I teach at a university and I wanted to share my take on teaching IRIS (or Caché before it).
It’s been some time but I remember seeing a series of articles by @Yuri Marx earlier this year about the course “Developing with InterSystems Objects and SQL”. He actually gave a brief description of what’s done on Day 1, Day 2, and Day 3 with comments from instructor @Joel Solon. And I thought to myself, it may be interesting to share my experience.
