Hello CCR Users,

The new CCR view page is now available to all users via an opt-in toggle a at the top and bottom of the view page.

We hope all users will give the new UI a try and provide us with any feedback that you have through your normal support channels.

Thank you to the beta users who have been using this page for a while, making sure its full release goes smoothly! You can always update your beta user status here.

Thanks!

Matt

Foreword

InterSystems IRIS versions 2022.2 and newer feature a redesigned functionality for JSON web tokens (JWTs). Once housed under the %OAuth2 class package, the JWT class, along with other JSON web classes (JWCs), now live under %Net.JSON. This migration occured in order to modularize the JWCs. Before, they were closely intertwined with the implementation for the OAuth 2.0 framework. Now, they can be maintained and used separately from OAuth2.

Note: For backwards compatibility, the classes still exist under %OAuth2 package, but the codebase now uses %Net.JSON.

The goal of this article is to

Hello everyone, i want to have an InterSystems Caché Installation cache-2017.2.2.865.0-win_x64.exe

Thanks

Hello Community,

As you may know, the next release FHIR R5 is currently published in "beta". Right now, it is undergoing a quality review. And we'd like to invite YOU to participate in this process! 

Your task, if you wish to accept it 😉, is to check text descriptions, copy editing, and grammar. To facilitate this quality review, ClinFHIR is being used, which is a web tool used for developer education on FHIR and to help developers to visualize FHIR data and to plan out the building of FHIR applications. For instructions on how to do the quality review of FHIR R5 read this short document. The application you will use to do the quality review is here.

This is how ClinFHIR  looks in action for this FHIR R5 Quality Review:

