#InterSystems IRIS

Hello,

Could someone help me with a solution, for example "dump" to IRIS.DAT, I mention that it is difficult to manipulate a file of ~ 200 GB. I would be interested in generating an IRIS.DAT file containing the "schema" without any information.

Thanks !

I am trying to figure out how to loop through the EnsLib.LDAP.Message.Results to get all the attributes. From router I am passing EnsLib.LDAP.Messge.Search as the request param. Response is EnsLib.LDAP.Message.Results. I am invoking the EnsLib.LDAP.Messge.Search BO.

At the BP level, trying to figure out how to extract all the attributes for a EnsLib.LDAP.Message.results

I got a resultset, and some columns might be a JSON_OBJECT. Is there a way (based on metadata) to determine that the column was formed from JSON_OBJECT function?

set rs = ##class(%SQL.Statement).%ExecDirect(,"SELECT 1 colA, JSON_OBJECT('id':1) col2")
do rs.%Display()

I do not want to try parsing json.

Hi,

During the implementation of iris-history-monitor using ZPM, I'm bumping on the following scenario:

My Installer.cls has a call for the Custom Sensors Class method. The Custom information looks like a charm as I described in this article:

IRIS History Monitor using custom built-in REST API /api/monitor/metrics

But, now I'm trying to replicate the same behavior using the module.xml to work with ZPM.

The SQL editor in the contest environment promises these features
InterSystems SQL Reference.

Alerts are automatic notifications triggered by specified events or thresholds being exceeded.

InterSystems Documentation

I have a Business Service connected to a machine with ~100 sensors. BS receives sensor values once a second.

Several conditions determine if a Business Service should raise an alert (it's a list of: sensor id > threshold).

I am working on JSON and want to be prepared to handle large Objects. I try this code:

ClassMethod MaxLen() As %Status

{

set longStr=""

for i=1:1:$SYSTEM.SYS.MaxLocalLength() { set longStr = longStr_"x" }

write "Maximum string length = "_$LENGTH(longStr)

;

set longObject = {"a":(longStr),"b":(longStr)}

set file=##class(%File).%New("/tmp/longObjectFile.txt")

do file.Open("WSN")

do longObject.%ToJSON(file)

do file.Close()

;

do file.Open("RS")

Anyone have a X12 schema for 852 types concerning supply chain?

So I've got the IRIS AMI spun up in AWS EC2; it seems to be running fine.

I've added an EBS volume to it for persistent storage, and now I'm pondering how to make it actually do something useful.

What's the best way to do deploy code to this instance? I can think of a few ways to do it, but what's the least painful way? Push my code to an S3 bucket and figure out how to load it at system start? Github project?

Hi all,

I'm wondering if is possible to call to a BO from a HL7 Route according to a parameter of the HL7 Message

I mean,

According to the identify of the laboratory, I want to call to other TCP process to retrieve information about blood tests.

We are creating the BO using this partern.

LAB.BO.TCP. + name of the laboratory.

The name of the laboratory is stoted in the lookup table T_LABORATORIOS

I've tried to assign the name into a variable and put it in the "send" instruction, but it doesn't work.

Hi!

I am wondering how I can test that my application can be installed through ZPM before I publish it to Open Exchange. How can I accomplish this?

Peter

Hello everyone

I am new to cache. In an interview i was asked how to optimize a sql query.

I just said I will create index on conditions which are present in where clause. But as per interviewer I should check How query plan is getting executed. This will help in optimizing Sql queries.

I want to know what will be the answer for how to optimize SQL query in cache.

Thanks in advance!!

I need to do some nifty string manipulation on a source property. I will not be able to do it with the functions available(with the knowledge that I have of what is available). Could I call a ClassMethod to do this for me? This is what I want to do: The source property is "myemail@myemaildomain.co.uk". I need to add the text "test" to the beginning of that string. "testmyemail@myemaildomain.co.uk".

just wondering - is there any reason why IRISList doesn't accept decimal values?

.. IRISList would be very handy und useful - but if i have to build a wrapper to serilize/ deserilize decimals ...