Hi ,

Can anyone share some good sample custom CCR Utility classes that would be called by ImplementCCR routines / CCR event hooks to help bootstrap a HealthShare (2020.1) environment or specific change?

Thanks,
Paul

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?

basically, bellow is and example of my query currently produce, where records 2 & 3 are the similar with different times   :

1,  record1 ,10/02/2022 ,13:40:00

2,record2,11/02/2022, 14:11:00

3,record2,11,02,2022,16:00:00

4,record3,12,02,22 , 11:00:00

and in this case I would like my query to get the latest record in time to achieve the following:

1,  record1 ,10/02/2022 ,13:40:00

2,r

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: 

• Prometheus' text-based format is line oriented. Lines are separated by a line feed character (\n). The last line must end with a line feed character. Empty lines are ignored.

Link is here: Prometheus format

In the current output on the

<hostname>:8080/api/monitor/metrics

endpoint the last metric does not contain a newline causing parsers to fail.

Hi, the class %Library.Storage has several methods such as  %BuildIndices(pIndexList As %RawString = "" ...), %ValidateIndices(idxList As %List = ""...), ... which take as a parameter (amongst others) a list of indices (in the example, the signature of the list is not the same but I guess it does not matter).

My question is: can get this list in code ? I know that is it possible to get the list of properties of a class in code, but can I have the same for indices ?

For those wondering what I'm trying to achieve:

I want to be able to update the schema of my database between two version of a

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
send: znspace "ME_NAMESPACE"<CR>
wait for:ME_NAMESPACE>
send: do

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"

After that we load and compile the .xml:

write $SYSTEM.OBJ.Load("C:\InterSystems\HealthShare_2\opt\contenedor\zpm-0.2.2.xml")

The

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

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.

INSERT INTO "Fehlermeldung" VALUES (1001021,'qsDataFieldOutOfRange','10','Der Wert ''<wert>'' des Datenfeldes <feldName> \"<feldBezeichnung>\" ist <artDerAbweichung> als <feldBound>.','<params wert=\"\" feldName=\"Modul.name:Bogen.name:Feld.name\"

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"
Set tSC=##class(Config.Namespaces).Create("%All",.Properties)

The documentation for Config.

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. ERROR <Ens>ErrException: <MAXSTRING>zGetReferralDocFromStream+30^UCLH.SIP.Operation.PBT.HTTP.V1.RefDocRequest.1 -- logged as '-' number - @' set file=object.%Get(i).file'
 

2. ERROR <Ens>ErrException: <STRINGSTACK>zGetReferralDocFromStream+30^UCLH.SIP.Operation.PBT.HTTP.V1.RefDocRequest.1 -- logged as '-' number - @' set file=object.%Get(i).file'
 

Can someone please explain what the difference is?

Thanks!

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.

👉🏼 InterSystems Developer Community Annual Survey 2021 👈🏼

Note: The survey will take less than 5 minutes to complete.

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.

What are my responsibilities as a beta tester?

You will be assigned the exam and will need to take it within a month of the beta release.

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

##Note

• The only-positive or only-negative integer may appear more than once
• Use this code to check the result length
• You also can use this test case here

Rules

1. The signature of the contest entry MUST be:

Class CodeGolf.PairedOpposites
{

ClassMethod Solve(o As %String)

InterSystems has corrected a defect that can result in an SQL query returning incorrect results.

This defect exists only in the 2021.2 (Continuous Delivery) version of:

            InterSystems IRIS Data Platform

            InterSystems IRIS for Health

            HealthShare Health Connect

InterSystems has replaced existing distributions of these products with new builds that correct the defect. The corrected distributions can be identified by the build number (651) and are available via normal means. Ad Hoc corrections are not available for Continuous Delivery (CD) distributions.

This defect

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.

The process begins automatically at Caché startup and scans your cconsole.log for new messages on a regular interval, by default

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

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:

&js< 

               var test = document.getElementById('seTest');

               for (var i = 0; i < test.options.length; i++) {

                              // Do Something here with my test.options[i]...

               }             

>

Now, because we are using < inside this for loop Studio will

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:

SET tSC = $ZF(-100,"/ASYNC /SHELL ", "python", "/data/InterSystems/IRIS/mgr/TEST01CODE/ExcelReading/ExcelToCSV.py")

ConfigItem 'FJ EXCEL READING' (FJ.BS.ExcelReading) started in job 3164

ERROR #00: (sin descripción de error)

Any ideas or suggestions?

The second error I have is

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 ?