Hey Community,

More than 500 applications are already on the InterSystems Open Exchange.

It's time to announce the best developers and the most downloaded apps for 2021!

Let's take a closer look at our heroes and remarkable apps:

Hello community,

It's been quite some time since I came on this platform.

I have been down with the global pandemic and is currently recovering. Thank you all for your valuable prayers.

I am in the streak to learn something new and want to learn CACHE development.

Is there a possible site or Link that I can follow please.

From BASIC to ADVANCE is my requirement.

Help me out on this community.

God Bless and stay safe.

I have created a package to export a Global into JSON object file and to re-create it by reloading from this file
embeddedPython refers to the new available technologies. It should be understood as a learning exercise of
how to handle the language interfaces. Only Global nodes containing data are presented in the generated JSON file.
Differently from the previous example, this one is using embedded Python only, no ObjectScript. Therefore PURE

Hi Community,

We need to export last 5 days Ens.MessageHeader data for a specific messages into file. I have written custom code to execute SQL query in object script.

Could somebody help me to iterate resultSet and write the data to text file.

Hi

I'm using %XML.Writer to write XML files from a database source, and I see that it is not encoding carriage return or line feed as 
 and 
 respectively, and is instead leaving them unencode.

What can I do to have them encoded?

Andy

Hi,

Management Portal SQL Interface

ERROR #5540: SQLCODE: -104 Message: Field 'QT.Fehlermeldung.parameter' (value '<params wert=\"\" feldName=\"Modul.name:...') failed validation

I've checked the syntax with some public tools with adjusted Tablename "Fehlermeldung" -> `Fehlermeldung`. It seems to be valid, but cache does not accept it.

If anybody could give me some insight on creating the %All Namespace programmatically I would appreciate it. There are quite a few posts I found that reference its creation using the UI, but I cant seem to get passed some validations with any form of the below:

Dear Comminuty,
Can you provide learning path recommendations to start on "InterSystems IRIS for Health"?

You will receive a string of comma-separated integers whose elements have both a negative and a positive value, except for one integer that is either only negative or only positive, our challenge will be to find that integer.
As usual shortest solution wins.

Input

"1,-1,2,-2,3"

Output

3

3 has no matching negative appearance

This package was triggered by the extra bonus points in the contest for writing the example
in embedded Python only. Therefore PURE

What is the best way to add an en-uk.json or an en-za.json file to the custum folder, since the default is en-us.json?

<hspc-home>/base/ui-custom-app/assets/i18n/en-za.json

Where can I get the json files for UK and Za ?

Could be enabled a service as "%service_telnet" from cmd? I need to open a cache terminal from cmd but without this service enabled it is not possible, I mean avoiding the use of manage portal of course.

Hey Developers,

New video is already on InterSystems Developers YouTube channel:

⏯ Using the VS Code Debugger for InterSystems ObjectScript

Hi guys, just a quick question on how get the sql statement that has been executed in a %ResultSet?

so basically after the execute command I would like to save the SQL statement generated in a eg, a global and check sql statement?