All time
Article
· Mar 2, 2021 1m read
Vote for us 
Hotel Overbooking in hospitality industry

This is the first InterStstems programming contest that we participated in! Come check out and vote for us!

3 1
0 205
InterSystems Developer Community is a community of 25,691 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

Hi

My HIS System is a Microservice architecture base dubbo. To call remote service must through dubbo rpc.

But , I canot direct call his's dubbo service because ensemble cannot support dubbo protocol.

So I want to add support to ensemble.

where Can I start?

Does ensemble has low level interface like dll or linux so, I can add dubbo support to the ensemble just by implementing these interfaces.

I known java Gateway maybe ok, but I want to direct not throught middle layer to do this.

0 1
0 224

Hi Community,

The new video from Global summit 2019 is already on InterSystems Developers YouTube:

⏯ Adopting InterSystems IRIS

https://www.youtube.com/embed/UrI0JMkm1h0
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
0 225

In my previous article, Using LIKE with Variables and Patterns in SQL, we explored how the LIKE predicate behaves in different scenarios, from Embedded SQL to Dynamic SQL, and what happens to performance when wildcards and variables come into play. That piece was about getting comfortable writing a working LIKE query. But writing SQL that works is only the starting point. To build applications that are reliable, scalable, and secure, you need to understand the best practices that underpin all SQL, including queries that use LIKE.

This article takes the next step. We’ll look at a few key points to help strengthen your SQL code, avoid common pitfalls, and make sure your SELECT statements run not just correctly, but also efficiently and safely. I'll use SELECT statements with LIKE predicate as an example along the way, showing how these broader principles directly affect your queries and their results.

*This is what Gemini came up with for this article, kinda cute.

10 0
1 224
Discussion
· Apr 12, 2025
Code Golf - Maximum Coverage

There is a list of numbers from 1 to 190.

AllList="1,2,3,4,5,6,7,8,9,.....,187,188,189,190"

There is a collection of sets of these values:

List(1)="3,5,6,7,9"
List(2)="1,2,6,9"
List(3)="5,8,9"
List(4)="2,4,6,8"
List(5)="4,7,9"

What is an elegant approach in Object Script to pick the least number of list items:

  • List(1)
  • List(5)
  • List(n)

That together would cover as many numbers as possible from the AllList.

Interested in best coverage over efficiency.

1 7
0 217
Question
· Jul 25, 2024
Read an XML response

I receive response from Business Operation(HTTP GET) as below :

<response>
<message_code>202</message_code>
<message_string>Success/message_string>
</response>

I am not able to read the "message_code" as response.message_code ?
is it because of underscore ?
Is there a way to read it ?

0 4
0 220

Hi Community,

Watch this video to learn how to improve care and reduce costs with the HealthShare Care Management Notifications Solution Pack, a fully managed cloud solution from InterSystems.

⏯ What is the HealthShare Care Management Notifications Solution Pack

https://www.youtube.com/embed/phJSD5axnk0
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

🧑‍🏫 Course developer: @Kate Lindsay. If you have any comments, please don't hesitate to tag her.

0 0
0 224

Hi all

I need to do hardware maintenance on a physical HealthConnect server which forms one half of a mirrored pair, and It will require multiple restarts.

So, I will need to prevent any HealthConnect services from restarting until all maintenance is completed. Is this just a case of disabling the service "HealthConnect Controller for <SERVERNAME>", or is there anything else I need to be aware of?

Andy

0 2
0 222

Hi Community,

We invite you to take part in the Health Data De-Identifier Early Access Program. Sign up, tell us your feedback and grab some nice points: 2000 to all participants, 5000 extra for completing the survey.

If you are interested:

1️⃣ Join EAP group via this challenge

2️⃣ Follow these instructions

3️⃣ Complete the survey (leave your email so we could award the points on Global Masters; please note: you must be EAP participant in order to proceed with survey completion)

3 0
0 224

Try a new (free!) self-paced online program! Programs include everything you need to start using InterSystems products in your role. You can easily track your progress through an entire program, or select only the learning materials you need.

Two InterSystems IRIS for Health™ programs are open to all customers:

Two programs are available to HealthShare® customers:

1 0
0 224

Only a few days to go until the Global Summit! George James Software will be on hand to talk about any projects you may have on the horizon, such as application development, data and platform migration, system integration, training, and support – we can work with you to find practical and maintainable solutions that support the growing needs of your organization.

We're also running a User Group Session on Wednesday, July 22nd at 12pm. It's a great opportunity to find out more about our tools and ask us (and current users!) any questions.

3 0
0 224

Hi, I am new to InterSystems database. I am developing an application to display real time skillset statistic data, including max waiting time per skillset. I have access to the database through ODBC, using InterSystems ODBC driver. But I don't know from which table or view to get real time data of maximum waiting time per skillset. I appreciate any advices.

0 3
0 221

Hello gentlemen,

I hope you can help me because this is a very serious that I can't wait to resolve... Our back-up is currently taking 3 up to 4 Gb per day and we don't know why. We had 270 Gb yesterday and we are today at 274.3 Gb. We keep a computer history of the messages for only 50 days. Here is a picture of what's currently taking the most data place in our healtshare system:

(don't forget that our DB is also connected to the back-up, maybe it is related, I don't know)

0 1
0 223

InterSystems FAQ rubric

By default, the order of columns in a table is determined automatically by the system. To change the order, explicitly set the order for each property using the property keyword SqlColumnNumber when defining the class.

Example:

Property Name As %String [SqlColumnNumber = 2];

Please see the documentation below.

8 0
0 223

Hi,

Hi have problems to import globals, this is a testing only.

From Caché (v.2012, very older, 8 bits character, Latin1 encode) I created a file exporting globals, file *.gof with de web system utilities,.

When I import these globals to Iris (v2024.1 16 bits character), the restore utility show this error:

0 2
0 221

I know that you can use Do $SYSTEM.SQL.Schema.ImportDDL() to insert sql files into IRIS however I was wondering if there is a way that I can upload .sqlite files into iris? I have about 20 .sqlite files that I need to get into my database. I tried using the ImportDDL method but it said "SKIPPING non-SQL SOURCE:"

0 6
0 217