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

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 132

Hey Community,

We greatly appreciate all your feedback on the InterSystems Interoperability Contest! Please take a short survey and answer a few questions to help us improve our contests.

👉 Quick survey: Interoperability Contest Survey 2022

11 Best Questions to Ask in a Restaurant Survey (and how to ask them)

Feel free to share your feedback in the comments of this post as well!

0 0
0 136

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 136

There are a select few in the group that have been using Github as a Local Client push to a Repository setup in GitHub. Questions were brought up today about the security, and possible issues when it comes to data being pushed in this method.

Looking over code we have noticed that there is Histogram data within some of the class files that could be considered a security issue. Does anyone else have concerns with the Histogram data being within the class files pushed up to github?

0 2
0 133

img

This will be a short article about Python dunder methods, also known as magic methods.

What are Dunder Methods?

Dunder methods are special methods in Python that start and end with double underscores (__). They allow you to define the behavior of your objects for built-in operations, such as addition, subtraction, string representation, and more.

Some common dunder methods include:

Open Exchange app
5 0
2 135

I am making a FHIR request against Epic, in when I get the Response back using "fromDao" I am extracting the stream into HS.FHIRModel.R4.Patient. However, the patient's name comes back as name within a list that references HS.FHIRModel.R4.SeqOfHumanName.

  • How do I extract the name from HS.FHIRModel.R4.SeqOfHumanName?
  • Do I have to then do another "fromDao" to pull the list into string format?
  • How do I navigate around the lists that are in a FHIRModel response, to extract the string values?
1 9
0 126

When accessing management portal through IIS the page is not fully rendered and the buttons/links that are displayed don't work.

Management Portal works fine through private web-server.

Have just set up IIS/CSP Gateway to access Ensemble, and accessing the CSP Gateway configuration pages through IIS works fine (screenshot at end of post).

This is the view when accessing management portal through IIS (port 80) - missing images, links don't work, not all content displayed:

0 2
0 133

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 135

Hi,

I will try to explain my problem. I have a Main ZenPage on one server that has 2 buttons: each button will launch a different ZenPage on a separate server in an iFrame. All 3 servers have the same user.

Currently, the user logs in to the Main ZenPage, but when they click either button to launch the other ZenPage on the separate server they get the login screen again to login to that server.

Is there anyway I can pass the credentials from the Main ZenPage to the child ZenPages, so that the user doesn't have to login again? Thanks.

0 3
0 132

Hey Community,

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

New Videos
№ Video Views
1 Hands Off HealthShare Deployment Workflow with GitLab Runners 97
2 Tell the World About Your REST APIs: The Benefits of a Centralized Developer Portal 86
3 Best Practices for InterSystems API Manager 81
4 Getting Up to Speed on InterSystems API Manager 73
5 Kafka! Integrating the World's Favorite Stream Processor with InterSystems IRIS 66
6 Using Containers in Highly Secure Environments with IRIS Lockdown 55
7 Stay in Sync with Change Data Capture 55
8 Deploying & Upgrading IRIS with Kubernetes Operator 54
9 iKnow: Open Source NLP in InterSystems IRIS 50
10 How to list a solution on InterSystems Partner Directory 42
11 Showcasing New X12 Enhancements 34
12 HackMIT'21: Building the Next Wave of Healthcare Applications with FHIR, ML, and more 27
13 HackMIT'21: Meet InterSystems and Get Ready for the Challenge 25
14 HackMIT'21: Jumpstarting Development with InterSystems IRIS FHIR Accelerator Service 24
15 HackMIT'21: HL7 FHIR – From smart and dumb devices to consumer applications and population health 16
16 Beez-Woman-Menstrual-Tracker Demo 13
17 Fhirgure App Demo 11

1 0
0 135
Open Exchange app
3 2
0 94

Hey Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ SMART on FHIR: OAuthServer

https://www.youtube.com/embed/rkOAGBY1yUw
[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 1
0 114

If you're migrating from Oracle to InterSystems IRIS—like many of my customers—you may run into Oracle-specific SQL patterns that need translation.

Take this example:

SELECT (TO_DATE('2023-05-12','YYYY-MM-DD') - LEVEL + 1) AS gap_date
FROM dual
CONNECT BY LEVEL <= (TO_DATE('2023-05-12','YYYY-MM-DD') - TO_DATE('2023-05-02','YYYY-MM-DD') + 1);

In Oracle:

2 1
0 114

We're excited to announce the first-ever UI update for CCR Client Tools. The Client Tools UI has been upgraded to match the modern CCR UI, aiming to create a more seamless experience across both applications. The color scheme, fonts, and style elements have all been updated accordingly in the new UI:

3 1
0 114