Discussion Oliver Wilms · Jun 29, 2023

I want to deploy IRIS apps running in containers in Kubernetes with user accounts configured.

I have a %ZSTART routine which looks for an XML file with Users export data and if the %ZSTART routine finds this file, it imports it. This Users export data can be obtained by running a class method.

I have defined a task which can be scheduled or run on demand. This tasks imports user data from an XM file.

In Kubernetes I can provide a ConfigMap to stage the Users data for the %ZSTART routine.

I want to define Users data once and get it deployed to many IRIS apps running multiple replicas in a K

2
0 248
Article Oliver Wilms · Mar 19, 2023 5m read

csp-log-tutorial

Prerequisites

Make sure you have git installed.

I created a git folder inside the IRIS mgr directory. I right clicked the git folder and chose Git Bash Here from the context menu.

git clone https://github.com/oliverwilms/csp-log-tutorial.git

Clone my csp-log-tutorial GitHub repo if you like to try it out for yourself.

I will describe in this tutorial how I try to use access.log and CSP.log files in webgateway pods to track requests and responses.

My team works with IRIS containers running on Red Hat OpenShift Container Platform (Kubernetes) in AWS. We deployed three webgatewa

screenshot

1
0 412
InterSystems Official Benjamin De Boe · Jun 30, 2023

InterSystems IRIS Cloud SQL is a fully managed cloud service that brings the power of InterSystems IRIS relational database capabilities used by thousands of enterprise customers to a broad audience of application developers and data professionals. InterSystems IRIS Cloud IntegratedML is an option to this database-as-a-service that offers easy access to powerful Automated Machine Learning capabilities in a SQL-native form, through a set of simple SQL commands that can easily be embedded in application code to augment them with ML models that run close to the data.

Today, we announce the Developer Access Program for these two offerings. Application developers can now self-register for the service, create deployments and start building composable applications and smart data services, with all provisioning, configuration and administration taken care of by the service.

0
0 400
Question Alex Woodhead · Jun 30, 2023

Motive

Am just plain curious about how people may be approaching this area.

The Question

The %SYSTEM.License API wraps an IRIS key that is specific to a range of InterSystems products with

  •  Platform features
  •  Platform behaviors
  •  Expiry date
  •  Capacity / Usage limits

If a company is implementing deployed products that:

  • run on top of IRIS
  • optionally support other vendor IRIS products

For example:

  • a "plug-in" API
  • a knowledge-base

And they have an IPM deployed solution.

To avoid reinventing the wheel, am wondering for commercial vendors, is there a common way to achieve t

2
0 299
Question Smythe Smythee · Jun 23, 2023

Hi Community,

I need to convert date 1997-08-09 10:38:39.700000000 into this format 1997-08-09T10:38:39Z 

I have tried using all date function  $ZDH,$ZDT no luck can anyone help me to convert this into required format.

Thanks,

Smythee

5
0 362
Article Jimmy Xu · Oct 11, 2022 2m read

ZPM is designed to work with applications and modules for InterSystems IRIS Data Platform. It consists of two components, the ZPN Client which is a CLI to manage modules, and The Registry which is a database of modules and meta-information. We can use ZPM to search, install, upgrade, remove and publish modules. With ZPM you can install ObjectScript classes, Frontend applications, Interoperability productions, IRIS BI solutions, IRIS Datasets or any files such as Embedded Python wheels. 

Today this cookbook will go through 3 sections:

  1. Install ZPM
  2. Generate Module
  3. Find, Install, publish mod

10
11 1491
Question Andy Stobirski · Jun 29, 2023

Hi all

I need to do hardware maintenance on a physical HealthConnect server which forms one half of a mirrored pair, and  It will require multiple restarts.

So, I will need to prevent any HealthConnect services from restarting until all maintenance is completed. Is this just a case of disabling the service "HealthConnect Controller for <SERVERNAME>", or is there anything else I need to be aware of?

Andy

2
0 229
Article AndreClaude Gendron · Sep 19, 2017 1m read

It is with great pleasure that the CIUSSS de l'Estrie - CHUS is sharing the mocking framework it developed and presented at the InterSystems Summit 2017.  I will update this post with more detailed instructions in the next few weeks but I wanted to share the code and presentation quickly : 

https://gitlab.com/ciussse-drit-srd-public/Mocking-Framework

I hope you'll find this useful for your unit testing. We are using this extensively for the last 2 years and it really works well! The repo is public, feel free to submit enhancements!

Do not forget to enable the %UnitTest in your SMP. Instruct

