Hello!

I wonder how to select a conditional value from a Table column that has lists of values?
Example: I have a table in the database that looks like below:

For example, I want to know which Itemname it is for number 10 that is in the IDList. What should this SQL syntax look like? I have tried %INLIST and other things but only get blank value. How should the SQL-syntax for that query look like?

Greatful for all tips.
Regards,
Michael

Occasionally, in VSCode, compile errors stop displaying. I'll be getting errors on compile all along (expected, and it compiles while saving using CTRL+S), until they'll suddenly stop. I haven't found any solution, including restarting VSCode and restarting my user session in Fedora. I'm running IRIS locally on Fedora and running VSCode also on the same machine. The only solution I've found is to restart IRIS. It's a solo dev environment and relatively small, so restarting isn't anything but an annoyance.

Are there any known bugs around this or any other solutions?

Here's what I see in the o

Hi all

how to enable content-type : application/json 

this is our web application environment

with body request

we got result when our hit with postman like this

{

    "resourceType": "OperationOutcome",

    "issue": [

        {

            "severity": "error",

            "code": "invalid",

            "diagnostics": "<HSFHIRErr>InvalidContentType",

            "details": {

                "text": "The Content-Type 'application/json' is not supported."

            }

        }

    ]

}

what we have to do to make this request success, thanks for your help and time

Tha

Last day to enter your idea! https://community.intersystems.com/post/ending-soon-genai-crowdsourcing…

Hi Community,

InterSystems Innovation Acceleration Team invites you to take part in the GenAI Crowdsourcing Mini-Contest.

GenAI is a powerful and complex technology. Today, we invite you to become an innovator and think big about the problems it might help solve in the future.

What do you believe is important to transform with GenAI?

Your concepts could be the next big thing, setting new benchmarks in technology!

Contest Structure

     1. Round 1 - Pain Point / Problem Submission:

With all your knowledge about GenAI and of InterSystems capabilities, what pain point / problem

Hi Developers,

Watch this video to learn about some recent machine learning engagements InterSystems is driving, including TrakCare predictive analytics and examples from our Developer Community and partners:

⏯ Artificial Intelligence Healthcare Solutions - Time to Take Action @ Global Summit 2023

What was your approach in 2023 to learning InterSystems technologies?

Hi,

I'm currently working on a Business Process Language (BPL) project where I'm using ##Class(%SQL.Statement).%ExecDirect to execute a SQL query. The query returns more than one row, and I'm facing an issue in handling the result set.

<property name='tResult' type='%SQL.StatementResult' instantiate='0' />

I'm setting the result of the query to context.tResult, but the loop through the result set processes only a single row. I need assistance in correctly setting up my context property or any other approach to iterate through all the rows returned by the query.

Thank you in advance

Does anyone have an effective tool for anonymizing/deidentifying CCDAs for testing purposes?

Hello Community,

I've extended the a class %JSON.Adaptor in my class definition and it contains the xData block MimeType of application/json. I got the error while compiling. Why this error occurs and how to resolve it

I have written an in network single web page containing a jquery datatable. I want to add the "href" tag to link the Terminal window based on the IP.

Below is a list of failed attempts to make this work.

W " <td><a href=""javascript:pass('"_PASS_"|"_IP_"|"_USER_"|"_PORT_"')"">Terminal</a></td>"

or

W " <td><a href=""javascript:openCMD('test')"">Terminal</a></td>"

or

W " <td><a href=""C:\\Cachesys\bin\cterm.exe /console=cn_iptcp:ip[23"">Terminal</a></td>"

 W " function openCMD(ip) {"
 W " var oShell = new window.ActiveXObject(""WScript.Shell"");"
 W " oShell.Run(""dir *.*"");"
 W " oShel

Hello Community,.

I've updated the IRIS community form 2023.2 to 2023.3 and I didn't see the User defined(Sample) error messages in ^IRIS.Msg global even I verified in both pointer and data level. I re run the set x=##class(%MessageDictionary).Import("error.xml") After import I could see the pointers and data in ^IRIS.Msg

Is the User defined error will reset from the server after IRIS upgrade?

Regards,

Ashok

Hi Community,

In this article, we will learn the below topics listed below:

1. What is Docker?
2. Some of the Docker benefits
3. How does Docker work?
4. Docker Image
5. Docker Container
6. Docker Image repository
7. InterSystems's Docker image repository
8. Docker Installation
9. Docker Basic Commands
10. Running IRIS community edition by using docker
11. Docker Desktop GUI

So Let's start.

1. What is Docker?

Docker is Virtualization software that makes developing and deploying applications very easy. Docker does this by Packaging the application into a so-called container that retains e

In today's digital age, effective data management and accurate information analysis are becoming essential for successful enterprise operations. InterSystems IRIS Data Platform offers two critical tools designed to provide convenient data management: ARCHITECT and ANALYZER.

ARCHITECT: ARCHITECT is a powerful tool created for developing and managing applications on the InterSystems IRIS platform. A vital feature of ARCHITECT is the ability to produce and customize complex data models. It allows users to handle the data structure with flexibility to meet the specific requirements of their appli

Hi folks!

Recently I was in need to setup a local FHIR server using IRIS For Health and I think I found the easiest and simplest way ever.

Just run in terminal these two lines below :

docker run --rm --name my-iris -d --publish 9091:1972 --publish 9092:52773 intersystemsdc/irishealth-community

and

docker exec -it my-iris iris session iris -U "USER" '##class(%ZPM.PackageManager).Shell("install fhir-server")'

And you'll have FHIR server running locally at http://localhost:9092/fhir/r4.

That's it!

