Hello,

I have created my first table in Ensemble:

And I have added a row using the Production:

We would like to query it, and we would expect to get a row wih all the previous' image data.

I have tried, inside a code block in a Bussiness Process:

  set statement=##class(%SQL.Statement).%New()
 
  set status = statement.%PrepareClassQuery("TablasBBDD.NotificacionesPUSH.RelacionAplicacionNotificacion","seleccionarTodo")
 
  set result = statement.%Execute()
  do result.%Display()
 
  $$$LOGINFO("filas result: "_result.%ROWCOUNT)
 
  $$$LOGINFO("result: "_result)
 
  //$$$LOGINFO("clave: "_result.

Hi Developers!

This is the digest of new solutions and applications submitted to InterSystems OpenExchange in January 2020!

New applications in January 2020

OUReports by Irina Yaroshevskaya

Online reporting tool for InterSystems IRIS. Online User Reports - automatically analyzes data - generates automated reports - provides interface for ad hoc reports - conducts statistical research. Learn more on OUReports.com

Samples-Aviation by InterSystems

Provides sample data for use in exploring InterSystems IRIS Text Analytics capabilities.

objectscript-package-example by Evgeny Shvarov

ObjectScript Package example with a simplified folder structure to edit/compile/collaborate with InterSystems IRIS, Docker and Github.

Reducing Readmission Risks with Realtime ML by Amir Samary

Patient Readmissions are said to be the Hello World of Machine Learning in Healthcare. We use this problem to show how IRIS can be used to safely build and operationalize ML models for real time predictions and how this can be integrated into a random application.

REST Business Activity Monitoring by Stephen Pisani

Send IRIS Business Metrics to a REST Endpoint, or host a REST API to retrieve Business Metric values

eXTreme for IRIS / Caché Example by Iryna Mykhailova

A console .NET application which shows how to access, create and store globals from a .NET application using eXTreme.

zpm-dockerhub by Evgeny Shvarov

repository for publishing zpm enabled images for InterSystems IRIS via Github Actions

Hello.
I'm trying to export a XML stream containing some files that are supposed to have been written using UTF-8, but I'm facing some broken encoding issues.
You can see below that I'm indeed viewing a UTF-8 encoded and which is inside the CSP folder and encoded correctly (although displaying it on Studio would not display it correctly as the file is not using BOM and that's intentional).

We need to export such files to XML along with many others and for that we'are using the method ExportToStream from the class %SYSTEM.OBJ.

Hi Community,

New video, recorded by @Raj Singh, is available on InterSystems Developers YouTube:

⏯ What Keeps Developers Up at Nigh

Hi,

I have two namespaces

1. In the first one, I have defined a class which Extends (%Persistent, Ens.Util.MessageBodyMethods), we'll call it NSOne.Msg.Req
2. In the second namespace NSTwo, I want to use the previous class with something like SET pInput = ##class(NSOne.Msg.Req).%New()

I mapped the NSOne.Msg.Req package in namespace NSOne. In Atelier, I can see NSOne.Msg.Req in my NSOne. But, when I try to execute line 2 above, it tells me :

