Hello,

I'm looking for a way to write a stored procedure or something to return a ResultSet with Embedded Python.

My goal is the following:

I have a Goal table with a Text field that is free text.

CREATETableId

I would like to create a procedure that returns all the entities (in the iKnow sense) in a new Entity column.

Python code, i would like to use :

'This is a test of the Python interface to the iKnow engine. another sentence to test this program with.'

Expected result :

How do I go about it ?

Hey Community,

We're very pleased to present to you our brand new About Us pages! Please welcome:

📍 Our Team

📍 InterSystems Developer Ecosystem Overview

So...

Let's meet the Team! These are the people that make the magic happen ✨

Welcome to the next chapter of my CI/CD series, where we discuss possible approaches toward software development with InterSystems technologies and GitLab.

Today, let's talk about interoperability.

Issue

When you have an active interoperability production, you have two separate process flows: a working production that processes messages and a CI/CD process flow that updates code, production configuration and system default settings.

Clearly, CI/CD process affects interoperability. But questions are:

• What exactly happens during an update?
• What do we need to do to minimize or eliminate production downtime during an update?

Trying to identify which records in the %SYS.Audit table are fails.

Eg, as user "WORKER", I run an attempted a grant, the terminal returns:

SQL> GRANT SELECT ON newschema.patients TO COORDINATOR
[S1000][Iris ODBC][State : S1000][Native Code 112]
[libirisodbc35.so]
[SQLCODE: <-112>:<Access violation>]
[Location: <ServerLoop>]
[%msg: <User WORKER does not have required privileges to grant the privilege(s)>]
[ISQL]ERROR: Could not SQLExecute
 

but the record in the audit table gives

Description: "SQL GRANT Statement"

EventData: "GRANT SELECT ON newschema.

Hey Community,

Join us to have a look back at recent developments in care planning and coordination and a look forward at what is on the horizon:

⏯ Unified Care Record: New & Next 2022 @ Global Summit 2022

Hi Community,

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

Winners' demo included!

Date & Time: Thursday, September 22, 09:00 AM EDT 

>> Register here <<

As the title says, when I use the "Go To Definition (F12)" option, it opens the definition in read only mode. Is there some way to either directly make the go to option editable or can i turn the read only version into an editable version? I end up needing to open the file directly and then manually going to the method definition myself.

For quite some time InterSystems IRIS supports such thing as Merging CPF. So, with help of this it should be possible to define only desired changes in configuration. And get them applied even with vanilla Docker image. 

And I though it could be useful when used with Dockerfile. Use this way to configure IRIS during docker build instead of using Installer manifest.

Hi Guys,

I'm able make a request through the browser with no issues as below: 

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.

1. Language configurated in the virtual machine.

2. Terminal with russian text.

I tried to convert the system to English, and this worked for the terminal.

Hello,

i receiving several mails via "EmailInboundAdapter” and sending via "EmailOutboundAdapter"

Now Microsoft will force OAuth 2.0 for Outlook365-Mails and want to drop POP3 basic authentication permanetly at Oct/1 2022. All have to use OAuth 2.0 then.

IRIS documentation is very tiny for OAuth 2.0: https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cl…

A new paramter for a token is defined for "%Net.POP3.Connect()". But the token got only on authenication calls using ClientID and ClientSecret (last one valid for maximum 24 months).

While the documentation of configuring authentication with Kerberos for IRIS on Linux servers is sparse, for docker i found no docs at all. Assuming I would be able to adapt the requirements from linux to docker (on linux host) I had no success at all. Has anyone successfully done this?

Even with "do ^REDEBUG" set to FFFFFFFF the log did not help much, I always get "Kerberos error getting initial credentials with password; KDC reply did not match expectations". Since I moved the iris.

If I'm using an objectgenerator, is there a way to check the compile flags and have it behave differently based on which flags are set?

And as a tangent, is there a list somewhere of what compile flags there are?

Hey Community,

Summer (or winter ) is over and it's time to reflect on what's been going on here, in the Developer Community... To make it easier to follow the main novelties and news we've decided to create seasonal catching-up posts!

What does it mean? Read on!

With iris session <instance>:

Is it possible to tell the program to read commands & other inputs from a file and when it reaches end of file

return control back to the physical terminal? 

Hi Community,

We are super excited to announce the winners of the InterSystems Interoperability Contest: Building Sustainable Solutions! 

Thank you all for participating in our coding competition! Without further ado, the winners are...

Experts Nomination 

🥇 1st place and $5,000 go to the Sustainable Machine Learning app by @Lucas Enard

🥈 2nd place and $3,000 go to the iris-energy-isodata app by @Muhammad Waseem

🥉 3rd placeand $1,500 go to the iris-megazord app by @José Pereira

