All time
InterSystems Developer Community is a community of 25,581 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!

I'm trying to use the EnsLib.SQL.Operation.GenericOperation component in a production to read a column from a Redshift table that is set up as VARCHAR(65535) and am getting the following error.

An error was received : ERROR #5023: Remote Gateway Error: JDBC Gateway getClob(0,1) errorRemote JDBC error: Cannot convert the column of type VARCHAR to requested type long..

1 5
0 185

Hello Community,

I have below issue -

I have an ID with 123456.(ID as a dynamic value coming from request message)

I wanted it to be displayed as "123456" in Json Stream.

Code Example:

set object = ##class(%ZEN.proxyObject).%New()

set object.ID = ID

set x = ##class(%ZEN.Auxiliary.jsonArrayProvider).%WriteJSONStreamFromObject(.json,object)

Case:1
ID : 123456

Will output:

{

"ID": 123456

}

but I need :

{

"ID": "123456"

}

0 3
0 187

Hi All! For those of you who are users of our cloud services, you may have been introduced to Health Connect Cloud. One topic within that cloud service that can be a little tricky is understanding how GitLab and the source control workflow fit seamlessly into your integration workflow in Health Connect Cloud. I recently presented a lightboard video explaining how this works, including the slightly different workflows for building interfaces via code versus building via the Management Portal UI. If you use Health Connect Cloud, let me know if this is helpful or if you have questions!

https://www.youtube.com/embed/IN83cGGx-N8?si=WAyFtWFpZxzwnofA
[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]

5 0
0 190

Hey DC Members!

In this video, you will learn about new features in InterSystems HealthShare Provider Directory and what's coming next for curating and sharing provider information as a data asset:

HealthShare Provider Directory & Patient Index: New & Next 2022 @ Global Summit 2022

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

0 0
0 190

Hello,

Thanks for reading:

What hobbies would you recommend to balance being a professional software developer and have other activities to replenish yourself?

For example: what sports or physical excercise would you recommend? Swimming, gym, bycicle, walk?

What social activities: board games, hang out with other people?

What deep activities to bring yourself a "flow state moment"? Playing an instrument, learning to paint, watching series, play videogames, gardening, reading, playing sports...?

0 1
0 189

Hi Developers!

This is the digest of new solutions and applications submitted to InterSystems OpenExchange in January 2020!

New applications in January 2020

OUReports by Irina Yaroshevskaya

Online reporting tool for InterSystems IRIS. Online User Reports - automatically analyzes data - generates automated reports - provides interface for ad hoc reports - conducts statistical research. Learn more on OUReports.com

Samples-Aviation by InterSystems

Provides sample data for use in exploring InterSystems IRIS Text Analytics capabilities.

objectscript-package-example by Evgeny Shvarov

ObjectScript Package example with a simplified folder structure to edit/compile/collaborate with InterSystems IRIS, Docker and Github.

Reducing Readmission Risks with Realtime ML by Amir Samary

Patient Readmissions are said to be the Hello World of Machine Learning in Healthcare. We use this problem to show how IRIS can be used to safely build and operationalize ML models for real time predictions and how this can be integrated into a random application.

REST Business Activity Monitoring by Stephen Pisani

Send IRIS Business Metrics to a REST Endpoint, or host a REST API to retrieve Business Metric values

eXTreme for IRIS / Caché Example by Iryna Mykhailova

A console .NET application which shows how to access, create and store globals from a .NET application using eXTreme.

zpm-dockerhub by Evgeny Shvarov

repository for publishing zpm enabled images for InterSystems IRIS via Github Actions

0 0
0 190

If people are going to use the web interface, they need to be able to quickly find new content or material they are looking for.

Right now it appears as though the only sort is based on the last comment. But if there are threads that a user is not interested in, you have to sift through those again and again lookinf for new threads.

Please make it easier to filter and sort a forum so that information is easier for people to browse.

2 0
0 190

Hi Community!

I'm super excited to be your on-the-ground reporter for the biggest developer event of the year - InterSystems Ready 2025!

As you may know from previous years, our global summits are always exciting, exhilarating, and packed with valuable knowledge, innovative ideas, and exciting news from InterSystems. This year is no different. But let's not get ahead of ourselves and start from the beginning.

Pre-summit day was, as usual, filled with fun and educational experiences. Those who enjoy playing golf (I among them) got up at the crack of dawn to tee off before the sun got too high up. Here's our dream team in action:

@sween, @Mark Bolinsky, @Anzelem Sanyatwe, @Iryna Mykhailova

16 0
0 189
Question
· Oct 9, 2024
SQL Query Help

Hello all,

I need help with coming up with a SQL query that pulls only one value. I have a case where two providers share the exact same name. Each has a different NPI number and IdentityTypeId. I tried the below query - output is also below.

0 18
0 171
Question
· Sep 21, 2024
fileName in an FTP out

Hi All ,

I would like to add session ID to the fileName in an FTP out pass thru business operation.
How can I do that ?

<Setting Target="Host" Name="Filename">SessionID_%f_%Q.txt</Setting>

0 2
0 187