{
    "status": {
        "errors": [
            {
                "error": "ERROR #5002: ObjectScript error: <PROTECT>^NStwo.Api.

Hi,

we're planning some work on our SQL Query Plan functionality for a future release of InterSystems IRIS and are interested to hear how you're using them today, or what'd keep you from using them. Rather than try and fit everything in a rigid survey, I thought a simple thread on our beloved DC might also reveal some use patterns that we support or could do a better job on. 

I am trying to get a list of all settings for all the config items of a given production using SQL . When I run the following sql as a dynamic query I am unable to access the setting names and values. Settings is a list of Ens.Config.Setting

Set query="Select Name, Production, Settings,$ListLength(Settings) "
         _"As Count from Ens_Config.Item "

Set rc=##class(%ResultSet).%New()

Set sc=rc.Prepare(query)

Set sc=rc.%Execute

While rc.Next(.sc) {

For i=1:1:Count {

  Set tSetting=$List(Setting,i)

  Set name=tSetting.Name

}

I get a LIST error on the last line!

Hi Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in January 2020:

Dear Developer Community, 

Would you like to earn a free certification exam voucher?

The Certification Team of InterSystems Learning Services has designed exam objectives and now needs input from our implementation community for the following proposed certification exam:

HealthShare Unified Care Record Technical Specialist

If you have completed at least one UCR/Information exchange (version 15.x or higher) implementation, assisting or supporting in a technical role, ObjectScript proficiency, and Health Connect interfacing experience, you can help us by filling out our Job Task Analysis survey.

Hi all, it's finally time for the next release of VSCode ObjectScript extension. So what's new in this release.

• Debugging support, for classes, routines and attach to a running process

• Files in Server Explorer now can be edited

• Added more details about connection errors

• Improvements in Server Explorer build tree

• Fixed memory leak when exporting large amount of files
• Server view can be opened in explorer as virtual file system with schema `isfs://`
• Option to suppress popup information message about successful compile, ("objectscript.suppressCompileMessages": true)
• Export, addCategory setting have more flexibility in naming category for exported items
• Formatting for commands and functions, as Word, UPPER or lower
• Some improvements in syntax highlighting
• Some other small fixes

Hi All -   I want to share with the community a project I recently posted in OpenExchange, that extends on the Business Activity Monitoring features available with InterSystems IRIS’s integration  framework. I have called this REST Business Activity Monitoring, and is implemented via a set of zaux.rBAM.* classes.

Hi Developers!

In January we introduced into Developers Community:

• New postings type - Discussions;
• No more answers - only comments-replies;
• bug fixes and small improvements.

See the details below.

Hi Developers!

Thank you for participating in the 2019 DC survey!

I'd love to share some results and answer some questions which were raised in the survey.

NPS 54

You give us 54 - which is really cool! Thank you for your trust, we'll try to prove it this year again!

DeepSeeButtons is available on Open Exchange! This tool will generate a diagnostic report of your DeepSee environment.

The report consists of multiple sections. These sections range from System Details to Caché/InterSystems IRIS logs to Cube information. In addition to simply providing information about the environment, some common recommended configurations are checked. If a recommended configuration is not used, an alert is displayed highlighting that the environment configuration does not match the recommended configuration.

I've got a pretty standard dataListBox on a pretty standard Zen page running a pretty standard query.  My problem is that I can't get the onfocus or onclick events to fire.

Thanks in advance.

A quick question regarding to SQL Query Plan:
Why these two requests have different plans, in particularly, why second request needs temp file? To me, temp file is a bad thing which should be avoided, right?

1. select * from Test.Log where cdate = 1
2. select * from Test.Log where cdate > 1

Plan for 1:

Read index map Test.Log.cdateIndex, using the given %SQLUPPER(cdate), and looping on ID.
For each row:
 Read master map Test.Log.IDKEY, using the given idkey value.
 Output the row.

Plan for 2:

Call module B, which populates bitmap temp-file A.
Read bitmap temp-file A, looping on ID.

Hello,

I am working on Ensemble 2017.2.1 .
I need to export my security settings into an extern database, in order to make a report.

I've created a Business Operation with an SQL Adapter into a Namespace, but I don't know how to get every security data from "%SYS" Namespace  ( SQLPrivileges , Resources , Roles , Services , Users ... ).

I dont't want to use the terminal and the ^SECURITY routine, because i don't want to store a XML file on the server.

I tried to create a method where I can use the (Security.

Cache / Ensemble version 2016.2.2.853.0

I have a need to restrict ODBC access to certain users to prevent unwanted access to our cache database.

We have a limited number of legacy applications that use ODBC to connect to read data and are currently not in a position to have these amended any time soon so in the interim, I am hoping someone will be able to provide me with some assistance.

Any suggestions on where to start?

Hi

I'm using this query "Config.MapMirror.List" To get information of the list of servers that are in the mirror system.

I'd like to know how can I know which of the list is the primary and which is the failover or async member.

Is there a way to do it with this query? Is there another query to get this info?

Thanks a lot

My Ensemble instance is reporting its status through SNMP in Dutch even though my system language is English. Can I change Ensemble's locale somewhere in the Management Portal?

Hi,

On a persistent class, I have defined an %OnNew method that validate some properties with appropriate status code for each kind of error. Question is: how do you catch the specific error when %New is called on this class?

Surrounding %New method with a try-catch not seems to work.

Thanks

Hello,

I am reading in an X12 document into my production that needs to be processed and returned as a CSV file.  I have created a record map to support the fields I want to extract with a batch class to store headers.  I have a DTL mapping the data to the appropriate fields in the record map and am sending the record map to a EnsLib.RecordMap.Operation.BatchFileOperation.

None of my components error out and in fact report that the message was processed without any errors but I am not getting an output file in my expected output folder. 

Is this an appropriate use of this operation class?

Hi everyone,

I am very pleased to announce that the Readmission Demo has been released as open source. Many thanks to the Solution Factory team that worked hard on making this possible.

Here are the changes:

• It is now running on top of IRIS Community 2019.3.0.308.0.
• It has synthetic data based on Synthea instead of the real data we were using before. But the machine learning models are 100% real
• Image RRLACESrv has been renamed to “image-riskengine”
• Image “readmissionsrv” has been renamed to “image-risksrv"
• We refactored a lot of the code on image-riskengine to look better.

I'm trying to tie IRIS (2019.1) into our Concord Fax cloud-based email-to-fax workflow. We have some sites that require a fax be sent to multiple locations based upon certain data (ie Radiology and Emergency departments). Unfortunately, CC-ing does not work with Concord Fax so I need a way to send the email, change the recipient, and then send it again if certain criteria are met. Is this possible? Do I need to duplicate and rename the method, calling the second one in the MessageMap?

Hello everybody,

My question would be, how is the recommended way to access Windows shares, also in view of future demads. Of course, I'm also happy about an explanation or code snippet of how the library, which is mentioned in the following , can be used under cache.

The classic jcifs library is easy to use, also with Cache, but as microsoft ceases support for smb1, we are currently looking for alternatives. jcifs-ng is such a library, which we took a closer look at. In java code a jcifs-ng file operation looks like this:

[.

Hi,

I'm attempting to use the $EXTRACT function in my routing rule but I'm seeing 'Expression Parsing' error messages when trying to save the rule.

I want to check the last character of a post code by using the following code:

$EXTRACT(HL7.{PID:PatientAddress(1).ziporpostalcode},*)="Z"

Could anyone assist with this?

Thanks, 

Martin

Hi,

I have a large XML zen report file that I want to convert to a CSV, what is the most efficient way to do it.

XML file:

<Details>
<Col1> aa1 </Col1>
<Col2> bb1</Col2>
<Col3> cc1 </Col3>
</Details>
<Details>
<Col1> aa2 </Col1>
<Col2> bb2</Col2>
<Col3> cc3 </Col3>
</Details>

Expected Output:

Col1,Col2,col3
aa1,bb1,bb1
aa2,bb2,bb2

Thank you.

Hello,

When we need to create a utf-8 encoded XML file, we  use the Charset property of %XML.Writer:

set writer=##class(%XML.Writer).%New()
set writer.Charset="UTF-8"

How can we create regular txt files with such encoding?

Our Cache Installations are 8 bit and not unicode.

Thanks,

Nael Naser eldeen

Hi Community!

New "Coding Talk" video is already on InterSystems Developers YouTube:

⏯ How to Install and Use ObjectScript Package Manager with InterSystems IRIS