Hi Developers!

Welcome to the 7th edition of the InterSystems Ideas news bulletin! Read on to learn what has happened on the Ideas Portal since the previous bulletin:

​​​​✓ More than 200 ideas are already on the portal

✓ Idea was implemented by a Community member

✓ Implement an idea and get a tech bonus on the Grand Prix 23 Contest

✓ Ideas posted recently

A Minute Of Laughter on the Developer Community with #InterSystemsMemes.

Here is the Holiday edition of the memes sent/created by Developer Community members!

Enjoy the memes and don't forget to check our Winter Holiday challenges on Global Masters (available till Jan 2).

1. Meme author: @Udo Leimberger

What's a good way to add a custom hyperlink to a table item in Clinical Viewer (CV2)? I am customizing the Diagnostic Studies page, and have a custom transform that returns the HTML code for the hyperlink. The hyperlink is supposed to open a custom CSP page in a new window or tab.

Using the layout editor, I then tried adding several "items" to the table like an Icon or External Viewer Link, and use the custom transform to get the hyperlink, but these items only show up as plain text and do not link to any page. How do I turn these items into a hyperlink?

Hi,

What is the difference between $Increment and $Sequence functions ?

Thanks

Hi.

Is it possible to convert the object of type %SerialObject to $List form? I'm using embedded class in unique index and I want to use autogenerated method Open to access the object - parameter should be in $List form...

Tnx.

Regards,

Matjaž

Some of the templates in Atelier display "on" in the "Auto Insert" column. I can't figure out how they differ from the ones that aren't so marked. Some Googling suggests that it should insert without displaying the template popup if there is only one matching template. However, I see the popup every time.

Hi all,

We're in the process of creating several courses for creating custom business components for productions. This includes custom business operations, BPL processes, and custom business services. Custom Business Operations and Custom Business Services are both aimed at software developers while BPL processes can be also be created by business analysts. What are some gotchas or best practices you've learned that you wish you knew when first building these components?

We'd love to include what you've learned into these courses so others can learn from them as well!

Hello!!!

Data migration often sounds like a simple "move data from A to B task" until you actually do it. In reality, it is a complex process that blends planning, validation, testing, and technical precision.

Over several projects where I handled data migration into a HIS which runs on IRIS (TrakCare), I realized that success comes from a mix of discipline and automation.

Here are a few points which I want to highlight.

1. Start with a Defined Data Format.

Before you even open your first file, make sure everyone, especially data providers, clearly understands the exact data format you expect. Defining templates early avoids unnecessary bank-and-forth and rework later.

While Excel or CSV formats are common, I personally feel using a tab-delimited text file (.txt) for data upload is best. It's lightweight, consistent, and avoids issues with commas inside text fields.

PatID   DOB Gender  AdmDate
10001   2000-01-02  M   2025-10-01
10002   1998-01-05  F   2025-10-05
10005   1980-08-23  M   2025-10-15

Make sure that the date formats given in the file is correct and constant throughout the file because all these files are usually converted from an Excel file and an Basic excel user might make mistakes while giving you the date formats wrong. Wrong date formats can irritate you while converting into horolog.

Hey Developers,

Start watching the new video on InterSystems Developers YouTube:

⏯ Using Embedded Python as a Jupyter Notebook Server @ Global Summit 2023

https://www.youtube.com/embed/77oPUfltu0o
[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,

Is there a way to find the median in Intersystems Cache SQL? I know it is not available as an aggregate function. Also in SQL Server I could try something like:

SELECT
(
 (SELECT MAX(Score) FROM
   (SELECT TOP 50 PERCENT Score FROM Posts ORDER BY Score) AS BottomHalf)
 +
 (SELECT MIN(Score) FROM
   (SELECT TOP 50 PERCENT Score FROM Posts ORDER BY Score DESC) AS TopHalf)
) / 2 AS Median

However, there is no PERCENT Keyword in Cache as well. Any suggestions?

Thanks

Hi ,

I have a requirement to programmatically fetch and update a Business Process Setting . It's a custom property , added in extended class .

I am trying find a sample, but no luck.

Could any one help me ?

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)

Hi Everyone!

One more session recording from Global Summit 2018 is available on InterSystems Developers YouTube Channel:

InterSystems IRIS in a Container

https://www.youtube.com/embed/gaZfBdQYnVE
[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 there,

is there a way to reload or clear the content to zen dataCombo from a ZenMethod?