Hey Developers,

We invite you to review the InterSystems Caché or IRIS on the Gartner Peer Insights and get two $25 VISA Cards - one from Gartner Peer Insights and one from InterSystems! 

We had this promotion in 2018-2019, and now it's so good to announce it also for 2020!

 

See the rules below.

Last reply 5 February 2020
+ 2   0 1
175

views

+ 2

rating

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

0   0 1
0

replies

29

views

0

rating

Hi Community!

Coding guidelines discussion. Consider you have For with one command in the cycle. Here are the options:

One

For i=1:1:1000 set ^Test(i)=""

Two

For i=1:1:1000 {
 set ^Test(i)=""
}

Same for the "If":

if a set b=a

or

if a {
 set b=a
}

Your choice? Or maybe even other options? 

Last reply 4 February 2020
+ 2   2 18
1,127

views

+ 2

rating

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).

 

Last reply 4 February 2020
0   0 1
79

views

0

rating

Hi Community,

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

⏯ What Keeps Developers Up at Nigh

 

+ 2   0 1
0

replies

60

views

+ 2

rating

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 :

Last reply 4 February 2020
0   0 0
93

views

0

rating

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. 

Last reply 4 February 2020
+ 3   0 5
124

views

+ 3

rating

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

+ 1   0 1
0

replies

32

views

+ 1

rating

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

Last reply 3 February 2020
+ 9   3 5
739

views

+ 9

rating

Over the last couple of weeks the Solution Architecture team has been working to finish off our 2019 workload: this included open-sourcing the Readmission Demo that was brought to HIMSS last year, so we could make it available to anyone looking for an interactive-way of exploring the tooling provided by IRIS.

 

+ 4   0 2
0

replies

53

views

+ 4

rating

Hi, everyone!


I want to share a personal project that started with a simple request at work: 

Is it's possible to know how many Caché licenses we are using? 

Reading other articles here in the community, I found this excellent article by  David Loveluck 

Last reply 30 January 2020
+ 8   7 6
751

views

+ 8

rating

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:

Last reply 30 January 2020
0   0 1
86

views

0

rating

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.

Last reply 30 January 2020
0   0 2
69

views

0

rating

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?

0   0 0
107

views

0

rating

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

Last reply 30 January 2020
0   0 4
174

views

0

rating

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.

Last reply 29 January 2020
0   0 1
100

views

0

rating