Hi Guys,
I've the below query that selects the existing processes with dates & times and it working fine, but in case of records with the same processedDate I would like to only get the latest based on processedTime field?
Hi Guys,
I've the below query that selects the existing processes with dates & times and it working fine, but in case of records with the same processedDate I would like to only get the latest based on processedTime field?
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:
The current version of SAM creates Prometheus metric endpoints which appear to be handled correctly by the current prometheus scraper, however the metrics do not confirm to the current prometheus standard. The standard states:
\n). The last line must end with a line feed character. Empty lines are ignored.Hi, the class %Library.Storage has several methods such as %BuildIndices(pIndexList As %RawString = "" ...),
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.
Hello everyone, I'm trying to run a cache terminal script from cmd/ batch.
I run it like this C:\MyCache\bin#cterm.exe C:\Users\Me\Desktop\cache_scrip.scr
The command opens a terminal, but nothing happens, no title present, no log file written, no output, it's just stucked.
Here is my script:
case match: off title MyTitle ; wait for the terminal to initialize and ask for our identification echo: on wait for:Username send: MeUser<CR> wait for:Password send: mepass<CR> logfile: C:\Users\Me\Desktop\cache_script.log pause:10
Hi Guys,
The lines in my dynamicGrid are getting chopped off and not wrapping to the next lines, how can I make rows wrapping to the next line pls?
Thanks
Does anyone have a script for demo docker containers - to remove login prompt?
Essentially to make container behave as if it had minimal security.
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
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.
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.
Hello,
We have read the installation guide to get started with zpm package manager:
https://openexchange.intersystems.com/package/ObjectScript-Package-Mana…
We wonder what means the second step:
"Import the zpm.xml into IRIS and compile via any desired way (Management Portal, Studio or Terminal)"
We have thought that it means to place the zpm-0.2.2.xml file inside "C:\InterSystems\HealthShare_2\opt\contenedor"
Then in the terminal, go inside one namespace:
zn "esbsscc"
Hi Community,
I have created SOAP service and WSDL generated. While accessing WSDL URLs, it is redirecting to login page and giving access with production credentials.
I have tried to invoke form webservice clinet (soapui /postman), endup with authentication failed error.
Same service I am able to access from Terminal.
Could you please help me to access Production exposed SOAP service with out authentication.
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 All,
I am registered as an InterSystems Developer but when trying to login to the registry I get the following error
Error response from daemon: Get "https://containers.intersystems.com/v2/": unauthorized: BAD_CREDENTIAL
I am also unable to download the 'kit' for windows from the eval site.
Cheers,
Shaun
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:
Set Properties("Globals")="%DBDEFAULT"
//Set Properties("Library")="IRISLIB"
Set Properties("Routines")="%DBDEFAULT"
//Set Properties("SysGlobals")="IRISSYS"
//Set Properties("SysRoutines")="IRISSYS"
Set Properties("TempGlobals")="IRISTEMP"
Hello,
We have recently received the two following errors as part of a PDF extraction process and I am trying to figure what the difference is between the two errors?
1.
Dear Comminuty,
Can you provide learning path recommendations to start on "InterSystems IRIS for Health"?
Hey Developers,
Thank you so much for being with InterSystems Developer Community for yet another year!
Day by day our team is trying to make it better and more useful for InterSystems developers. More than 10K+ members are already registered in our Community!
We'd like to know how helpful the Developer Community is for you today. Please take a few questions to let us know what do you think and what could be improved.
Hello CCR Community,
InterSystems Certification is developing a certification exam for CCR and, if you match the exam candidate description given below, we would like you to beta test the exam. We anticipate the exam being available for beta testing on February 7, 2022, but interested beta testers should sign up now by emailing certification@intersystems.com. The beta testing must be completed by March 31, 2022.
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
3has no matching negative appearance
##Note
InterSystems has corrected a defect that can result in an SQL query returning incorrect results.
The MONITOR process (also called the Caché Monitor) scans the messages in your cconsole.log file and sends you emails based on the severity of those messages. The MONITOR is configured using the ^MONMGR utility in terminal.
The MONITOR should not be confused with the similarly named System Monitor, which checks a variety of system health and performance metrics and can log messages regarding them to the cconsole.log, where they can then be scanned by the MONITOR.
This package was triggered by the extra bonus points in the contest for writing the example
in embedded Python only. Therefore PURE
Based on the previous example it looked like being a simple task. A mistake!
I met a bunch of issues that I had to workaround.
But I have to admit that there might be ready solutions and I just didn't find them.
This concept may be known to some, but I just found it very useful and I would like to share as it may help someone else.
If you are working with CSP or Zen you sometimes come across the need to use embedded JavaScript. Suppose you are working with some loops, which use < or > as shown in example below:
Hello guys! I need some assistance with these problems I have.
The first one is that I need to execute a Python file, which is at /XY path. This PY is supposed to read an excel file and create a CSV version in /XZ path.
I am quite sure that the PY file is correct, but when using this function I get nothing but this error:
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 ?
Is there a straightforward workflow in VS Code for moving a class from one namespace to another on the same server? With Caché/IRIS Studio, it was a (sort of) simple export/change namespace in file menu/import operation. But in VS Code it's not obvious (to me, at least).
I can add multiple namespaces to a workspace, but when using isfs:// paths I see only a "Download" option and no "Upload" or "Import/Compile." When I'm navigating the local file tree, I see Import options, but no way to select the namespace into which I want to import.