It's time to announce the Winners for April! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in April:

🥇@David Hockenbroch, senior analyst, WoodWare Systems, United States
🥈@Sylvain Guilbaud, Sales Engineer, InterSystems, France
🥉@Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

Learn more about the competition and our awesome winners below.

Why can't I switch images when there are many queues

Title.

I've searched the forum and documentation with no luck. Thanks!

When creating pivots in DeepSee, there is the ability to group date dimensions by Day, Week, Month, Quarter, Year. For some of our reporting the Week option is desired. However the display looks like the image shown below. Notice the "YYYYW##" formatting.

Is there any ability within DeepSee to modify the display of grouped week dates? E.g. instead of 2020W14 it could be 03/30/2020-04/05-2020, or even just the start or end date, etc.

Hi, I would like to ask how to develop the socket API with HealthShare, such as developing the socket external BS, and the socket-call BO. Thx!

Hello there friends,

I am new to DC and I need to advance up my self.

I see that we get awarded with badges and so on through that process.

But i do not exactly get the idea of it.

I see that we have a challenge of becoming the insightful commenter and so on.

I would like some one to help me out with it so that i could get to the next level.

Regards.

Some languages ​​have the concept of a garbage collector for automatic memory management. I'd like to know if something like this exists in InterSystems Caché in the context of routines, %CSP.REST, or %CSP.Page.

The question arises from the %Close() method of the %RegisteredObject class. This indicates that I need to manually clear the object from memory if it's no longer in use, or in the web context, if the request has completed. Is this correct? Or am I completely wrong?

Thank you!

Hi! I am trying to export Cache data to my SQL database and am trying to export the schema as well.

The Data Export wizard on the Management Portal only allows me to export the data but not the schema. Is there anyway to get the schema exported as well?

Hi,

I tried to create what is know as a "class variable". As far as I understand the only analogy to class variables would be the "class parameters".

I tried to use a class parameter but I cannot change its value at runtime.

Parameter STATUSES = {{}};

Property repr As %String;

Method %OnNew(repr) As %Status
{
w ##class(Test...).#STATUSES
w ..#STATUSES

...

}

Hey,

since our instance of iris is just utilized during working hours, I would like to simply copy all data via FTP from the server to a NAS during the night.

Are there reasons against this approach?

Are there batch examples of how to stop and start the database?

Thank you in advance!

Erik

How can i send .xml files from linux server to windows using cache codes with out using any FTP commands. Need to send a copy of the .xml file to a windows folder

How to call multiple SQL gateway connections in BO

When I'm asked questions about SQL, I like Intersystems staff at the WRC, generally ask about the Query Plan. My feeling is that even before you run a query you should examine the results of Show Plan to confirm that the code is going to give me the results in the manner I would expect. If I expect it to leverage an index and I see that it is not then I go back and look at what I might have done incorrectly and try to re-write the query to get the index behavior I'm looking for. To that end, there's a poll below to ask you if think moving the Show Plan button as the first button would be

Hi Community!

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Overview: Connecting Devices to InterSystems IRIS for Health

https://www.youtube.com/embed/W4R3owdQRpg
[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]