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

Hi Developers,

This April, you've posted 65 new questions on the Developer Community:

Questions

6 Underlying Benefits of Asking Questions | SUCCESS

3 0
0 141

InterSystems encourages the adoption of a flexible, practical approach to application development, rather than strict adherence to one of the prevalent development theories. This paper offers advice based upon our experience. However needs, attitudes, and styles vary; we recommend that each programmer choose the development approach that works best for them. Caché supports a wide range of development methodologies, not just those recommended here.

1 0
0 141
Question
· Apr 6, 2025
Query variable column names

Hi,

How can I query fields by passing them in variable names, eg. I would like to query columns Book & Author fields from eg. the following :

S =var1="Book", var2="Author"

Select var1,var2 from myTables.Books

I tried @var1 or %var1 and didn't work

Thanks

0 3
0 137

Hence the question: is there a way to do that?

The goal is to get data (from half a thousand to 3-4 thousands lines) from DB, calculate standart deviation then use it as logical condition in analyzer.

For example IF std > custom_value = show_the_result ELSE null

There is a STDDEV(MDX) method used in Analyzer but it is a measure and it can not be used as logical condition (correct me if i am wrong)

0 2
0 138

Hello,
Please, we would need your help 🙂:

In a development environment, we have added quite a few presentation contexts to the DICOM configurations (the associations). We would need to find a way to export them from this environment to make it easier for us to import them in PRO (and avoid doing it by hand one by one).

0 2
0 138
Question
· Sep 22, 2024
Property of list of lists

Hello, i need to make property that is of type List of Lists of String (see "body_text" in JSON)

How can i make it?

Thanks

{
  "type": "BODY",
  "text": "<TEXT>",
  
  # Required if <TEXT> string contains variables
  "example": {
    "body_text": [
      [
        <BODY_TEXT>
      ]
    ]
  }
}
0 1
0 139

Hello Community,

I have encountered the following SQL problem trying to create a table from a SELECT statement.

I narrowed the problem down to the following example:

1. The SELECT statement alone works as expected. 

SELECT m.Name, h.Status 
FROM EnsLib_HL7.Message m, Ens.MessageHeader h 
WHERE h.MessageBodyClassName='EnsLib.HL7.Message' AND h.MessageBodyID = m.ID

2. But if "CREATE TABLE ... AS" is added it fails

0 4
0 136

I have an angular UI communicating with a iris rest api. Now I need to authenticate (to federated) before accessing the UI, and for a better solution as the users are using the healthshare clinical viewer 2023, find a way to use the clinical viewer authentication / user to go to the UI.

The angular way would be to do an angular guard and have a function 'am I authenticate to federated', but I never found a function like this and how to get my username.

0 0
0 140

Hi All! We have a new online course that those of you who do integration work / create data transformations may be interested in: Editing Data Transformations via Code. This course is meant to build familiarity with the code behind data transformations in InterSystems products, enabling you to identify their class structures, logical elements, and more.

2 0
0 140

Hi Developers,

Watch this video to learn about new features of IntegratedML, such as support for larger datasets and new syntax for time series forecasting:

⏯ IntegratedML: New & Next @ Global Summit 2023

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

3 0
0 140

Hello,

I have a .NET based web application and would like to front end it with an Iris4Health server, ie possible using the CSP or web application url's to reoute to the requests into the docker container. Kinda of like a reverse proxy but using Iris for health. Is the external language server a good use for this or is that only for direct interaction with I4H?

I know you can create a custom container with the app copied into it, but not sure if that is the best way.

Any suggestions on how I could accomplish this would be appreciated.

0 0
0 140

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in December 2022:

New Videos
№ Video Views
1 Winners of the InterSystems IRIS for Health Contest: FHIR for Women's Health 7788
2 ObjectScript Data Types 390
3 Using Variables in InterSystems ObjectScript 217
4 Using System Functions in InterSystems ObjectScript 182
5 InterSystems IRIS Cloud SQL 103
6 Online Meetup with InterSystems IRIS for Health Contest Winners 77
7 Updates in Security 73
8 Introduction to Analytics with InterSystems IRIS 73
9 The Final Demo Day of InterSystems FHIR Startup Incubator — Caelestinus 71
10 InterSystems IRIS Cloud IntegratedML 61
11 Patient Experience and the EHR 29
12 InterSystems Cloud Services Overview 25

1 0
0 140

Hi Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in February 2020:

New Videos
№ Video Views Watch Time (hours)
1

Supporting All Tools for Development in InterSystems IRIS

 72 0,7
2

Code in Any Language with InterSystems IRIS

 72 0,6
3

InterSystems IRIS Kubernetes Operator

 64 3,3
4

What Keeps Developers Up at Night

 59 0,6
5

SQL Performance: Need for Speed

 43 4,3
6

Office Hours Webinar: InterSystems IRIS 2020.1 Preview

 40 3,4
7

Healthcare Data Management Solution - What Kinds of Data?

 40 0,4
8

InterSystems IRIS on HCI

 39 5,2

0 0
0 140

In the previous article, we saw how to build a customer service AI agent with smolagents and InterSystems IRIS, combining SQL, RAG with vector search, and interoperability.

In that case, we used cloud models (OpenAI) for the LLM and embeddings.

This time, we’ll take it one step further: running the same agent, but with local models thanks to Ollama.

Open Exchange app
5 0
5 139
Question
· Apr 16, 2025
FTP Inbound Errors

I need to connect to a SFTP server and I seem to connect and timeout have tested the connection using File-zilla and the connection was successful but the problem is when I try to connect using the FTP in bound adapter service I get the following errors.

ERROR <Ens>ErrOutConnectExpired: FTP Connect timeout period (120) expired for ***************.com:990/******/SSL='********* + ERROR <Ens>ErrFTPConnectFailed: FTP: Failed to connect to server ***************.com:990/******/SSL='********* (msg='Timeout waiting for response',code=529)

0 1
0 138

Hey Community!

We're happy to share the next video in the "Code to Care" series on our InterSystems Developers YouTube:

⏯ How Project BEST Transforms FDA Adverse Event Reporting with FHIR

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