Hi Community,

You may know that you get rewarded with points on Global Masters for each your application published on Open Exchange. Recently we introduced bonus points for ZPM applications. So now, you get extra 400 points for each ZPM application! Points are automatically adjusted.
Check out points & available rewards on Global Masters - and see you there today!

I'm looking for a means to dynamically specify and/or limit the data from the source that goes into a cube at build time.

I have a single data class that defines my source, and as the data within this table/collection grows/changes over time, I would like to be able to control which records actually make it into the indexed cube, but I'm having a hard time (short of defining a stored procedure to use instead of the extent query) for populating my cube indexes.

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.

Background

For a variety of reasons, users may wish to mount a persistent volume on two or more pods spanning multiple availability zones. One such use case is to make data stored outside of IRIS available to both mirror members in case of failover.

Unfortunately the built-in storage classes in most Kubernetes implementations (whether cloud or on-prem) do not provide this capability:

Greetings.

I am working on a demand wheres i need to find all the possible combinations of number contained in a string, its works very well, but when the total numbers is increased bigger, the time to execute the code is increased exponentially. Theres a beter way to find combinations then recursively?

string data:

Hello all !!! I have a question: i heard it is possible to write Object Script code for Intersystems in VSCode. How it is possible to connect the InterSystems terminal to VSCode terminal ? I heard there should be a special docker. Currently i am trying to run a simple code which will communicate with the user through the terminal but it throws an error. thank you in advance for the answer !

Hi Developers,

This September, you've posted 78 new questions on the Developer Community:

These two articles describe how to extend business components with additional properties:

1. https://community.intersystems.com/post/how-customize-ensemble-settings

2. https://community.intersystems.com/post/creating-custom-captions-interop...

In our latest episode of Data Points, I had a conversation with George James, CEO of George James Software, about the importance of source control and developer tools, George James Software's own solutions, and their partnership with InterSystems. Take a listen, and visit https://georgejames.com to learn more about George James Software!

https://5e18edf067eb59-03854285.castos.com/player/1394422
[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]

Hi all,

I am currently wokring on integrating unit tests into a project. I am also attempting to test productions with the TestProductions class. This works great, but I noticed that no code coverage information is being gathered when I run the production tests?

Am I doing something wrong (forgot to add something in the coverage.list for instance) or is TestProduction not intended for code coverage?

Thanks!

This message links to 14 recent advisories that were posted on the InterSystems Product Alerts and Advisories page. All of the items affect HealthShare products, and the first three items affect InterSystems IRIS for Health as well.

October 26, 2021 – Alert: Missing Locks after ECP Database Server Restart or Failover

Hi ,

I tried to import Custom schema with 'Z' segment. I executed "Do ##class(EnsLib.InteropTools.HL7.MessageAnalyzer).Interactive()" in IRIS Terminal.

After executed the steps, i am getting below message, So i could not able to add z segment into my customschema 'Test_2.3'
------------------------------------------------------------------------------------------------
Summary Report for workspace C:\Demo\Migration\Workspace
Schema is Test_2.3
ALL: 0 matched, 1 unmatched

Hi Developers!

I'm pleased to announce the September release notes of the InterSystems Open Exchange!

Here is what the new release introduces:

• Better performance;
• Better UX;
• Discuss and Issues tabs on the application page.

See the details below.