All time
Announcement
· Mar 15, 2021
FHIR Analytics

Hi developers,

We have received quite a lot of interest in using SQL on FHIR data. As you know, FHIR data is encoded in the form of a complex directed graph, and thus you can not easily query it with traditional SQL queries or business intelligence tools. Some customers have noticed that the "FHIR search tables" in IRIS for Health have flattened part of the FHIR graph, and have tried to use them for analytics. This is an undocumented and unsupported part of IRIS for Health, and can change without notice.

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

Job description

Do you want to make a difference? Being part of a team where all team members are valued for their contribution?

SOFTSPLICE values their employees as their most valuable asset. We value a healthy work and life balance.

We need capable and devoted developers to expand our team. We have interesting diverse projects to work on.

Are YOU the next team member of our dynamic team?

5 1
0 440
Hey Community,
Please check out the 2022 Annual Dev Community Article Digest with the most popular and commented articles.
Thank you all for your contributions to the InterSystems Community in 2022!
General Stats
✓ 1676 posts published in 2022:
– 277 articles
– 481 announcements
– 870 questions
– 48 discussions
✓ 2,338 members joined the Developer Community in 2022
✓ 10,640 posts published all time
✓ 12,061 members joined all time
7 3
1 400

Welcome to the September'22 Community Release!

We're super excited to share with you all the latest improvements we've done over the last couple of months!

📌 new header of the site

📌 InterSystems Certification page and highlights for certificated specialists

📌 search bar in Posts, Replies, and Direct Messages

📌 new "About Us" pages: our Team and Dev Ecosystem overview

📌 highlights for DC Moderators and Team

📌 new Up button

Let's have a closer look at all these improvements.

4 6
0 340

I have developed a process that pulls data elements from a cache instance using the tools provided with the "intersys.pythonbind3" import. This is a windows box. After validating the process, the next step is to install the process on a site (Windows) that does not have an installed version of cache and access the cache instance remotely. But, since intersys.pythonbind3 is part of the cache install, I am not sure what to do to allow this process to function because of the missing import.

0 1
0 459
Article
· Jan 28, 2022 2m read
Embedded SQL Bug and Workaround

We recently encountered an Embedded SQL issue while upgrading to IRIS 2021.1, and thought the issue and workaround might be interesting to share.

Key takeaway: Host variables in an ORDER BY clause of an embedded SQL query that is inside of a method don't work as expected. IRIS versions starting with 2020.1 are affected. As a workaround, add the host variable to the Method's PublicList list and "new" them so the embedded query has access to them.

6 1
0 440

Hi Community,

New video is already on InterSystems Developers YouTube:

⏯ Embedded Python with Interoperability

https://www.youtube.com/embed/b6Fbg0JDmPA
[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 460
Article
· Jul 20, 2020 2m read
SPOOL as SQL Table

It is a classic Global Mapping exercise presenting ^SPOOL as Class / Table

Background

Device #2 named SPOOL dates back to the predecessors of Caché and IRIS
It was the first "%Stream" like option to buffer output before printing.
It is also the first and till today the most simple way of output redirection.

Solution

This is also an example of a mapped Global.
USE 2 redirects the output into the Global ^SPOOL

Open Exchange app
11 0
0 460

I have the following query which tells me how many documents were retrieved for each customer, but it only works for the "on-demand" customers:

SELECT PatientFacility, LEFT(LocalDateTime,7) as Mnth, Count(*)
FROM HS_IHE_ATNA_Repository.Aggregation
WHERE EventType IN ('RecordRequest','RecordRequestBreakGlass')
AND LocalDateTime >= '2016-01-01'
AND LocalDateTime < '2017-01-01'
GROUP BY PatientFacility, LEFT(LocalDateTime,7)
0 4
0 456

Hi, i am trying to transform a mensage HL7 ORUR01. The segmnet OBX.5 is dynamic and i'm calling to subtranform item but fail.

this is the error:
ERROR <Ens>ErrException: <METHOD DOES NOT EXIST>zTransform+16 ^es.gra.informes.transformaciones.OBXToInforme.1 *GetSegmentAt,EnsLib.HL7.Segment -- - registrado como '-'
número - @'
Set zSrcOBJz=source.GetSegmentAt("5",.tSC1)'

0 1
0 458

Hi,

While starting newly created production I am getting below error:

17:14:05.498:Ens.Director: ERROR <Ens>ErrProductionSuspendedMismatch: Production 'Training.NewProduction' was suspended, a new production of a different name can not be started.

Please note that I can start and stop 'Training.NewProduction' successfully but still the status of the Training.NewProduction' is suspended.

Thanks

0 4
0 455
Question
· Jun 21, 2020
ObjectScript via vscode

Good day all

I am a new developer in cache, I am trying to connect vscode to healthshare but i get the following error:

////Error: Error: Parse Error: Expected HTTP/////

Please help me on this.

My setting like this:

{

"objectscript.conn": {

"active": true,

"label": "LOCAL",

"host": "****",

"port": 57772,

"username": "***",

"password": "***",

"ns": "***",

"https": false,

},

0 4
0 455

Hi Everyone!

Please watch the new video on InterSystems Developers YouTube, recorded by @Sourabh Sethi in the "Coding Talks" format:

Informative and Fast WEB API VIA ObjectScript and Ensemble/HealthShare

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

I've seen a few password change posts, but I wasn't 100% sure it was the same process, so I am asking here. We periodically have to change the passwords for a few Cache user accounts across several servers. Is there a process/script to change these passwords without having to go into the web portal on each server? Thanks so much, and I apologize if this was covered in some of the other articles that I've run across. Just looking for the best method.

0 3
0 456
Question
· Dec 10, 2017
Cache and Database

Hi, I'm a student, weak programming. I ask for your help, I write a program in C #, there are two tables, but I do not understand how to organize the connection between them many to many. Table in DataGridView1 from DataSet1 on Form1 key connection in DataGridView1 from DataSet1 to Form3

I do this on Form1

0 1
0 458