Trying to create a new SQL Storage map on existing cache Global in the following format - ^MYGLO("R",rec)=data where the 'data' is built using $zel. e.g. $zel(data,1)="p1", $zel(data,2)="p2" etc... and the ^MYGLO("R",123)=data.

I'm having 2 issues. First, using the SQL Storage map wizard, I cannot figure out how to convey data in $zel format in the "Delimiter" field.

Hi everyone,

I'm working with JavaScript in InterSystems IRIS, specifically in CSP pages. One issue I'm running into during development is that the browser keeps loading the cached version of my JavaScript files, even after I’ve made changes or recompiled the code.

I would have to clear my cache files or browser history for it to reload and work.

Hello everyone,

I'm trying to get back into shape with IRIS. My current goal is to practice with ObjectScript and VS Code. I installed both on my Mac, and everything worked like a charm—perhaps that's why I'm still a big fan of Unix.

New to Python. Attempting to use pypyodbc to select data from a table in one Cache database, and inserting into a similarly configured table in another. Process works fine except for tables containing Date types. NULL values in date columns are handled without issue, but when data is present, insert fails with:

An error occurred: argument 7: TypeError: 'NoneType' object cannot be interpreted as an integer.

Source table:

Hi:

I have been adapting the IRIS WHIZ addon as part of the contest. I will soon fork the code on github so the changes are available.

The next phase is I am storing the date from and to time for a more complete search cache

zenPage.getComponent(36).value

it works in the chrome console ok

I'm not sure in external JS how to set the page it is on as a zenpage to use the zenpage functions

The SYS.Mirror CatchupDB() method requires a System File Number/Inode value as a parameter. I have not yet found a suitable internal method to get this value. Is anyone aware of a utility method that would do this? I do know I can get this value with a small amount of Python or by calling out to the OS. However I wanted to stick with pure Objectscript in this project if possible.

Failing in this I will use embedded python to run the line or two of Python needed to get this value.

Thank you for any hints

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in October 2023:

IRIS on mac unable to run my rest api which I created using spec first approach.
I am getting a 403 forbidden account error.

Managing InterSystems Servers October 24-28,

Hey Developers,

We love Global Masters program for dynamic, fun and networking. We love that we can get to know you better and provide you with some valuable things.

We are excited to have more members in Global Masters, and we'd like to ask your help on that:

❔ Do you know other developers who work with InterSystems technology and would love Global Masters?

▶ Here's the dedicated GM Referral page where you can leave your colleague or co-worker contact details, or get your unique referral link - to send it yourself 😊

Hi developers!

We had a set of technology bonuses for the InterSystems Multi-Model contest.

And here is how projects collected it:

Hey Developers,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in June 2020:

We have classes in a Production environment that are causing us some issues - example attached.

When we export them from the production environment the XML contains a snippet like the following:

<UDLText name="T">
<Content><![CDATA[
//Property any As list Of %XML.String(XMLNAME = "any", XMLPROJECTION = "ANY") [ SqlFieldName = _any ];

]]></Content>
</UDLText>

When imported and compiled into an Ensemble instance this class works as expected.