14
1 2214
Article Yuri Marx · Jan 21, 2022 4m read

@Robert Cemper is the most active and widely read member of the community (Best Seller!). So nothing better than learning InterSystems technologies from over 100 articles by him. I curated the articles, selecting the best ones by subject:

Articles about SQL

DB Migration using SQLgateway DB migrations to IRIS using SQLgateways.

Dataset Lightweight M:N and M:N Relationship Advanced SQL relationships

Using ClassQueries() as Tables Using ClassQueries as tables (like views using objectscript)

Effective use of Collection Indexing and Querying Collections through SQL Index SQL query collecti

7
14 739
Article Daniel Aguilar · Jun 29, 2023 2m read

Hello Community!

I'm going to try to explain how to create test for Postman collections for use it with my app IRIS Api Tester.

Yet, What is Newman?:

Newman is a command-line tool that allows you to run Postman collections in an automated and scalable way. By creating tests in Newman, you can ensure the reliability and correctness of your API endpoints. In this article, we will explore how to create tests for Newman in Postman, along with practical examples to help you get started.

Once you have created your Postman Collection:

You're ready to start writing your test scripts:

Tes

0
0 455
Article Mihoko Iijima · Jun 29, 2023 3m read

InterSystems FAQ rubric

For volatile tables (tables with many INSERTs and DELETEs), storage for bitmap indexes can become inefficient over time.

For example, suppose that there are thousands of data with the following definition, and the operation of bulk deletion with TRUNCATE TABLE after being retained for a certain period of time is repeatedly performed.

Class MyWork.MonthData Extends (%Persistent, %Populate)
{
/// Level of satisfaction
Property Satisfaction As %String(VALUELIST = ",満足,やや満足,やや不満,不満,");
/// Age
Property Age As %Integer(MAXVAL = 70, MINVAL = 20);
Index AgeIdx On Age 
0
0 379
Question Menno Voerman · Jun 29, 2023

Hi All,

See code below. We don't want to %FromJSON interpret the data. 

We're creating a method to convert json to csv but we don't want to convert/interpret any of the data

The write in the code snipped below will give 220 as weight instead of 220.00.

Does anyone now a way/method to don't interpret the data without put "" on the values?

Class Tmp.test
{

ClassMethod help()
{
		set src = "{""name"" : ""greg"", ""weight"" : 220.00 }"set obj = ##class(%DynamicAbstractObject).%FromJSON(src)
     	write obj.name,!
     	write obj.weight,!
     	return$$$OK
}

}
2
0 275
Article Robert Cemper · Jun 20, 2022 7m read

My major interest is  Working with Globals in Embedded Python.
So I checked the available official documentation.

#1 Introduction to Globals
an attempt of a generic description of what a global is. Pointing to

#2 A Closer Look at ObjectScript
But where is Embedded Python ?
Way down you see

#3 Embedded Python

3.1 Embedded Python Overview
3.1.1 Work with Globals

Great if you have never seen a Global before
Otherwise a shocking primitive example
3.2 Using Embedded Python
Last hope: >>> but there is just NOTHING visible.
This is more than just disappointing! Even IRIS Native API for Python is more det

8
3 1346
Question Evgeny Shvarov · Oct 2, 2022

Hi folks!

How can I refer to a classmethod of the same class while coding another classmethod with Embedded python?

I know that I can call it with iris.cls(classname).MethodName(), but it's more cumbersome even comparing with ObjectScript, where I can call ..MethodName().

Compare ObjectScript:

do..SetupGame()

and the same call in EmbeddedPython:

    iris.cls('eshvarov.sample.SeaBattle.GamePython').SetupGame()

 

Thoughts?

6
0 455
Question Lakshmi Ankireddipalli · Jun 16, 2023

We are trying to come up with huge DataStore which needs to store HIPAA transactions and Data getting partitioned with idkey - YYYYMM.  Current Live data get inserted into current Month DB -  HIPAA_202306. 10 years (Hipaa retention policy) old data is going to be sitting in to 120 DBs ( 201606_HIPAA, 201607... 202305) for historical audit legal compliance purposes.

Currently if we create Namespace we get 2 databases - CODEDB for routes/classes & DATADB for journals data.  

In our requirement, Global mapping should point to 120 DataDbs. How would we Map/design this using Globals. 

Really app

7
0 468
Question Gautam Rishi · Jun 29, 2023

Hi All,
I was creating a unit test directory with the below script. But it not creating any directory as mentioned in code. I am working on MacBook with irisusr User as standard installation process.

if '$data(^UnitTestRoot) {

set mainFolder = "UnitTest\NewDir\"

set st = ##class(%File).CreateDirectoryChain(mainFolder _ testSuite)

if $$$ISOK(st) { set ^UnitTestRoot = mainFolder }

else {

write !, "UnitTestRoot folder could not be created. Consult with instructor."

do $system.Status.DisplayError(st)

}

}

