Hi Community,

There was an entry missing on ODS global HS.XF.Config and there was a change not related to this deployed sometime around February by another team.

How can I check who removed this entry and when on HealthShare?

During my recent work on Tutorial - Working with %Query #1
I met a Class Property that is quite different from its same-named relatives.
It is there since 'ever' but is rarely used, Related doc doesn't help so much. 

Hello, I am using the power bi report builder tool to create a report with dynamic parameters. Every time I try to create and apply a parameter in power bi query editor. I get the below listed error message. 

FYI: I have created a Data source connection using "InterSystems ODBC" Version 2015.01.00.429. I am getting data without any issue. 

Query: select Payment_History.OCCURENCE_DATE from Payment_History  where Payment_History.OCCURENCE_DATE >= @BeginDate

Error Message: ERROR [42000] [Cache ODBC][State : 37000][Native Code 12]
[C:\Program Files\WindowsApps\Microsoft.PowerBIReportBuilder_15.7.1801.

Messages will contain fields with expressions like "REASON->Blood(1.23)" or "REASON->Bone(4.56)" or "REASON->Muscle Mass(7.89)". The word after the "->" can vary. I would like the outputs to be; "REASON(1.23)" or "REASON(4.56)" or "REASON(7.89)", basically removing "->" and the word or words that follow but leaving the parens and the numeric characters within.

Thanks,

Jonathan Harris

I am working on setting up our Failover techniques as we move to a Mirror Environment with a Arbiter, 2 Failover Nodes, and a Async (DR) Node. There are some system commands that I would like to call when the Mirror moves, and I am working on a ZMIRROR routine for that, but I also wanted to create an additional step if we wanted to manually shutdown and for the Mirror to move. So I was looking at using ZSTOP to call a couple of different items while shutting down, while the documentation has an example a couple of questions come to mind about using ZSTOP.

• If we use ZSTOP do I need to account

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ InterSystems Deployment Options @ Global Summit 2022

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