The FHIR server will use the latest build of InterSystems IRIS for Health Community Edition and will deploy FHIR server from this app via IPM package in  FHIRSERVER namespace.

This is for Mac, so please add in comments how it works in Windows.

This is a very short article as it is really easy to setup a local FHIR server with InterSystems IRIS for Health and IPM Package Manager.

We have solution which uses IRIS with IAM and webgateway integrated.

After integration, we notice that in the kong configuration in the kongdb upstreams are not created as listed in the kong.yml

We noticed that, IAM api calls are failing with enterprise license expired.

[kong@iam-deployment-75f485954c-ssdfv /]$ curl --location --request POST 'http://localhost:8001/services/'
{"message":"Enterprise license missing or expired"}

From Logs:

`2023/11/22 14:59:04 [notice] 2331#0: *31 [lua] init.lua:393: timer_at(): [timer-ng] fallback to ngx.timer.at [delay = 86400], context: ngx.timer
2023/11

InterSystems FAQ rubric

If you restart the OS after changing the machine name without stopping InterSystems IRIS (hereinafter referred to as IRIS), a problem occurs when IRIS cannot start.

To get started, delete the <installation directory>\mgr\iris.ids file.

iris.ids file stores the started node name and shared memory information (shared memory ID). It is created when IRIS starts and deleted when stopped (iris stop or iris force). If you stop (restart) the OS without stopping IRIS, iris.ids, which contains IRIS startup information, may remain.

IRIS checks iris.ids during the next startup

If Iris does propose to create keys following a sequence, how can we obtain a sequential number in another context?

In my case, I automatically create care centers, and I want to set them a number like:

APP-DD-999

APP = Name of the application used by the center
DD = center department number
999: sequential number in the department
It is of course possible that centers will be created in competition, so this possible competition must be managed.

My first approach was to use a persistent class and create a new object to retrieve its id, but this involves creating as many classes as departments

How to clone dynamic objects more efficiently than using a serialization/desserialization approach (eg. Set objectB = {}.%FromJSON(objectA.%ToJSON()) ) ?

Why %DynamicObject could not extend %RegisteredObject and its %ConstructClone method (if not inherit it)?

I would like to share some of the latest projects I've implemented

I have created a delegated user and I want to use this user to query some tables. When I grant the role of% ALL, I can query tables, but I cannot grant% ALL. I want this user to only have the permission to query tables. What should I do

Embedded Python is about to get a whole lot more powerful, and we’re looking for a few volunteers to give it a try.

What’s the Flexible Python Runtime?

The Flexible Python Runtime option allows you to use a Python runtime of your choosing with Embedded Python. Previous to this, you could only use the operating system's default Python, which was limiting especially for customers using the latest and greatest AI & ML tools close to their data.

When InterSystems introduced Embedded Python in InterSystems IRIS in 2021.2, it was designed to work with just the version of Python that is pre-inst

Hello Community,

Is there any way to avoid generating the built in validation inside the classmethod from the .disp class definition. I've added the resource with path parameter as integer in swagger 2.0 open API.  The class method(in my case getRandom is the class method) inside .disp handles the integer validation by default. Is there a way to avoid/remove by default.

default validations for Integer

If ($number(pmin,"I",-2147483648,2147483647)="") Do##class(%REST.Impl).%ReportRESTError(..#HTTP400BADREQUEST,$$$ERROR($$$RESTInvalid,"min",pmin)) QuitIf ($number(pmax,"I",-214748364

Hi Guys,

How to get free disk space, I found that I could use GetDirectorySpace but not sure how to use it in getting free space in my D drive?

Thank 

This question originally appeared in the comments of the post: The Art of Mapping Globals to Classes (5 of 3)
 

Hey

I need to know how to exclude row after checking his data, for example:

^global(1,2)=a*b

^global(1,3)=a*c

if $P(^global(key1,key2),"*",2)=c Q

how can i do this?

thanks

This article will cover turning over control of provisioning the InterSystems Kubernetes Operator, and starting your journey managing your own "Cloud" of InterSystems Solutions through Git Ops practices. This deployment pattern is also the fulfillment path for the PID^TOO||| FHIR Breathing Identity Resolution Engine.

Git Ops

I encourage you to do your own research or ask your favorite LLM about Git Ops, but I can paraphrase it here for you as we understand it. Git Ops is an alternative deployment paradigm, where the Kubernetes Cluster itself is "pulling" updates from manifests that reside i

Hello everyone!
Sorry for the vague title! But I wonder what would be the best way to easily import a large XML-file into a production, modifying it by deleting elements and nodes depending on what values are in those nodes/elements and later creating whole new XML-file from that?

I have gone through this: Using Caché XML Tools | Caché & Ensemble 2018.1.4 – 2018.1.8 (intersystems.com)

But I get the sense that there are a lot of ways of approaching this, but I do not know what is the most effective for my certain needs.

I appreciate the help! Thanks beforehand! :)
 

Outside of the learning module for IAM, I would like to give it a try with Community Edition on my own however the Community Edition License does not include it.

Has there been any discussion on allowing Company's Demo IAM through Community Edition before they get the license?

Thanks

Scott

Hello everyone!
I have to build a REST service that receives a POST HTTP-request, collect a file from that request in the Form data and then send it in another HTTP Post request through Form Data. However I can't really seem to send the file, and I do not know where it has gone wrong. All I am getting told is that no file is being received from my HTTP Post request. I am reaching the REST Service I am supposed to send the request to, but nothing is being sent.
I would be really thankful if someone could give some insight why nothing is being sent in my request. Thanks beforehand! :)

So, this is