2
0 360
Question Ephraim Malane · Jun 29, 2023

Hi Community,

I would like to know how I can query a list of patients that were revoked on HealthShare for the month of April and May.

Messages are sent using FHIR and a revoke is handled with active:false as seen below. A non-revocation will have active: true on the patient resource.

I wanted to check SQL tables but I am not sure which one to check if so. Please advise on how to go about getting this report.

Regards,

0
0 182
Question Gautam Rishi · Jun 29, 2023

Getting INVALID OREF error while unit testing. Also ResultDyanmicObj.Headers.%Size(),DummyResponse.Headers.%Size() these are working fine getting 7 value from both. but still it is not working.

do $$$AssertEquals(ResultDyanmicObj.Headers.%Size(),DummyResponse.Headers.%Size(), "Validation for Headers")

error - INVALID OREF>TestAccountSearchWithoutAccount+6

1
0 429
Announcement Anastasia Dyubaylo · Jun 22, 2023

Mycroft Core Release Notes: 8/14/2017 - Mycroft

Welcome to the June'23 Developer Community Release!

We're stoked to share with you the latest improvements we've made to the usability of the Developer Community:

📌 Location in bio

📌 New filters in search by Members 

📌 Job Opportunities 

📌 Ideas Portal on the About page

Let's have a closer look at all these updates.

5
0 452
Question Gautam Rishi · Jun 28, 2023

Hi All,

I am trying to execute my SQL query using ExecDirect() method and it returns a ResultSet. No doubt it works fine after this I am trying to fetch each value using a loop code below. But before that, I am also checking for %SQLCODE = 100 which is for an empty resultset I think. However, It is not working as desired. In the case of an empty resultset also I am getting %SQLCODE = 0 until result.%Next() is called. Also, %ROWCOUNT is giving 0 in a case where my query is return 1 result row. I am so confused about this.
while resultset.%Next() {

// code

}

4
0 341
Announcement Olga Zavrazhnova · Aug 14, 2018

Hi Community!

In this post, you will find info about the Levels of the Developer Community & InterSystems Global Masters Advocate Hub.

All Global Masters members (Advocates) can achieve various levels of advocacy which depends on contributions  Developer Community and activity in Global Masters. 

Every new level opens new types of challenges/tasks and new types of rewards. 

To level up, you should earn a number of badges from the next level.  Badges can be earned for completing various challenges at the Global Master.

Now there are  6 Levels:

1. Insider (you start here)
2. Advocate
3. Specialist 
4. Expert
5. Ambassador
6. Legend

➡️  Place the mouse cursor over the badge to see how to earn it.

2
2 1963
Question Robbie Luman · Jun 27, 2023

Has anyone come across a good using Embedded Python to convert a Python List object to an IRIS %List object?

My use case is I want to open an SQL entry with an Objectscript class method, then pass some information from that row into a separate Python class method which will then create a Python List object, then have the Python class method return that list back to the Objectscript class method in such a way that the Python List can be converted to an IRIS %List object for me to then use in the Objectscript code.

3
0 492
Question Evgeny Shvarov · Jun 25, 2023

Hi folks!

I have a need to use symilar to $property function from Python. Here is the code:

obj=iris.cls('some.persistent.class')._New()

for property, value in data.items():

 $property(obj.property)=value ; I invented this

How could I do this? Any trick?

For now I plan to implement a helper function in iris that I will call, but I doubt also how can I transfer oref to IRIS.

Thoughts?

5
0 340
Article Anastasia Dyubaylo · Jun 28, 2023 1m read

Hi Community,

If you wish to share with others your solution/tool and/or your company services which are connected to our products, we will be happy to organize a webinar for you to promote it. We will organize your webinar without any fuss on your side, you just need to tell us what you want to talk about and when you want to do it.

From its side, InterSystems team will:

0
0 230
Announcement Emily Geary · Jun 27, 2023

A set of 14 interactive practice questions are now available for the InterSystems HL7® Interface Specialist Certification exam. These questions have all been developed by our subject matter experts. Feedback for these questions include documentation resources and online learning content.

If you're interested in taking our InterSystems HL7® Interface Specialist exam, we highly recommend these questions.

0
0 391