All time

I need to show the absence of data, so I have to join the list of predefined values with a result of a select statement.
However, it seems like Table Value Constructors in JOIN are either not supported, or I do not understand the syntax.
Basically, I am going for something like this:

Select v.valueId, m.name 
 From (values (1), (2), (3), (4), (5)) v(valueId)
     left Join otherTable m
        on m.id = v.valueId

Is it supported in Cache SQL or not?

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

Let's say I have a persistent class Sales.
I need to create a report that shows the amount of sales for each branch.
By simply using the class Sales for the source of the cube, I can show what I want with one little exception - the branches that did not have any sales are not shown.
Is there a way around that that does not involve creating a whole new table just for this cube or using a Data connector (they have horrible documentation and I am unable to figure out how to use them properly)?

0 3
0 210

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 207
Hello and welcome to the English Developer Community Annual 2024 Recap.
General Stats:
✓ 3,294 posts published in 2024:
– 1344 articles
– 909 announcements
– 1000 questions
– 41 discussions
✓ 4,616 members joined the Developer Community in 2024
✓ 22,319 posts published in total
✓ 14,662 members joined in total
6 1
0 192
Article
· Dec 26, 2024 1m read
Global Masters Holiday Cards

🎄✨ Holiday Greetings from the Community! ✨🎄

On Global Masters, you’ve sent us wonderful greetings for the community, and we can’t wait to share them with everyone! We’ve transformed your greetings into beautiful holiday cards—check them out below 💌. Thank you all for your warm words!

We also held a small contest on Global Masters for the most original holiday greeting, and @Harshitha.Balakrishna's card was chosen as the best one! Here it is: 👇
📌 Below, you can see all the greetings shared by Global Masters members. They remind us of how important it is to be part of such a united and creative community.

8 0
0 212

Hi,

I am trying to connect to another server using %Net.HttpRequest.

I keep getting this error : SSL23_GET_SERVER_HELLO:unsupported protocol.

My guess is that the site I am reaching for uses TLS1.3 which is not supported in 2016, But I cant right now ask my client to upgrade.

Is it possible to override this ? install some kind of a patch or a more recent version of openssl on the server ?

Thanks

Amiram

0 2
0 210

Has anyone had success with passing in a collections property within a SOAP request to a Soap Service in Ensemble? Please reply with how you set up that collections property. I am able to successfully send a SOAP request correctly containing the elements of the collection property to Cache, as seen in a custom soap log file which I am using to troubleshoot. But the collection property in the Ensemble request is not getting serialized, meaning MyContainers has nothing.

My.Request consists of a property, MyContainers, which can have 0 or more Containers (My.Container)

0 1
0 211

Hi, everyone,

We in InterSystems Learning Services are compiling and reviewing different non-InterSystems materials for learning various technologies. To this end, can I ask:

-What are your favorite learning resources (books, courses, etc) that have helped you with the development and implementation of the FHIR standard and why do you like them?

Thanks, Jamie Kantor

Certification Manager, InterSystems

2 2
1 210

Get the latest from Learning Services!

  • Navigation pages in InterSystems documentation
  • New podcast episodes: InterSystems Certification and InterSystems Reports
  • New online learning: Connecting Devices video, HL7 Business Services and Business Operations course, Use FHIR APIs to View Resources exercise
  • Upcoming webinars

Read more and subscribe to get Learning Services news once a month in your inbox!

0 0
0 212

Hi Community,

As you know we have a Global Masters program — InterSystems Data Platform Advocacy Hub.

All Global Masters members (Advocates) can achieve various levels of advocacy which depends on contributions on Developer Community and activity in Global Masters. Every new level opens new types of challenges (tasks) and new types of rewards.

Recently we introduced a new level of advocacy with the name "Ambassador". Ambassadors and VIPs will have unique privileges and opportunities.

1 0
0 212
Question
· Dec 12, 2019
ComplexMap Riddle

Im usually pretty good at ComplexMaps and implemented a couple, but I have one that is stumping me on how I can implement it. My problem is I have no real "leading data" to key off of and need something else...

It goes a little bit like this:

D123456 THING1 THING2 THING3 THING4

