Suppose you have an application that allows users to write posts and comment on them. (Wait... that sounds familiar...)

For a given user, you want to be able to list all of the published posts with which that user has interacted - that is, either authored or commented on. How do you make this as fast as possible?

Here's what our %Persistent class definitions might look like as a starting point (storage definitions are important, but omitted for brevity):

Class DC.Demo.Post Extends%Persistent
{

Property Title As%String(MAXLEN = 255) [ Required ];Property Body As%String(MAXLEN = "") 

I have an application that is called by terminal in local cache environment. The application basically has two processes that runs and does the below call to retrieve files and sub-directories in separate folders.    When the main process starts, it jobs off and calls the second process that gathers all files in a directory by using a window dir and file command that pipes the results to a file.  The main process continues on and does the same thing but from a different folder.  When checking out what was retrieved by the secondprocess, there were directories and files missing.   When I run this as just one process it works properly.    I am running this on a 2017 license cache instance.   I have also tried this on IRIS instance and got the same results.  Could you please advise me what is causing the window directory to not work properly when running the processes at the same time?

I am leveraging the cloud storage adaptor to upload objects to an S3 bucket.  I now need to add Tags to the object, but I don't see any mechanism within IRIS to allow adding of Tags.

Is that functionality currently available?

Hi Community,

Play the new video on InterSystems Developers YouTube:

⏯ Introducing Managed Solution for Asset Management @ Global Summit 2023

Welcome to the Q3’2024 quarterly platforms update.  We have some news on the AIX front to encourage better security, along with our usual round of OS version updates. 

If you’re new to these updates, welcome!  This update aims to share recent changes as well as our best current knowledge on upcoming changes, but predicting the future is tricky business and this shouldn’t be considered a committed roadmap. 

Wondering if gherkin (or even cucumber) can be used with IRIS software for testing?

iris | [ERROR] Command "iris start IRIS quietly" exited with status 256
iris |
iris |
iris |
iris | *** Recovery started at Thu Aug 15 05:47:48 2024
iris | Current default directory: /usr/irissys/mgr
iris | Log file directory: /usr/irissys/mgr/
iris | WIJ file spec: /usr/irissys/mgr/IRIS.WIJ
iris | Recovering local (/usr/irissys/mgr/IRIS.WIJ) image journal file...
iris | Starting WIJ recovery for '/usr/irissys/mgr/IRIS.WIJ'.
iris | 0 blocks pending in this WIJ.
iris | Exiting with status 3 (Success)
iris | 08/15/24-05:47:48:778 (828) 3 [Utility.Event] Error while moving data directories ERROR #5001: Canno

InterSystems FAQ rubric

Temporary globals stored in the IRISTEMP/CACHETEMP databases are used when a process does not need to store data indefinitely, but requires the powerful performance of globals. The IRISTEMP/CACHETEMP databases are not journaled, so using temporary globals does not create journal files.

The system uses the IRISTEMP/CACHETEMP databases for temporary storage and are available to users for the same.

For more information about temporary globals and the IRISTEMP database, see the following document:
Temporary Globals and the IRISTEMP Database

The globals used as temporary

Hi, Community!

Are you building generative AI applications? See how a retrieval-augmented generation (RAG) architecture can help:

Exploring the Benefits of RAG

Alert: Database Corruption with Multi-Volume Databases after Truncation

InterSystems has corrected a defect that can cause database corruption or <DISKHARD> errors with multi-volume databases under extremely rare circumstances. Only databases that have been truncated are at risk.

The defect exists in the following products and any InterSystems offerings based on them:

• InterSystems IRIS® – 2024.1, 2024.1.1, and 2024.2
• InterSystems IRIS® for Health – 2024.1, 2024.1.1, and 2024.2
• HealthShare® Health Connect – 2024.1, 2024.1.1, and 2024.2

No HealthShare Solutions products are affected by

Hi fellows,

How can I query all Patient SDA from a Regestry and export to file? Exist some table when I can query all Patient?

To export, I found the class HS.SDA3.QuickXML and method ToQuickXMLStream, but I can't find a table where query all Patient, by update date for example.

Thanks in advanced!

Hi Guys

I'm getting  syntax error using && operator in using JS in my Zen page, the || works fine!?

Thanks

The first developer preview of InterSystems IRIS 2024.3 and InterSystems IRIS for Health 2024.3 has been posted to the WRC developer preview site.  Containers can be found on our container registry and are tagged latest-preview.

This is a very early build in the release cycle and there aren’t any “highlight” worthy features that are complete.  They’ll start to arrive in future preview releases.

Initial documentation can be found at these links below.

• InterSystems IRIS
• InterSystems IRIS for Health

Availability and Package Information

This release comes with classic installation pac

If anyone has experience debugging Embedded Python or has insight into why an ObjectScript method when called from a Python method would not work but would work when called directly via ObjectScript or in a Python shell, your help would be appreciated! 

We have an ObjectScript ClassMethod called GetTemplateString() which takes in a templateName of String type and uses the template name to get the template object, access the Code, and read the code into a templateString. The string version of the Code is returned.

ClassMethod GetTemplateString(templateName As%String) As%String
{
    set t

Any who has encounter the same error can please share your experience?

Trying to launch management portal and encountered "Server availability error". Port 57772 is open, IIS admin service and world wide web publishing service are running. checked firewall and no issues. 

Andrea

Hi

I've more than 100 classes that are packed like  CRD.Health.MyClass so I've defined the global mapping as CRD*, but now I would like to map some of the classes (CRD.Health.SomeClass) to different database so how can I exclude it from my current mapping to be in the new one because if I map it in the new database it will still conflict with the old mapping?

Thanks     

Today we have an unusual code golf: build a program (using only printable ASCII characters, tabs and newlines) that prints out exactly the characters in the printable ASCII space (characters 32 to 126) that don't appear in your program's source code (in any order, however many times you want).

As usual, the goal is to produce the shortest code to do this.

My (admittedly not very good, but does the job!) entry:

Classascii.ascii {

ClassMethodascii()
{
    setx="!#$%&'()*+,-./0123456789:;<>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdfghijklmnopqruvwyz{|}~"
}

}

Let's say the characters i

Traditional Caché Objectscript has the multi-dimensional array as its main form of complex data structure and the $order command as the main means of traversing said data structures. But newer versions of Caché ObjectScript also have data structures that are direct parallels of what languages such as JavaScript provide, in the form of %DynamicObject and %DynamicArray. These have an easy to use iterator feature via the %GetIterator method, and even a handy built-in literal syntax for constructing new objects.

Given all these nice features, are there any disadvantages to using these fancy new fea

Hello,

I have a slight issue that's causing me some inconvenience when using the rule editor within Microsoft Edge (Version 126.0.2592.81).

Whenever I try to load up any ruleset, the ruleset displays an unhappy face like this:

This has only recently started, when opening up the rule editor in another browser e.g. Chrome, the problem disappears.

I've tried to remedy the situation by resetting Edge, Updating Edge Version, Clearing Cache/Cookies etc. but nothing seems to fix it.

I have other colleagues opening the same rule sets in the same version as Edge without any issue, so I do not be

Hi Community,

Play the new video on InterSystems Developers YouTube:

⏯ CommonWell Connection @ Global Summit 2023

I'm trying to use the EnsLib.SQL.Operation.GenericOperation component in a production to read a column from a Redshift table that is set up as VARCHAR(65535) and am getting the following error.  

An error was received : ERROR #5023: Remote Gateway Error: JDBC Gateway getClob(0,1) errorRemote JDBC error: Cannot convert the column of type VARCHAR to requested type long..

The query I'm using is a simple 'SELECT column_name FROM table_name'.  I've done a little research and it sounds like Redshift doesn't support getClob().  Is there anything I can do to force the gateway to not use getClob() on

Is CR/LF changes to DTL files edited/committed to git via VS Code a known issue?

We had an issue with exporting files from one server and importing on another, using XML code exported from Studio: ERROR #6301: SAX XML Parser Error. Turns out that issue was down to CR/LF changes made when transferring the XML from one server to the other.

Now we are getting the same error only with DTL files when (1) creating DTL on Management Portal, then (2) exporting via VS Code ObjectScript extension, (3) committing to git (GitLab, self-hosted instance, if it matters), and then (4) subsequently cloning fr

Ok, I am attempting to clarify the required use of the RESIZE command, when you have a UNIVERSE or a UNIDATA DB attached to Cache. Traditional UNIVERSE / UNIDATA databases 'require' that hashed files be re-sized according to historic use, to prevent file overflow (aka. performance issues). It is not clear if that requirement is fully eliminated by attaching one of these databases to Cache. It is clear that, if you do not allocate 'enough' space on Cache for the database 'as a whole', that is a problem. But, Cache space allocation for the database 'as a whole' seems to be separate and distinct

I was looking for an easier way to build the FHIR Query String, given the Record Map request that is passed into the DTL.

I built this Function, but when I run a message through it, my Query String that is passed back into the DTL is a Reference Pointer and not the String I am looking for. 

ClassMethod BuildFHIRQueryString(record As%String, Output queryString As%String) As%Status

{

    // Assuming 'record' is a string containing the record map data

    // Define the delimiters

    Set fieldDelimiter = "|"

    Set repeatDelimiter = "~"

   

    set queryString = ""

We've just started using Health Connect and I've found that a lot of the messages we get from our patient admin system (System C's CareFlow EPR) don't match the standard 2.3.1 schema (eg 2.3.1 ADT A02 message spec doesn't include NK1 segments, but the ones we receive do)

Does anyone have a custom schema they use for messages from CareFlow EPR that they'd be willing to share?

Artificial intelligence (AI) has transformative potential for driving value and insights from data. As we progress toward a world where nearly every application will be AI-driven, developers building those applications will need the right tools to create experiences from these applications. Tools like vector search are essential for enabling efficient and accurate retrieval of relevant information from massive datasets when working with large language models. By converting text and images into high-dimensional vectors, these techniques allow quick comparisons and searches, even when dealing wi

Hello! I was wondering if there was a way to have a Service in HealthConnect restart if there have not seen any messages in a certain amount of time? I have a connection problem that requires me to restart services often and I was hoping to create a task that would automatically restart the services. Thank you! 

It's been a long time since I didn't write an update post on IoP.

So what's new since IoP command line interface was released?

Two new big features were added to IoP:

• Rebranding: the grongier.pex module was renamed to iop to reflect the new name of the project.
• Async support: IoP now supports async functions and coroutines.

Rebranding

The grongier.pex module was renamed to iop to reflect the new name of the project.

The grongier.pex module is still available for backward compatibility, but it will be removed in the future.

Async support

IoP supports async calls for a long time, but it was n

What is wrong in this snippet??

Its an iris lab so nothing so personal that someone can't use it

{

    "workbench.colorTheme": "InterSystems Default Dark Modern",

    "intersystems.servers": {        

        "irislab": {

            "webServer": {

                "scheme": "https",

                "host": "35.188.112.210",

                "port": 29363

            },

            "username": "tech",

            "password": "demo"

        }

    },

    "objectscript.conn": {

        "server": "irislab",

        "ns": "USER", // Add your namespace here (e.g., USER)

        "a

Hi Community,

Play the new video on InterSystems Developers YouTube:

⏯ How Netsmart Moved to InterSystems IRIS in the Cloud @ Global Summit 2023