InterSystems Developer Community is a community of 24,414 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more
Question
· May 1
Embedded Python query

Hi Guys,

How can I use this same objectscript principle in embedded python to get the value of each field in my loop?

s sql="SELECT ID, Name, Age FROM Sample.Person WHERE Age="_Myage

Set RS=##class(%ResultSet).%New()

Set Ret=RS.Prepare(sql)

Set Ret=RS.Execute()

While RS.Next()

{

Set name=RS.GetData(2)

}

0 2
0 59
Question
· Mar 27
Generic route

I'm working with routes for a rest service with intersystems iris. I have a working /test path, but I want to create a regex that accepts any path passed after /test. example /test/sdjklsbdk or /test/sdfkjgbskdbf/skjbksdb/ksdjbdks

I used <Route Url="/test/(.*)" Method="POST" Call="test"/> and <Route Url="/test/:path" Method="POST" Call="test"/> and I got the error <PARAMETER> what could it be?

{

"errors":[{

"code": -5002,

"domain": "%ObjectErrors",

0 2
0 59
Article
· Aug 22 26m read
Building a robot with IRIS

In this case, a robot is nothing like Gort from the movie “The Day the Earth Stood Still” or any other humanoid robot from science fiction. Nor is this Robot the one-armed automated welder from a real-world automotive assembly line. This Robot is a program that controls another program. You might want this for automated testing or to capture application logic from an application for which you don’t have the source, and the application’s author lacked the kindness or foresight to provide an API for its capabilities.

5 0
1 60

I have a personal copy of Cache which I use to help me with certain things. The instance resides on my Windows desktop. The apps I use a web enabled. It would be great if I could access my apps via web browser from my laptop without having to keep a copy of Cache on my laptop. It would make it difficult to keep the databases synced. So, if I restart my Cache instance, then I can use get to my apps by entering the url: http://ipadd:57772/csp/user/myapp.cls.

0 3
0 57

Hi Community,

Our Project Managers created a series of videos to highlight some of the interesting features of the new 2025.1 release. Please welcome the first one of them:

⏯ Foreign Tables in InterSystems IRIS 2025.1

https://www.youtube.com/embed/Iu4nj9rzh1k
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

2 0
1 60

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ Security - Granular Access Control to Files with Fapolicyd @ Global Summit 2024

https://www.youtube.com/embed/qMJcALKsNVE
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

2 0
1 60

Dear Fellow Cache Gurus: I would like to know if there is either any built-in Cache Date/Time function or an easy way to include a timezone abbreviation such as EST, PST, MST, etc... within the Cache Date/Time formats.

I read through the Cache Documentation but could not find anything to achieve this.

So if I do the following command: $ZDateTime($H,1,4,,,4,,,,,"InvalidDate"), then I get an output like this: 02/27/2025 11:10AM

But I am looking for the output to be formatted like this: 02/27/2025 11:10AM EST

0 0
0 60

Hello,

We are doing the hl7 integration migration from cloverleaf to InterSystems Healthshare. so I have an application has workflow like below, and I am seeking the suggestion of the workflow in InterSystems HealthConnect cloud version.

The current application has workflow like this.

1. local server has Cron job every night to create about 10 files with specific name and next day's timestamp in file name with a dummy word in it and the files located in local cloverleaf server. pretty much 1 facility per file, file name has facility name and timestamp in it.

0 0
0 60

Hi,

To add or get information about a user for the management portal you can [within the portal]:
System Administration > Security Management > Users

Is it possible to:

1. List a user, user's properties including roles

2. Add a user and set user's properties including roles

3. Set a user's password

for the management portal using a program eg. Objectscript and/or SQL?

If so, how can this be done?

It would be great if you have examples.

0 5
0 54

InterSystems Reports version 25.1 is now available from the InterSystems Software Distribution site in the Components section. The software is labeled InterSystems Reports Designer and InterSystems Reports Server and is available for Mac OSX, Windows and Linux operating systems.

This new release brings along enhancements and fixes from our partner, insightsoftware. InterSystems Reports 25.1 is powered by Logi Report Version 25.1 which includes:

5 0
0 59

I have a stream that I read out until the end. I then append more content to the stream and want to read out only what has been added. How do I only read out the new contents of the stream? Essentially, I want to read a stream, record the end position, then once the stream is updated read the contents from that recorded position until at the new end. This stream needs to be kept intact for historical reference so cannot be cleared between reads.

0 2
0 57

Hi all!

I want to create an %Embedding.Config to use with an %Embedding property. I followed the documentation for %Embedding.OpenAI, and it works fine after setting sslConfig, modelName, and apiKey.

However, I need to use AzureOpenAI. While the embedding process is similar to OpenAI's, Azure requires additional connection parameters, like an endpoint.
My question is: is it possible to configure these extra parameters with %Embedding.Config, and if so, how?

0 2
0 57

Hi, Community!

Are you working with clinical data in a research setting? See how InterSystems OMOP streamlines data integration and analysis.

Using InterSystems OMOP to Transform FHIR Data

https://www.youtube.com/embed/kXpTyKL_-nA?utm_source=youtube&utm_medium=social&utm_campaign=kXpTyKL_-nA
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 59

Hello to all the Cache Experts out there and Happy Friday!

The company I work for uses Cache 2017.1.3 and we have been seeing intermittent errors in the Cache Error Trap when an SQL query runs. The error message looks like the error is occurring within the cached query routine that Cache auto-generates. Unfortunately, when I pulled up the routine in the SMP System Explorer, I only found an obj version, so was unable to look at any code.

0 3
0 55

Hello my friends,

I have a problem with Objectscript, why the value of address become like this ?

everything works fine except the Address,

this is my code, do I need something to make this into real address ? should I put something in my code ?

set paper=obj.PAADMPAPMIDR.PAPMIPAPERDR

if '$isobject(paper) continue

set Address=paper.PAPERStName

thank you for your help

Best Regards,

0 3
0 55