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 [ Type = bitmap ];
}

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?

ClassClassMethodset

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 detailed.

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?

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.

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)

}

}

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,

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

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.

Hi All,
I want to write testcase in objectscript but stuck at this point where I am getting a DynamicObject from the class method and how can I assert this and check it is okay. 
Also if in any case error It will throw error custom exception class that I created. How to handle assertion for exception in this case also.

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

}

I have latest VS Code 1.50.1 and latest ObjectScript extension.

For some unknown reasons, my IRIS icon disappeared from VS Code activity bar.

How can I get my IRIS icon back?

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.
 

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.

Hi folks!

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

obj=iris.cls('some.persistent.class'for

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?

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:

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.

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Why Horizontal Scalability Is Like Teamwork @ Global Summit 2022

I am creating a class code below

Class Sample.Header

{

Property Key As %String;

Property Show As %Boolean;

}

when I am trying to create an object of this class

using set obj = ##class(Sample.Header).%New()

getting error <METHOD DOES NOT EXIST> %New, Sample.Header

I need to convert "dd/MMM/yy" to "YYYYmmdd".

Input = dd/MMM/yy

Output = YYYYmmdd

example

Input = 13/Jun/23

Output = 20230613

I used below , I get 1923 as year but I need 2023.

$ZDATE($ZDATEH("13/Jun/23",8),8) = 19230613

I have a pResponse output in my onrequest method, in here I build an ACK and set the pResponse variable to it,  and return a status object afterwards.

The pResponse doesn't show up in the trace or message viewer, yet if I move the interface to another more established namespace it works fine, what settings or config could be preventing the ACKS going back?

Hi all,
I have install git-source-control to the namespace TEST. Also it is working fine as I am able to add files to my local git repo and see the changes in it.
But while I try to open GUI for the same i am getting service unable error on this URL 

http://127.0.0.1:52773/isc/studio/usertemplates/gitsourcecontrol/gitpro…

what's wrong with this.

Hi community members!

I'm trying to deploy a container based on IRIS Community for Health ML image available from this url but when I start the container the memory consumption skyrockets to 99% making impossible to work with the instance (it never goes below the 95% of the memory). When I do the same with the IRIS Community for Health image it never goes over 80% of memory.

Is this a known problem? Should I try another version? Maybe have I just to sit down in a corner and cry like a baby?

IoT (Internet of Things) is a network of interconnected things, including vehicles, machines, buildings, domestic devices or any other thing with embedded TCP/IP remote connection available, allowing it to receive and send execution instructions and data. Each thing provides one or more services to the IoT network. For instance, smart light bulbs provide services of turning off and turning on the lights; smart air conditioners maintain the environment temperature; smart cameras send notifications when capturing movement.

Hi everyone.

Has anyone here had any luck with receiving a DICOM C-FIND-RQ and returning a worklist using data gathered from a non-DICOM source (for example, an external SQL query) and would be able to share how they achieved this?

I started to look at the demo however I'm tripping over the logic for building the response.

Hi,

Looking for some guidance on setting up IRIS to use single sign on to authenticate with ADFS. 

We have a request for users to automatically launch IRIS without the need to login, the user will be authenticated by Single Sign on (SSO) against ADFS.

Do we need to have a authorization server as well as a client, ADFS will handle all the authentication side,  so would it be a case of configuring IRIS client up to communicate with ADFS, following the link below?

OAuth Configuration

Appreciate any help or advise given.

Thanks in advance. 

Hello, 

Our team is working on building dashboard for internal reference and monitoring. 

We would like to have details like Interface Name, Current Status, Last Messages Processed at, IP & Port, Serve/Instance/Production Environment name etc. 

If there is any built-in service which we can utilize or any pre-compiled code that we can utilize to build such dashboard. 

At this moment want to keep it basic, but moving forward will enhance with more advance features. 

Please suggest, any help will be appreciated. 

Thanks,

Yash 

As you all know, the world of artificial intelligence is already here, and everyone wants to use it to their benefit.

There are many platforms that offer artificial intelligence services for free, by subscription or private ones. However, the one that stands out because of the amount of "noise" it made in the world of computing is Open AI, mainy thanks to its most renowned services: ChatGPT and DALL-E.

What is Open AI?

Hi Community!

Have you ever had to connect IRIS to an SAP system?

I had to face the challenge of connecting InterSystems IRIS with SAP, and once again I was able to verify the grant work made by Intersystems related to adding the possibility of executing native Python code inside IRIS.

This feature made the integration very easy thanks to the library pyrfc.

With this library, I was able to make calls to a SAP RFC (Remote Function Call) from an IRIS class and receive data from the SAP’s database. 

Yet, What is a RFC?

RFC is a communication protocol used by SAP.

Hello all,
I am creating a REST API with a spec-first approach. However, I am using the try-catch method to handle any exception if any occurs. But whenever any error related to syntax or something occurs, we get internal server error 

{

"errors": [

{

"code": 6220,

"domain": "%ObjectErrors",

"error": "ERROR #6220: Internal Server Error",

"id": "InternalError"

}

],

"summary": "ERROR #6220: Internal Server Error"

}

This is I think IRIS defined, I want to customize my own Internal server error.