InterSystems IRIS 2022.2 has Native SDK for Python (https://docs.intersystems.com/iris20222/csp/docbook/Doc.View.cls?KEY=PA…).

We know how to traverse a global data structure using IRIS Object Script $Order function.

SET key=""FOR  {
     SET key=$ORDER(^myglobal(key)) 
     QUIT:key=""WRITE !,^myglobal(key)
   }

How to do the same from Python using IRIS Native SDK for Python? Here is a code example:

import iris

args = {'hostname':'127.0.0.1', 'port':51772,
    'namespace':'USER', 'username':'_SYSTEM', 'password':'SYS'
    }

conn = iris.connect(**args)

#

We're stoked to share with you yet another set of improvements to our Community!

This time, we'd like to show off our posting updates:

• new programming languages available in the editor
• guide for creating a post

Read on to find out more!

I need a copy of cache 2017.1x  as this is the last version supported by the VA on their network.
Any support here would be greatly appreciated. I have been a member of the M community since 1984.
Thanks in advance

I'm curious about how embedded Python is handled by %CSP classes, particularly in the case of defining REST endpoints on IRIS.
Here is a simple dispatch class for the endpoint /api/pythonapp on my local IRIS instance (2022.3):

Class Python.App.Dispatch Extends%CSP.REST
{

XData UrlMap [ XMLNamespace = "https://www.intersystems.com/urlmap" ]
{
<Routes>
    <Route Url="/test" Method="GET" Call="Hello" />
</Routes>
}

ClassMethod Hello() As%Status [ Language = python ]
{
    import iris

    print('Hello World!')
    return True
}

}

Making a GET request to

Hi community! I would like to show you how to install and configure one of the HealthShare products, the Enterprise Master Patient Index or EMPI.

The EMPI provides to any organization a master patient index to identify each patient of the organization univocally. You can find more information about the EMPI in the following URL: https://www.intersystems.com/interoperability-platform/patient-index/

We are going to start with a HealthShare instance installed in our server, this HealthShare should contains the EMPI functionality available.

I need a stored procedure where I can execute multiple delete from statements. 

This will work to create a stored procedure, but when I add in other delete from, get error invalid sql statements when try to create

CREATE PROCEDURE DeleteSpecimenTwo
  (IN Specno VARCHAR(50))
BEGIN
DELETE FROM PCONT WHERE PSPECNO = :Specno;
END;

This doesn't work

CREATE PROCEDURE DeleteSpecimenTwo
  (IN Specno VARCHAR(50))
BEGIN
DELETE FROM PCONT WHERE PSPECNO = :Specno;

DELETE FROM PSPEC WHERE PSPECNO = :Specno;
END;

Any suggestions

Thanks

Louie

Any ideas on why my %session.Data array would be wiped out after setting %response.Redirect in OnPreHTTP()?

Context: trying to implement a SSO patter for authorization code flow. I mention this because it's all I can really pinpoint as to what's changing. Typically a user logs in by providing their username/password and we validate in our database and set the %session.Data property with the user info.

Hello,

I'm starting testing embedded python and external libraries.

When I try to use the win32api-library I get the following error :

<THROW> *%Exception.PythonException  230 ^^0^ <class 'ModuleNotFoundError'>: No module named 'win32api' -

This is my code :

ClassMethod CreateDocument(path As %String) [ Language = python ]
{
import win32api

...
}
 

The librarie is visible in C:\InterSystems\IRIS\mgr\python\win32.

Am I doing something wrong ?

Regards,

Kurt Hofman,

ASCI nv.

Hi,

I have an issue I could use a little help with. The other day, there was a connection problem with a client, and when trying to update information, we received 75 email notifications that there was a connection problem. I have looked in documentation, and the items on managed alerts might be a solution.However, I know some places have a system where then limit the number of messages of a particular error sent via the Ens.alert process/operation.I'm trying to determine what text should be considered for a message to be "identical".

I need connect to cache2016 database by python to get some data, but   I don' t know how to connect by python, did anyone know how to create connection？

If you can provide any python code, that will be better! 

Hi Friends ,

We have requirement to load data into chache tables from external database (ref data). This process will take 1 min to complete all data load.

Currently I have created Business Service  to trigger Business Operation with out bound db adapter to load data into cache tables.

process will be trigger when i restarted business service.

But requirement  is  , this business service should be triggered from outside ensemble environment i.e , this should expose as REST endpoint and share with the external team.

How to expose Business service as REST endpoint? I need help for this regard.

Thank

I'm wondering how I would go about adding headers to a csv file which has already been created. I am unfamiliar with ObjectScript. 

For example if I were to use R, I would simply write..

test <- read.csv("file/path/example/Extract.csv", header=FALSE)
colnames(test) <- c("A","B","C","D","E")

I do not have embedded Python installed either as I would know how to do it in that also.

How could I mirror this in ObjectScript please?

My current create file method:

We're electrified to invite all our clients, partners, developers, and community members to our in-person InterSystems Global Summit 2023!

Our Global Summit user conference is your opportunity to connect with trailblazing product developers, fellow users pushing our technology into new frontiers, and the people whose out-of-box thinking is rocking our universities and board rooms. All in the same space. And registration is now open!

➡️ InterSystems Global Summit 2023

🗓 Dates: June 4-7, 2023

📍 Location: The Diplomat Beach Resort, Hollywood, Florida, USA

Greetings, Community!

We are grateful for your participation in InterSystems Open Exchange. Your feedback is essential to us.

Please take a moment to complete this brief survey and let us know what you like about Open Exchange and how we can make it better in 2023.

➡️ Open Exchange Survey 2022 (3 minutes, 10 questions)

Hi,
is there a way to know where IRIS or CACHE current instance is installed from objectscript?

Something like "iris list"

It will be easy to make a $ZF, iris qlist, and get the info, but i hope that there's something less complex than that.

Thanks

Pietro

Hi,

I have a IRIS mirror set

. all running on SUSE Linux

. each on a separate server

consisting of

Primary

Backup

Arbiter

My arbiter is the ISCagent.

Question

=======

Is there a Linux command showing me the status of the ISCagent as arbiter?

The systemctl service command below shows if the service is running but not if it is acting correctly as an arbiter.

I'm looking for a command like iris list which you can run on the Primary or Backup

===

systemctl list-units --type=service|grep -i isc
ISCAgent.service                                                                          loaded active running

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in February 2023:

Hi Friends,

I have created one utility method to check given id exist some reference table or not. If exist the method return1 otherwise 0.

But some times the backed table data will be reload with another process (REST request) , on any point of time. This reload process max it will take 30 seconds.

My Requirement is , the utility method should wait , if table reload is in progress.

Could you give me any suggestion for this issue.

Thanks,

Prashanth

This tutorial is a follow on to Working with %Query    
It was displaying the content of the input stream chopped in fixed-size chunks.
But often those streams are structured and have well-defined separators (e.g HL7)
So as a side subject of this tutorial, this chapter shows how to break a stream into PIECES.

It is exactly the same idea as the $PIECE() function for strings with some add-ons.

My previous article introduced you to SQL based Basic Class Query
where a clever wizard created all the required code for you and your essential
contribution was an SQL statement. 

Now we enter the real Custom Class Query that provides more freedom but
requires a deeper understanding of the mechanic behind the scene.
The full code example is again on GitHub

My previous article introduced you to the COS based Custom Class Query.
There were some features missing like more lines of the stream displayed
and numbered.

Hey Developers! 

Here is a digest of new solutions and applications submitted to the InterSystems Open Exchange in February 2023.

Hi Community,

Watch this video to explore common security pitfalls within the industry and how to avoid them when building applications on InterSystems IRIS:

⏯ The OWASP Top 10 & InterSystems IRIS Application Development @ Global Summit 2022

Hi Developers, 

Thank you for spending another great year with us on Global Masters. We hope you enjoy the program!

This is the moment you can share your thoughts about Global Masters. What do you like about it? What you'd like to change?

Time to make your wishes for 2023, because this program is FOR you💫

We will build a roadmap for 2023 based on your answers, and we will continue working hard to make it the best developer gamification program!

➡️ Global Masters Survey 2022 (5 min, 10 questions)

Hi Community,

We're pleased to invite you to the upcoming webinar in Spanish called "Validating FHIR profiles with InterSystems IRIS for Health".

Date & time: February 2, 3:00 PM CET

Speaker: @Ariel Arias, Sales Engineer, InterSystems Chile

If one of your packages on OEX receives a review you get notified by OEX only own YOUR package.   
The rating reflects the experience of the reviewer with the status found at the time of review.   
It is kind of a snapshot and might have changed meanwhile.   
Reviews by other members of the community are marked by * in the last column.

I also placed a bunch of Pull Requests on Github when I found a problem I could fix.    
Some were accepted and merged, and some were just ignored.     
So if you did a major change and expect a changed review just let me know.