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?

I'm just starting off with ZPM and noticed that examples of library-type packages and full applications abound, but I have not unearthed any that demonstrate packaging an interop production. It doesn't seem like it would be too big of a jump from a full application to an interop production, but that is likely ignorance speaking.

So, does anybody know if this is possible/advisable -- or if I am just way off on the intent of ZPM?

Thanks!

I want to create a Sample Database for Cache InterSystems and want to access it via Cache Entity Framework Provider. But, I cannot find a particular engine of Management Portal to create a database.

Can you guide how to install Management Portal in Windows?

As per the documentation, this is supposed to delete the contents of the lookup table, but it is deleting the table as well.

https://docs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.cls?...

Delete the contents of the lookup table pTable.

Purpose: I need to use a temporary Data lookup table within a DTL for repetition count of a key field.

Hi Everyone,

It's now more than 450 applications on Open Exchange - exciting! That's so important for app's developers to hear your thoughts about their applications. So - if you tried at least 1 app / project on Open Exchange:

⇨ join the Open Exchange Reviews Marathon and enter the raffle for a prize: Logitech C920S Pro HD 1080p Webcam!

Hi Developers!

This is a release of how did we improve the Developer Community in April 2021. The key features:

• Copy-to-clipboard button in code blocks
• Post translation page
• Private reply to post
• InterSystems Official Releases & Alerts page

See the details below.

Episode 18 of Data Points features a discussion with Regilo Souza, Patrick Jamieson, and Evgeny Shvarov about the new InterSystems IRIS® FHIR Accelerator Service. This new product offers a turnkey solution for FHIR application developers, and there is an upcoming developer community programming contest around it!

https://5e18edf067eb59-03854285.castos.com/player/437307
[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]

Needing to know how to define a property that can either be sent in my response as

"members": null,

or

"members": [
{
"dob": "1905-05-01",
"firstName": "BOB",
"middleName": "T",
"nameSuffix": "",
"genderCode": "M",
"lastName": "COLLINS",
"memberId": "123421741",
"relationship": "Subscriber"
}
],

We're working hard to bring you the learning content you need -- help us by taking this 2-min survey to tell us what you're looking for!

Hi, Community!

Please share your experience on code deployment on production site. Do you compile ObjectScript on Production? Is it OK?

Or you only compile on Test site and copy cache.dat to a Production?

Hello Community,

We want to send ALL updates from our Cache server to a remote SQL Server instance that will be used as a reporting data warehouse.

Has anyone done this already and if so what is the best way to go about setting this up?

Thanks

Regards

Mike

Over the last couple of weeks the Solution Architecture team has been working to finish off our 2019 workload: this included open-sourcing the Readmission Demo that was brought to HIMSS last year, so we could make it available to anyone looking for an interactive-way of exploring the tooling provided by IRIS.

Preview releases are now available for the 2021.1 version of InterSystems IRIS, IRIS for Health and HealthShare Health Connect.

As this is a preview release, we are eager to learn from your experiences with this new release ahead of its General Availability release next month. Please share your feedback through the Developer Community so we can build a better product together.