D789101 THING1 THING2 THING3 THING4

0 1
0 211

Hi, Community!

This post is a digest of the Developer Community postings in June 2018.

Most viewed

Atelier 1.2 Stable Release 230

InterSystems IRIS Data Platform 2018.1.1 Release 199

"IF THEN - $SELECT - $CASE" - What is the best way? 179

$CASE For Long Stories 148

Translate a number to text 147

Sort ordering 141

Extending method keywords 138

Stop Storing Atelier Credentials 133

COMANDO $ZF 130

Multi Language Sort 125

Most voted

Atelier 1.2 Stable Release 7

Translate a number to text 7

InterSystems IRIS Data Platform 2018.1.1 Release 6

Multi Language Sort 5

InterSystems on DeveloperWeek NYC, June 18-20 5

Atelier at EclipseCon France 2018 4

Installation Manifest - I can disabled the journal globals by the XML? 3

Creating SSL-Enabled Mirror on InterSystems IRIS Using Public Key Infrastructure (PKI) 3

One simple Docker trick to halve your image build time 2

DC June 2018 Release 2

Most commented

Communication link failure trying to access Studio 15

$CASE For Long Stories 14

How to convert page number to roman numeral in ZEN Report? 14

Extending method keywords 13

How to navigate to parent of Serial Object? 12

Kill process started by JOB 11

Custom file pass through Operation writing out unreadable pdf files 11

Has anyone tried REST API Put Or Post on AWS S3 ? 10

%ProcessError+6 ^%Net.Remote.Proxy.1 error occurs inconsistently 10

How to Update Caché User Full Name field via SQL? 9

Top 10 Authors to Follow by Views

Francisco López, Posts, 147

Eduard Lebedyuk, Posts, 73

Daniel Kutac, Posts, 45

Pete Greskoff, Posts, 34

Top 10 Experts to Follow

Nicole Aaron, Answers, +11

Robert Cemper, Answers, +10

Eduard Lebedyuk, Answers, +9

Vitaliy Serdtsev, Answers, +7

Benjamin Spead, Answers, +4

Francisco López, Answers, +4

Evgeny Shvarov, Answers, +3

Dmitry Maslennikov, Answers, +3

Gilberto Junior, Answers, +3

Timothy Leavitt, Answers, +2

0 0
0 212


Hi Community,

In this article, I will introduce my application iris-fhir-bridge

IRIS-FHIR-Bridge is a robust interoperability engine built on InterSystems IRIS for Health, designed to transform healthcare data across multiple formats into FHIR and vice versa. It leverages the InterSystems FHIR Object Model (HS.FHIRModel.R4.*) to enable smooth data standardization and exchange across modern and legacy healthcare systems.

Open Exchange app
4 2
1 171

Question for folks who have connected to an External FHIR repository outside of IRIS. Within the HS.FHIRServer.Interop.HTTPOperation there is not an option to include TLS or an OAuth authentication when connecting to an external Repository. So then how is that piece done if you need to Authenticate against an OAuth Server before you are able to access the data or call the Web Services/REST calls?

0 1
0 210
Question
· Dec 27, 2023
Code Quality Checks: Javascript

Is it possible to get a code quality stamp of approval on the Open Exchange with an application written in Javascript?

My Iris Whiz application is a browser extension written in Javascript and I wonder if having the code quality stamp missing from my application page will put people off from using it.

0 2
0 209

The VS Code extension for Deltanji source control has been updated to version 1.2.3. View the change log here for a full list of updates: https://bit.ly/3PqMJ26

Users can now benefit from the VS Code Quick Diff feature when using the ObjectScript extension. To use this feature just click on the gutter decorations to reveal an inline diff experience, where you can contribute contextual commands. You just need to provide VS Code with the original contes of any given file.

2 0
0 211

An interim idea to bring more dark to the docs with different font.

Process:

  • In Firefox web browser address bar navigate to: "about:support"
  • Look for label "Profile Folder", and click on the corresponding "Open Folder" button.
  • Drill-down / Open sub-folder called Chrome.
  • Create file here called: userContent.css

Content of file:

2 0
0 211