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

IRIS is known to have a built-in Python bridge and even allows you to write Python server code but what about JavaScript? Let's say I need a JavaScript expression interpreter. What would you recommend as the most effective way to get one? It is highly desirable that the solution does not require administrator privileges and uses in-process communication (I mean not http and not unix-specific interprocess-communication via command line)

0 2
0 220
Question
· Jan 30, 2023
SQL Query Help in $ListGet

Hi All,

I want to run an SQL like below

Select ID,Rollno,Marks,Name,Section,Teacher from Marks left outer join Student on Marks.StudentID=Student.ID

Now, the Student.ID is having the encrypted value which is not matching with Marks.StudentID (as this is clear value).

I can get the clear value using encrypted value as follow

^StoreValue("EncryptStudentID",Student.ID)=$LB("123"). That 123 is the clear Student.ID which I need to match in SQL query (ON clause).

0 2
0 220

Hi developers!

If you missed our presentation at the InterSystems UK&I Summit and our demo during the Source Control roundtable, but you still want to find out more about source control for Interoperability Productions... there’s another chance to see it at our User Group Session next Thursday, November 3rd at 3pm (GMT)

The new driver enables highly granular management of Interoperability Productions with tight integration into the InterSystems IRIS management management portal. 

Sign up via eventbrite here >> https://bit.ly/3yqzfvS

4 0
0 222

Hey Developers,

Join us to review the latest additions to Health Insight and future product plans for analytics in HealthShare:

Health Insight New and Next @ Global Summit 2022

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

Hello guys,

I'm trying to install HealthShare on a virtual machine. The original language of this virtual machine was Russian, unfortunately I don't speak Russian hehehehe.
So I changed the original language to English, but when I installed HealthShare the portal was in English, but the terminal was in Russian and during installation it doesn't show me any option to select the language.

0 2
0 220

Hey Community,

Join the next InterSystems webinar "Implementing Your Data Fabric with InterSystems IRIS" on June 22 at 11:00 AM EDT to learn:

  • How you can access, transform, and harmonize data from multiple sources, on demand, and make it usable and actionable for a wide variety of business applications at the convergence of transactions and analytics.
  • Why leading analysts are predicting that data fabrics are the future of data management, and how a modern data platform can speed and simplify these kinds of initiatives.
  • How the features and benefits in the new release of InterSystems IRIS® data platform and InterSystems IRIS for Health™ 2021.1 can help your organization.

2 0
0 222

Hi:

I have noticed a problem in some new code I did on one of our productions. I think it is leading to 2 problems.

I have a file, lets call it 1111111111_2300.pdf.

We make the file UNIQUE to avoid an issue. This filename in the working directory gets a session ID Added to it before the .pdf. So lets say it was session ID 9 it would be 1111111111_2300#SID9.pdf in a working directory .

There are further operations to be done on this document before it is sent. For various errors an email is sent back to service users.

0 3
0 219

We connect to MS SQL Databases using the Microsoft JDBC Driver 12.2 using the following URL

jdbc:sqlserver://<server>:<port>;database=<database name>;trustServerCertificate=true;integratedSecurity=true;authenticationScheme=NTLM;domain=osumc;authentication=NotSpecified

They want to migrate the databases to the Azure Cloud and in doing so we need the Authentication to change to go through Microsoft Entra. I was given the following URL

0 5
0 216

We need to generate a PDF file from an HL7 message as it passes through an Ensemble production. Looking for examples, tutorials, documentation aligned to our scenario.

We are currently using Ensemble (so can't use InterSystems Reports at the moment). Thinking Zen reports...

We can get from HL7 to XML OK, following Introduction to InterSystems Health Connect - YouTube (see c.1:11:00-1:13:00)

1 2
0 219

Hi Community,

Play the new video on InterSystems Developers YouTube:

High-Speed Ingestion Using InterSystems IRIS Persister with Java @ Global Summit 2023

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

1 1
0 201

Could any one tell me, how the index works in cache db, Consider for example, I have a table called "Employee" and the fields as "EMPID, EMPNAME, EMPAGE" and I am having index for EMPID as IDX_EMPID and trying to get the record using the following query as

SELECT * FROM EMPLOYEE WHERE EMPID="005"

and the table data be like

EMPID EMPNAME EMPAGE

001 ABC 20

002 AAA 21

003 ABB 23

004 BBB 20

005 BDF 24

006 EEE 22

0 2
0 219
Question
· May 2, 2024
help with HL7 Transformation

Hi,

I'm new to IS and the HL7 transformations using the DTL. I need some clarification on the foreach action.

I want to iterate over IN1 segments, and output only segments that contain certain allergy types in IN1-2 with foreach. Inside the foreach block, I check for allergy type "FA" in IN1-2 and, if found, send the segment with only the required fields (fields #1, #2, #3, and #5 to be exact). Please see the foreach block below:

0 3
0 218

there is a setting in VSCode "objectscript.export: {noStorage: ture} " allow export cls from server to client, without storage definition.

However, wheneven I complied and save cls in my vscode client, the storage definition was added back. If I don't want it, I have to deleted the part manually.

Does anyone have something to teach me? thank you

0 6
0 215
Question
· Apr 12, 2024
HowTo VSCode O

Hello all !!! I have a question: i heard it is possible to write Object Script code for Intersystems in VSCode. How it is possible to connect the InterSystems terminal to VSCode terminal ? I heard there should be a special docker. Currently i am trying to run a simple code which will communicate with the user through the terminal but it throws an error. thank you in advance for the answer !

0 3
0 218

Hi,

Looking for some guidance on setting up IRIS to use single sign on to authenticate with ADFS.

We have a request for users to automatically launch IRIS without the need to login, the user will be authenticated by Single Sign on (SSO) against ADFS.

Do we need to have a authorization server as well as a client, ADFS will handle all the authentication side, so would it be a case of configuring IRIS client up to communicate with ADFS, following the link below?

0 0
0 221

Hey Community!

New video is already waiting on InterSystems Developers YouTube:

Introducing the InterSystems IRIS Smart Factory Starter Pack for Manufacturing

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