Hi,

The question is about queries on the System->SQL page. I have a class with a few columns on a global and the test output looks as expected, below. This works as expected as well returning a single row: select * from Utils.RoutineAuditReport where counter=4. However, other columns give an odd error like " Field 'AG' not found in the applicable tables^ SELECT * FROM Utils . RoutineAuditReport WHERE UserR = "AG". As you can see below, both the UserR column and the AG entry in it do exist. What could be the problem?

Thanks in advance,
Anna

Hi Community!

This is the update on what are the new applications submitted on OpenExchange in January and February 2019

CPIPE

This is a tiny example of how to run a server command from within Caché / Ensemble / IRIS and get back the full output as seen in any server command shell.

QEWD-js

QEWD.js is a Node.js framework for REST APIs, interactive WebSocket and/or Ajax applications, capable of running as a monolithic application or split across MicroServices. Fully supports Cache, Ensemble and IRIS, allowing use of existing Cache ObjectScript code, Cache Objects and Cache SQL, but also allows the database to be abstracted as a persistent JSON / Document database.

PMML-Business-Operation

With this simple Business Operation, you can easily leverage your predictive models (saved as PMML) in a Production. There's both a generic BO and a utility method that allows you to generate dedicated operation / request / response classes.

COSFaker

Helps to generate fake/test data for development purposes

WsockClient.csp and WsocClient.js

Web socket clients on CSP and InterSystems node.js adapter to collect end manage data transferred to the client in InterSystems IRIS or Caché

CachéQuality for VSCode by @Daniel Tamajon

IDE extension that helps you detect and fix quality issues as you write code. Like a spell checker, this extension squiggles flaws so they can be fixed before committing code. You can get it directly from the VS Code Marketplace and it will then detect new bugs and quality issues as you code (ObjectScript and JavaScript)

Welcome to the Q1’2025 quarterly platforms update.

Hey Developers,

Watch this video to learn how UC Davis Health uses InterSystems API Manager to satisfy business-partner demand for access to both custom and FHIR APIs:

⏯ How UC Davis Health Uses InterSystems API Manager @ Global Summit 2023

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

Hey guys,

I do love Global Masters (and all the rewards that I get from it) and one of my favourite activities is answering quiz questions. And just now I've had a really cute question What is the result of: WRITE "99" + "cents"? which brought a smile to my face (because I do love to add questions like this to the tests for my students). This made me think that I would really like to somehow show my appreciation to the author of this question.

Hi Team,

Is there any way to take a clone object of executed query result of %SQL.Statement

Hello,

As of today, all CCR users default to the new view UI on new logins. We don't expect any issues, but please report anything that you encounter.

All users will continue to have access to the classic UI for some time via a button at the top and bottom of the view page (see below).

Hi community,

Glad to announce that registration is now open for Global Summit 2023. Remember: the earlier you register, the more you save.

Hi Community,

Let's meet together at the online meetup with the winners of the InterSystems Developer Tools Contest – a great opportunity to have a discussion with the InterSystems Experts team as well as our contestants.

Winners' demo included!

Date & Time: Thursday, February 16, 5 PM GMT | 12 PM EST

Hello,

We are very interested about studying DICOM in deep, both the standar itself and how it is related to HealthShare.

Could you please point us to some good references: documentation, courses, books, pdfs, explanations; to understand what is this standard about and how works.

Thanks for your replies

We have read:

https://dicom.nema.org/medical/dicom/current/output/html/part01.html

Is there a ZEN control that allows rich text entry that can be used to print PDF reports

Merry XMas and Happy New Year!

Hope to hear from you next year!

Here are the technology bonuses for the InterSystems "Bringing Ideas to Reality" Contest 2024 that will give you extra points in the voting:

• IRIS Vector Search usage -3
• Embedded Python usage -3
• InterSystems Interoperability - 3
• InterSystems IRIS BI - 3
• VSCode Plugin - 3
• FHIR Tools - 3
• Docker container usage -2
• ZPM Package Deployment - 2
• Online Demo -2
• Find a bug in Embedded Python - 2
• Code Quality pass - 1
• Article on Developer Community - 2
• The second article on Developer Community - 1
• Video on YouTube - 3
• YouTube Short - 1
• First Time Contribution - 3

See the details below.