🏅 4th place and $750 go to the n8n-nodes-iris

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Analytics with InterSystems New and Next 2022 @ Global Summit 2022

Following Importing FHIR Packages into the InterSystems IRIS for Health Server I'm able to create an FHIR extension of type string as well as a search parameter.

However, I need to create an extension as well as a search parameter of type Reference. And this is not working.

Did anyone successfully add an extension and search parameter of type Reference?

Hi,

My routine contains embedded SQL including this:

&sql(DECLARE C1 CURSOR FOR

The error "SQLCODE=-52 : Cursor C10 already declared" comes up on compilation in Studio. Does anyone know a way around it please?

Bob

Hi Community,
In this article, I will introduce Python Flask Web Framework. Together we will create a minimal web application to connect to IRIS and get data from it.
Below you can find the steps we will need to follow:

• Step 1 : Introduction to Python Flask Web Framework
• Step 2 : Installation of Flask module
• Step 3 : Creation of web application using Flask
• Step 4 : Use of HTML Templates 
• Step 5 : Installation of IRIS Python Native module
• Step 6 : Establishment of a connection with IRIS 
• Step 7 : Transferring data from IRIS to Flask and displaying it

So Let's start with step 1

Step1-Introduction to Python Flask Web Framework 

Flask is a small and lightweight Python web framework that provides useful tools and features that make creating web applications in Python easier. It gives developers flexibility and is a more accessible framework for new developers since it allows to build a web application quickly using only a single Python file. Flask is also extensible and doesn’t requires a particular directory structure or complicated boilerplate code before getting started.

For more details please view Flask Documentations

SQL obtains the user's operation permission on the database

In this article I'll show you how you can easily convert between many different document formats, these to be precise:

• in: html, odt, doc, docx, rtf, sdw, txt...
• out: html, odt, docx, rtf, pdf, txt, tex, xhtml...

and many more, check out this table. We'll use LibreOffice as a conversion engine.

Hi team,

I have a PDF file which has come report data and images (like XRAY) in it. How I can read text from a PDF file in  cache

Hi Community! InterSystems will be a technical sponsor at CalHacks hackathon by UC Berkeley, October 14-16 2022. 
We can't reveal our challenge at the moment, but as a little spoiler -  it is related to healthcare ;)
The team from our side @Evgeny Shvarov @Dean Andrews @Regilo Regilio Guedes de Souza @Akshat Vora and more!
Join InterSystems in this fun and inspirational event - apply to be a mentor, volunteer, or judge here 

Hi Community! 
Are you in Dubai on October 10-13? Join us at the Global DevSlam conference for developers with 15,000 participants expected in person!
📍Let's meet here: Hall 9, Stand № H9-E30
🌟 We will host the event: "The hands-on workshop on InterSystems IRIS Data Platform"
Speaker: @Guillaume Rongier, Sales Engineer at InterSystems
October 10, 2pm - 3:30pm 
Register here 
❕We have free promo passes for our Community Members, partners, and customers. Please drop me a line if you are willing to attend!

Put the InterSystems FHIR Server to work at the HL7 FHIR Connectathon in Baltimore last weekend, posting bundles, getting all RESTy with resources, and interrogating the Vulcan Implementation Guide We straddled the Real World Data (RWD) and Schedule of Activity (SoA) projects for Vulcan IG folks moving the ball forward connecting clinical research and healthcare data.

When we are at the starting stage of BI project development, we must remember that it is crucial to select the right tool for its implementation. Today we want to show you how one of the principal functionality of dashboards is implemented in different BI systems. Let's talk about drill down from both points of view: the dashboard development, and the convenience and clarity for the end user. We will touch on the applications of this technology in IRIS BI, Power BI and Tableau.

In IRIS BI, cubes initially provide hierarchies according to which drilldown will later occur.

This is a self contained class that can be run from the Intersystems Task Scheduler which records peak usage details for databases and licenses built up throughout the day and retaining 30 days history.

To schedule the task to run every hour:  

d ##class(Metrics.Task).Schedule()

You can also specify your own start time, stop time, and run interval:

d ##class(Metrics.Task).Schedule(startTime, stopTime, intervalMins)

Metrics are stored in ^Metrics in the namespace that the class resides in/is run from.

Hello community,

Yesterday was celebrated the "World Medical Ethics Day" https://www.ama.com.au/media/wma-medical-ethics-day

We could celebrate it with a programming quiz or challenge:

DESCRIPTION:

Deoxyribonucleic acid (DNA) is a chemical found in the nucleus of cells and carries the "instructions" for the development and functioning of living organisms.

If you want to know more: http://en.wikipedia.org/wiki/DNA

In DNA strings, symbols "A" and "T" are complements of each other, as "C" and "G".

Hi ,

How to Convert Excel message into a SDA3 format in Ensemble?