I've got a select statement bringing back one value, I want to combine all rows into one comma delimited string. So for example:

SELECT First Name

FROM mydb.People

I get a list of names:

John

Fred

Sarah

Carl

Jane

Julie

Instead of having 6 rows in the result, I want one row, with one cell that has "John,Fred,Sarah,Carl,Jane,Julie"

Is there a way to do that?

Please allow me to introduce you to a new way of interacting with IPM (InterSystems Package Manager), also known as ZPM,directly from inside Visual Studio Code.

First, install into VS Code the free InterSystems Package Manager extension, published to Marketplace by George James Software. A quick way is to use the search field in VS Code's Extensions view and look for 'ipm zpm' (without the quotes). Alternatively browse to https://marketplace.visualstudio.com/items?itemName=georgejames.iris-pa…

Here's a short video showing the extension in action.

hi everyone,

I'm trying to make some use of AI to help with coding. To achieve this I've moved to VS Code linking to a cache instance, and installed the "Cody" extension from Sourcegraph that talks to Claude Sonnet.

In theory Cody can view, and send to the AI, the file I'm currently editing. However, it does not seem to "see" Cache server items, and only works for stuff in ordinary files that I have open. Is this an issue with "isfs" ("InterSystems File Service" that implements the "filesystem provider API" )? Is anyone else using Cody or any other AI extension successfully?

Thanks,

Mike

I need to execute code whenever a production component setting is updated, such as when a service port is changed and the `ens.config` table is updated. This code will handle tasks like logging these updates to a custom table for external reporting purposes.

How can I invoke custom code on these updates?

Ideally, I need to monitor all namespaces that are interoperability-enabled. Whenever a production component setting is changed in any namespace, I need to run the code.

Hi Guys,

I'm using the below simple Get Webservice to return a JSON file, its working but the response is actually of Text type not JSON Type 

ClassMethod cmGetHomes(cnt1, cnt2) As %Status
{    S response="{""Land"""_":"_""""_cnt1_""",""Home"""_":"_""""_cnt2_"""}"
 // set dataObj=##class(%DynamicObject).%FromJSON(response.data)
 //set response.data = dataObj
 //W response.%ToJSON()
 //set response.data = {}.%FromJSON(response.data)
 //set response.data = {}.%FromJSON(response.data)
 W response
 Quit $$$OK
}

This is the response that I'm getting in Postman

But it says type is text not JSON 

Thanks

We are doing healthcare interface development.

Developers have Ensemble installed locally on their laptops - code will be developed locally then deployed to integration, test/UAT and ultimately production servers in due course.

One of the other applications we are developing around happens to utilise an Iris desktop client to a remote Iris server. We want to have the application available on the developers laptops alongside the local Ensemble instance.

✅ It appears that if we install their desktop client then install our local Ensemble server, things work.

Hello,

I'm trying to debug objectscript ClassMethods in VSCode, but nothing happens when clicking the Debug button over the ClassMethod.

This was working with previous versions - tested with IRIS 2020.

This is the server configuration:

"intersystems.servers": {

        "iris": {

            "webServer": {

                "scheme": "http",

                "host": "localhost",

                "port": 80

            },

            "username": "superuser"

        }

    },

Editing and compiling ObjectScript is working:

Hi Developers!

We are happy to present the bonuses page for the applications submitted to the DevTools Contest 2024!

Hi Community,
In this article, I will introduce my application iris-DataViz
iris-DataViz is an Exploratory Data Analysis and Visualization Streamlit Application that leverages the functionality of IRIS embedded python and SQLAlchemy to interact with IRIS, as well as the PyGWalker python library for data analysis and data Visualization. PyGWalker (Python Graphic Walker) is an interactive data visualization library built for Python, aiming to bring the ease and functionality of Tableau-style drag-and-drop visualization into Python environments.

Application Features 

Hi everyone,

In this article, I’m excited to introduce CodeInspector, a tool designed to simplify code validation by applying custom rules tailored to your development requirements. Whether you're managing a large codebase or working in an agile environment, CodeInspector helps ensure code quality by offering flexibility and adaptability to specific project needs.

Motivation

If you are using the client-side development paradigm (i.e. editing code in local files that get imported and compiled onto the IRIS server your `objectscript.conn` settings point to) you can now use IPM in VS Code to manage the packages in your IRIS target by launching it from the Explorer view. Just make sure the extension you are using is at least version 1.0.4, then use this button:

Thanks to @Evgeny.Shvarovfor suggesting this enhancement, which is particularly useful when using Docker.

Hi Community,

It's voting time! Cast your votes for the best applications in our Developer Tools Contest:

🔥 VOTE FOR THE BEST APPS 🔥

How to vote? Details below.

Introduction

Managing databases and performing CRUD operations are fundamental tasks for developers building data-driven applications. While many database management systems (DBMS) exist, they can be complex and cumbersome to interact with, especially when it comes to creating databases and tables, handling constraints, and performing real-time data operations through an API.

This story has followed me for more than 20 years.

In the early days of ObjectScript, the volume of $Functions was limited.
You had to write it as part of your program.
But the functionality was often implemented. It just had no name.
To use it, you had "system" calls using $ZU() functions. See Reference

The test data generator is mainly used to generate test data, which can be used to generate test data for tables and fields to meet the needs of different fields according to different types, currently supports Text, Number, Enum, UUID, regular expression, Multiple date and time formats, and Time Seven different types
 

How to use:

