I receive a time stamp as = 1988-08-18 00:00:00.000
I need this to be converted as - 1988-08-18T00:00:00+01:00

I'm attempting to build a fairly complicated object graph, with nested objects and collections, in order to create a FHIR bundle.

In its most basic form there is a <bundle></bundle> element that represents the root, and there can be a number of nested <entry></entry> child elements.

I'm attempting to represent this as such:

I am experiencing an issue while executing a stored procedure in InterSystems Cache. Here’s the procedure I created

CREATE PROCEDURE Silk.sp_InsertRecord (
IN RecordDate TIMESTAMP,
IN UserName VARCHAR(50),
IN RecordType INT,
IN RecordID VARCHAR(50),
IN CategoryID INT,
IN ApprovalDate TIMESTAMP,
IN FileSize BIGINT,
IN WorkstationName VARCHAR(50)
)
BEGIN
INSERT INTO DummyRecords (
RecordKey,
FilePath,
RecordDate,
UserName,

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?

Hi Community!

It's been a month since the end of the Global Summit 2024 (here is a brief reminder of how it went: part 1 and part 2), and you may want to relieve the excitement or, maybe, wish to see the sessions. This is your chance to influence the order in which the sessions are published here, on the Developer Community.

Please vote for your favorite topic and we will use YOUR votes to plan our announcements! 😉

Hi Community,

Play the new video on InterSystems Developers YouTube:

⏯ Clinica Universidad de Navarra - Low on Budget High on Innovation @ Global Summit 2023

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

I have a spring-boot Java application which has Quartz Scheduler (spring-boot-quartz-starter) dependency, and uses IRIS DB.
There is a problem with making Quartz Scheduler work with IRIS since there is a blob field expected in two tables, but IRIS is using longvarbinary type.
Can you provide me with clues on how to resolve this?

I am using org.quartz.impl.jdbcjobstore.StdJDBCDelegate driverDelegateClass.

This is the error:
MisfireHandler: Error handling misfires: Couldn't retrieve trigger: invalid stream header: 41434544

Hi Guys,

I've created a website and set the path to my csp pages in Web application setting and can populate all my .cls zen pages with no issues but when it comes to CSP pages I always get sent back to login page am I missing something in security ?

Thanks

Monitor incremental changes in the database through scheduled tasks, display change trends through charts, set alarm thresholds, and write information to messages.log

How to use it

You can install it through Docker or ZPM

Deploying with Docker Prerequisites

Make sure you have git and Docker desktop installed.

Hi Guys,

I'm using the following to display JSON content in an areatextbox, but I would like to change a value in my JSON before displaying it in my areabox?

Hi there, I'm wondering if anyone has run into an issue with <FILEFULL> when building an image from the ISC image? Specifically what's happening in our build is we are pre-loading our codebase into the image to make deployments faster and setting up source control, etc. When loading our libraries however we get hit with a <FILEFULL>. The resource limits on docker are pretty beefy and when observing resources on both the machine and container level we don't hit any issues. Oddly, this only happens when using the ARM64 version.

Hi, Community!

Need to learn how to write better prompts for GenAI? This video from Learning Services introduces six key strategies:

▶ Optimizing Your Prompts for Generative AI

https://www.youtube.com/embed/nBnm84cNMQo?utm_source=youtube&utm_medium=social&utm_campaign=nBnm84cNMQo
[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]

Hello Community,

Is there any option or log is available to identify who killed/terminated the running process?

Thanks!

I am available to engage on projects as an Iris Healthcare Consultant, leveraging over 20 years of e