Hello My Friends,

I have a question how to use order by %DLIST, this is my code:

SELECT

$ListToString(%DLIST(DISTINCT MRDIA_ICDCode_DR->MRCID_Code),', ' ) ICDX,

$ListToString(%DLIST(DISTINCT (MRDIA_ICDCode_DR->MRCID_Desc || ' (' || MRDIA_DiagnosisType_DR->DTYP_Code || ')')),', ' ) Diagnose

FROM SQLUser.PA_Adm

LEFT JOIN SQLUser.PA_AdmInsurance ON (PAADM_RowID = INS_ParRef AND INS_Rank = 1)

LEFT JOIN SQLUser.PA_AdmPackage ON (PAADM_RowID = PACK_ParRef)

LEFT JOIN SQLUser.MR_Adm on MRADM_ADM_DR = PAADM_RowID

LEFT JOIN SQLUser.MR_Diagnos ON MRADM_RowId = MRDIA_MRADM_ParRef

LEFT JOIN SQLUser.OE_Order ON PAADM_RowID = OEORD_Adm_DR

LEFT JOIN SQLUser.OE_OrdItem AS OD1 ON OEORD_RowId = OEORI_OEORD_ParRef AND OEORI_Categ_DR = 20 AND OEORI_ItemStat_DR <> 1

LEFT JOIN SQLUser.OE_OrdItem AS OD2 ON OEORD_RowId = OD2.OEORI_OEORD_ParRef AND OD2.OEORI_Categ_DR = 11 AND OD2.OEORI_ItemStat_DR <> 1

WHERE

PAADM_ADMNo IS NOT NULL AND PAADM_Type = 'E'

AND PAADM_AdmDate >= '2024-11-01' AND PAADM_AdmDate <= '2024-11-25'

GROUP BY PAADM_RowId

and this is the result

and What I need is how to order by the Diagnose Colum like (M) for the first and (S) for second and (C008) for the last ?

like this one

Does anyone could help me ? 

Thank You

Best Regards,

Steve Henry

Welcome to the Q4’2024 quarterly platforms update.  I hope that your 2024 has been incredible and that 2025 is even better. 

If you’re new to these updates, welcome!  This update aims to share recent changes as well as our best current knowledge on upcoming changes, but predicting the future is tricky business and this shouldn’t be considered a committed roadmap. 

With that said, on to the update…

InterSystems IRIS Production Operating Systems and CPU Architectures

Red Hat Enterprise Linux

• Previous Updates
  • We’ve completed minor OS certification for RHEL 9.4 & 8.10 on IRIS 2024.1 without incident.
• Upcoming Changes
  • The next major update for RHEL will be RHEL 10 which is expected in Q2 of 2025.
  • Short-term-supported 9.5 & 8.11 were released earlier this month, and we’ve started minor OS certification on IRIS 2024.1.
• Further reading: RHEL Release Page

Ubuntu

• Previous Updates
  • We’ve completed minor OS certification for Ubuntu 22.04.3 on IRIS 2024.1 without incident
• Upcoming Changes
  • We’re currently doing minor OS certification on Ubuntu 24.04.1.  So far, so good.
• Further Reading: Ubuntu Releases Page

SUSE Linux

• Previous Updates
  • SUSE Linux Enterprise Server 15 SP6 was released in May.  The release notes can be found here.
  • General Support from SUSE for Linux Enterprise Server 15 SP3 came to an end on 12/31/2022, but extended security support will continue until December, 2025.

Further Reading: SUSE lifecycle

Oracle Linux

• No updates
• Further Reading: Oracle Linux Support Policy

Microsoft Windows

• Recent Changes
  • Windows Server 2025 was released earlier this month and we’ve begun the process of adding support for the platform.
• Upcoming Changes
  • Microsoft has pushed back the anticipated release date for Windows 12 to sometime in 2025.  We’ll start the process of supporting the new OS after it’s been released.
• Further Reading: Microsoft Lifecycle

AIX

• Recent Changes
  • IRIS 2024.3 and up will only support OpenSSL 3. NOTE:  This means that 2024.2 is the last version of IRIS that has both OpenSSL 1 and OpenSSL 3 kits.  In IRIS 2023.3, 2024.1, & 2024.2, we provided two separate IRIS kits – one that supports OpenSSL 1 and one that supports OpenSSL 3.  Given the importance of OpenSSL 3 for overall system security, we’ve heard from many of you that you’ve already moved to OpenSSL 3.
• Further Reading: AIX Lifecycle

Containers

• Previous Updates
  • We changed the container base image from Ubuntu 22.04 to Ubuntu 24.04 with IRIS 2024.2
  • We’re considering changes to the default IRIS container to, by default, have internal traffic (ECP, Mirroring, etc) on a different port from potentially externally facing traffic (ODBC, JDBC, etc).  If you have needs in this area, please reach out and let me know.

InterSystems IRIS Development Operating Systems and CPU Architectures

MacOS

• Upcoming Changes
  • Apple has released MacOS 15 and we are planning support for it in IRIS 2025.1

InterSystems Components

• Previous Updates
  • InterSystems API Manager 2.8.4.11 & 3.4.3.11 have been released.  If you’re using IAM, please upgrade soon.
  • InterSystems Reports 24.1 has been released.

Caché & Ensemble Production Operating Systems and CPU Architectures

• Previous Updates
  • A reminder that the final Caché & Ensemble maintenance releases are scheduled for Q1-2027, which is coming up sooner than you think.  See  Jeff’s excellent community article for more info.

InterSystems Supported Platforms Documentation

The InterSystems Supported Platforms documentation is the definitive source information on supported technologies.

• IRIS 2024.1 Supported Server Platforms
• IRIS 2023.1 Supported Server Platforms
• IRIS 2022.1 Supported Server Platforms
• Caché & Ensemble 2018.1 Supported Server Platforms

… and that’s all folks.  Again, if there’s something more that you’d like to know about, please let us know.