1. Select a namespace, you can see all the tables under the namespace,

2. Select the table we want to generate test data from, click on the field, and select the type on the right

I created and then compiled a routine using the %Routine library 

s routine = ##class(%Routine).%New(fileName_"."_extension)
d routine.Write(parsedRule)
//s status = routine.Save()
s status = routine.SaveStream(,.refresh)
if ($$$ISERR(status)) throw status

Now the routine compiles successfully and as a result it is saved on the database.
I can now use from anywhere:

set r = ##class(%Routine).%New("myGeneratedCode.mac")

w r.SizeGet()

I want to try out iris-DataViz app to visualize my own data. I cloned the repo and docker-compose up -d in AWS. IRIS portal works, but on port 8051 I get nothing. I checked my AWS security groups. I reversed IRIS webserver port and 8051 and I can connect to Management portal using port 8051. I don't understand what is refusing connection on port 8051 running in iris-DataViz container.

Hi Community,

Play the new video on InterSystems Developers YouTube:

⏯ Large Language Model Use Cases in Healthcare @ Global Summit 2024

I am trying to insert a single row into an external MS SQL Server table. I have set up the SQL Gateway. The insert query runs, but it is inserting an extra row each time. 

What am I missing:

#include %occInclude
set gc = ##class(%SQLGatewayConnection).%New()
if gc = $$$NULLOREF quit $$$ERROR($$$GeneralError, "Can not create sql gateway connection.")

set pDSN = "xxxx"
set usr = "xxx"
set pwd = "xxxx"
set sc = gc.Connect(pDSN,usr,pwd,0)
if $$$ISERR(sc) quit sc
if gc.ConnectionHandle = "" quit $$$ERROR($$$GeneralError,"connection failed")set sc=gc.AllocateStatement(.hstmt)
if $$$ISERR(sc) quit sc

In this article, we’ll dive into the inner workings of the database management tool, exploring the architecture and technologies that power it. Understanding how the application functions behind the scenes will give you insight into its design, how it manages databases, tables, and how the API interacts with data.

We will discuss the core technologies used, including InterSystems IRIS as the primary database and Redis for caching. Additionally, we’ll break down the structure of the tables used and explain how the system handles data creation, retrieval, and manipulation through the REST API.

Hello community

I sent a http post message with a large message body (approx. 200 kB) to a standard EnsLib.REST.GenericService using a standard EnsLib.HTTP.InboundAdapter.

When inspecting the message in the message viewer I expected to see a HTTPMessage XML in the Contents preview, but I found a GenericMessage with no HTTPHeaders section. After a while, I found out that the display in the message's Visual Trace differs from what is shown, when going to the View Full Contents view in the Contents tab of the message viewer.

Hi,

I tried to create what is know as a "class variable".  As far as I understand the only analogy to class variables would be the "class parameters".

I tried to use a class parameter but I cannot change its value at runtime.

Parameter STATUSES = {{}};

Property repr As %String;

Method %OnNew(repr) As %Status
{
    w ##class(Test...).#STATUSES
    w ..#STATUSES

    ...

}

When I get ..#STATUSES, it is a string like "5@%Library.DynamicObject". This is a string, not a pointer to an object.

I tried to define STATUSES as Parameter STATUSES  As CONFIGVALUE = {{}};  and change the value with  

Hi Community,

Are you ready to transform your healthcare organization with the power of Artificial Intelligence? Join us for an enlightening webinar that will equip you with the knowledge and tools to harness AI effectively in your practice.

🌐 Are you and your data AI ready? 🌐

📅 Tuesday, 15th October, 1 pm ICT | 2 pm SGT| 4 pm AEST // 8 am CEST |  2 am EDT 

🗣 Presenter: @Kathleen Aller, Global Head of Healthcare Market Strategy, InterSystems

Hi ,

I am sending my DTL response (which is an xml stream) to an FTP out location.

My XML stream has CRLF , but after sending FTP'ing out , it displays as LF

before writing it to FTP

At FTP out location

What Chatset will do it ? Currently Charset is set as Binary.

Appreciate quick response.

Hi everyone,

I'm struggling with the extraction of information from the following XML:

See the new team members in action:

Try them online for yourself:

https://gitpod.io#snapshot/b31bdf9c-4657-402a-a2d

Get it from the Extensions view inside VS Code, or here in Marketplace.

Vote for it here in the current Developer Tools 2024 contest (voting ends: 29 Sep, 2024, 11:59:59 PM EST).

Discuss it below.

Most of all, enjoy DX Jetpack with its added booster rockets!

Hi, Support Team

I´m working with Cache for many years, currently i have running version cache-2018.1.7.721.0-win_x64.exe

However we are facing some compatibility/requirements challenges, in that way i´m hereby request your support to provide next version/build of Cache 2018.1 (e.g cache-2018.1.9.xxx.x-win_x64.exe )

Nevertheless , I already downloaded IRIS for testing purpose if can also provide trial/limited licence for detail testing will be apreciated.

Thanks in advance for your attention.

Regards

Rajendra

Hi, Community!

Want to improve accuracy and data integrity in your relational databases? Learn a key strategy in this video:

Setting Up SQL Foreign Key Constraints

InterSystems FAQ rubric

On Windows, this cannot be changed, but on Unix-like platforms, it can be changed using the iris rename command.

iris rename instname(<current instance name>) newname(<new instane name>)

For more information about the iris rename command, please refer to the following document:

About the iris command