InterSystems Developer Community is a community of 20,948 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more
Discussion
· Jan 10, 2021
Code Golf: Diamonds
To start the year let's have a round of CodeGolf!

You know the drill. Shortest solution wins.

Print a size ascending range of Diamonds using the numbers 1 to 9, ranging from size 1 to size N, each diamond separated by a blank line.

A size 1 diamond should look like this, a single centered 1:

         1

With the size N=9 diamond looking like this:

2 19
0 510

DataGrip is a multi-engine database environment targeting the specific needs of professional SQL developers, DataGrip makes working with databases an enjoyable and productive experience.

To work with InterSystems IRIS from DataGrip you'll need to add InterSystems JDBC driver first (once per DataGrip) and after that add all your InterSystems IRIS connections.

Part 1: Add InterSystems IRIS JDBC Driver

1. Go To File → DataSources

1 0
0 725

We've our Cache running on Windows 2012 Server, but I've a Macbook Pro. Earlier I was using Miscrosoft Remote Desktop 8, to remote into our Windows server & everything worked.

Since version 8 is discontinued, I installed Microsoft Remote Desktop 10.5, which works for everything except starting Terminal.

I get error 'NTI Connection Error'

(287) Error writing to Pipe
Reason: (998) Invalid Access to Memory Location.

If I do remote desktop from Windows machine (using same credentials), it works.

0 2
0 428
Article
· Sep 10, 2020 3m read
How To Create "Write-Only" Code

One of the leading benefits of ObjectScript is the speed and efficiency it allows for an experienced developer. Let's look at an example of how you can benefit from ObjectScript today.

Suppose you have a class that stores the names of your users. We'll call the class Data.User, and give it a string property Name. Next, we will need a method to create a new user or update an existing one. A naive, simplistic approach might look like this example:

6 10
0 636

Given a complex method flagged with [ SqlProc ] so it is available as an SQL stored procedure, what's the best way to report a non-system error detected in that method - say, for example, an error %Status - so that the SQL query calling it fails descriptively? Is it best to create and throw an exception, or are there special % variables involved (like in a trigger)? I haven't been able to find an answer in the documentation.

Thanks in advance!

0 2
0 412

Hey Developers,

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

New Videos
№ Video Views
1 Building a REST API with InterSystems IRIS 147
2 InterSystems Developer Ecosystem Services: Developer Community and Open Exchange 103
3 Embedded Python in InterSystems IRIS: Sneak Peek 79
4 InterSystems IRIS Native Python API in AWS Lambda 76
5 Using the DTL Generator in InterSystems IRIS 71
6 The Freedom of Visualization Choice: InterSystems BI 61
7 Putting a match to FHIR with Postman Newman 51
8 Online Meetup with the InterSystems Interoperability Contest Winners 50
9 InterSystems Analytics Contest Kick-off Webinar 43
10 Validating Your InterSystems Productions 15

4 0
0 109

Hey Developers,

This post is a compilation of Top Authors, Top Experts and Top Opinion Makers of the InterSystems Developer Community in 2020. And it is a good guide "Who to Follow" in 2021.

We're glad to present these people who have contributed a lot to our community in 2020.

Let's take a closer look at the DC Wall of Fame 2020 and greet everyone with big applause! 👏🏼

8 1
0 330
Question
· Jan 10, 2021
Cashe-SQL cursor

the report generates statics for each ward and i want to divide specific ward 5c into two wards, the first 12 beds are for 5c - pediatric and the last 12 beds are for 5c-adults.

the report takes input from the user by selecting the wards so if the user chooses 5c, the report should show 2 wards.

the report declare cursor at the begining so how can i divide the ward.

0 2
0 264

Executive Overview

In most organizations, events drive action. In financial services, for example, a stock dipping below a threshold price may trigger a sell order. In manufacturing, production may start when an order is received. In healthcare, an unusual increase in the number of patients registering in an emergency room could signal the start of a disease outbreak, calling for action on the part of medical staff and public health officials.

0 1
0 305

In 2020 we implemented HealthConnect as our HL7 interface engine. Having completed this, we are currently evaluating whether it would be beneficial to migrate our managed file transfers from our current MFT software, MOVEit to HealthConnect. I am interested in hearing from any InterSystems customers who have previously used MOVEit and currently using HealthConnect for file transfer managment. Any feedback would be appreciated.

0 2
0 309

Hi,

The question is about queries on the System->SQL page. I have a class with a few columns on a global and the test output looks as expected, below. This works as expected as well returning a single row: select * from Utils.RoutineAuditReport where counter=4. However, other columns give an odd error like " Field 'AG' not found in the applicable tables^ SELECT * FROM Utils . RoutineAuditReport WHERE UserR = "AG". As you can see below, both the UserR column and the AG entry in it do exist. What could be the problem?

Thanks in advance,
Anna

0 2
0 199

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems Analytics Contest!

Date & Time: Monday, January 4, 2021 – 10:00 EDT

What awaits you at this virtual Meetup?

  • Our winners' bios.
  • Short demos on their applications.
  • An open discussion about technologies being used, bonuses, questions. Plans for the next contests.

6 3
0 380

I am hoping I explain this correctly.

We are using a query expire edge, to pass an API request to one of our vendor systems.

There is no feed into the gateway from an external system, and it is only used to query the external system with member data.

However, it is our understanding that the member needs to be registered on the edge.

Wondering if there is a way to export from the registry the bare demographic info in SDA to import to the new edge?

0 2
0 164

Hi all! 2nd time poster and still kind of a newbie. I Googled and searched the posts but did not find anything quite like my question. I have an XML to HL7 2.6 MFN_M16 translation. I created an XML schema and I am using it inside a DTL to translate data to HL7. The XML is rather simple EXCEPT one element as data separated by pipes. This only happens when one item has multiple PAR Locations. To make a valid HL7 message these multiple PAR Locations each need their own IVT segment.

XML Par Location is equal to HL7 IVT:InventoryLocationIdentifier OR (IVT-2)

0 4
0 375
Hey Developers!

Please check out the 2020 annual Developer Community Posts digest. Don't miss the most popular and commented posts!
Most viewed

7 3
1 493
Job
· Jan 5, 2021
#Job Opportunity

We are looking to hire a DevOps engineer with expertise in Intersystems Technologies like Ensemble and/or IRIS as essential.


Main responsibility of the Role will be to implement Version Control and automated CI/CD pipeline for code build and deployment via tools and automation scripts for the current Intersystems platforms within the organisation.

If interested please email your resume to utsavi.gajjar@mater.org.au

0 0
0 419

I have an SQL text index defined like this

Index TextIndex On (Text) As %iFind.Index.Basic(IGNOREPUNCTUATION = 1, INDEXOPTION = 0, LANGUAGE = "en", LOWER = 1);

If I run a query like this:

SELECT
Text
FROM Post
WHERE %ID %FIND search_index("TextIndex",'ABC')

I get 20 results with posts containing the term ABC.

But each post can contain the term ABC several times.

0 13
0 441