Hi IRIS experts!

I have a parameter in a class that stores a global name:

Parameter GlobalName = "^AGlobal";

then I'm trying to call it as:

set gn=$name(..#GlobalName)

to use it later as:

set @gn@("index")="value"

But! I'm having syntax at set gn=$name(..#GlobalName)

What am I doing wrong?

I have dynamic sql select query ,

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

set sql = "SELECT COUNT(*) FROM "_tableName_" WHERE "_fieldName_">='"_fromDate_"' AND "_fieldName_"<='"_currentDate_"'"

SET SC = resultset.Prepare(sql)

SET SC = resultset.Execute(sql)

How can I print/view the count ?

I want to provide a shortcut to the D.C. A.I. from a hotkey which will automatically populate the question field here - https://community.intersystems.com/ask-dc-ai.

Is there a way to construct this URL such that it will populate the "Ask a Programming Question" field (and better yet, execute the query)?

Thanks!

I am a first time Python Contest participant and am interested in potentially implementing the community idea found in https://ideas.intersystems.com/ideas/DPI-I-542 if it is something relevant to Python.

Would anyone be able to shed a bit of light on what the desired outcome of that idea being implemented is? There were a lot of upvotes on that idea but there wasn't very much information in it. Thanks!

Hi,

I have a spring-boot Java application which has Quartz Scheduler (spring-boot-quartz-starter) dependency, and uses IRIS DB.
There is a problem with making Quartz Scheduler work with IRIS since there is a blob field expected in two tables, but IRIS is using longvarbinary type.
Can you provide me with clues on how to resolve this?

I am using org.quartz.impl.jdbcjobstore.StdJDBCDelegate driverDelegateClass.

This is the error:
MisfireHandler: Error handling misfires: Couldn't retrieve trigger: invalid stream header: 41434544

Hi,

I'm currently working on configuring an Ens.Alert component within Ensemble 2018, and I'm looking to set up a system default settings for it.

Could anyone guide me through the process of setting up these default setting for the Ens.Alert component?

Thank you in advance!

Online document says: TUNE TABLE updates the SQL table definition (and therefore requires privileges to alter the table definition). Commonly, TUNE TABLE also updates the corresponding persistent class definition. This allows the gathered statistics to be used by the query optimizer without requiring a class compilation.

I cloned @Yuri.Marx's langchain-iris-tool repo and modified docker-compose yaml per this post:

https://community.intersystems.com/post/error-when-trying-langchain-iris...

Now I see this:

To transfer data between production components I actively use messages of type Ens.StreamContainer class and its descendants. In many cases the content of the message content is not visualised (the 'Body' tab contains a table with a list of selected message properties but the 'Contents' tab is empty). Response messages are never visualised, and request messages are visualised with a fifty-fifty probability. What do I need to do to ensure that messages are always visualised?

Throughout the forum, I find examples of using the method getSegmentByIndex to get the segment as I loop through the HL7 message segments.

Today I spent way too long trying to figure out why I could not modify the segment with this same method. I reached out to my more experienced team and I showed where I got the base code from what I was doing, but I myself could not find the documentation of the method.

Hi Developers!

With InterSystems IRIS Cloud SQL recently becoming Generally Available, some of you may have had a chance to try it out. Or maybe you used it for your contest entry or during the EAP period. We're curious to learn what YOU think of it. So, have you already tried the new service InterSystems IRIS Cloud SQL?

We have launched a new Ideas Portal category dedicated to this database-as-a-service (DBaaS) where we're looking for your ideas on how we can improve InterSystems IRIS Cloud SQL.

Or share your experience with the service in the comments to this post.

What's your approach to learning InterSystems technologies?

Elevate your learning journey with us: share your insights in a brief survey and help us shape your learning experience.

Hey Community,

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