We are looking at moving from Cache to IRIS, if we do this we will want to use Intersystems Reports.  We have a lot of Crystal Reports to convert.  is there a conversion tool or best practice for doing the conversion 

Hi, in the end I want a report like this:

In my case I have about 1,230 tables/views in the database.  The initial approached I've used is to use this SQL to generate SQL to make the actual measures:

SELECT 
string('select ''', table_schema ,''' as "Schema", ''', table_name,''' as TableName, COUNT(*) as RowCount from ' , table_schema,'.

Hi Community,

I see the announcement https://www.intersystems.com/news-events/news/news-item/intersystems-ir…. But I didn't find in the AWS marketplace. Do you know where find this option?

GA releases are now available for the 2020.4 version of InterSystems IRIS, InterSystems IRIS for Health and InterSystems IRIS Studio.

InterSystems IRIS Data Platform 2020.4 makes it even easier to develop, deploy and manage augmented applications and business processes that bridge data and application silos.

Upgraded healthshare to health connect. The search box is not selecting the correct url 

i.e. selecting message loads 

http://penn-tietest:57772/csp/sys/EnsPortal.MessageViewer.zen?$NAMESPAC…

instead of this which when go through the menu it loads 

http://penn-tietest:57772/csp/healthshare/tie/EnsPortal.MessageViewer.z…

it actually loads from interopability view messages as 

http://penn-tietest:57772/csp/healthshare/tie/EnsPortal.MessageViewer.z…;

Please can someone advise 

Similar to Caché so also in IRIS,  you have ClassQueries available in 2 variants

• Basic class queries, which use the class %SQLQuery and an SQL SELECT statement.
• Custom class queries, which use the class %Query and custom logic to execute, fetch, and close the query.

Testing ECP-based applications often take quite some effort for setup and preparation.
I have created a Docker-based workbench that allows you to have it quick at hands.
And if you crash it? You just give your containers a fresh start.
The whole setup runs code-based during the start-up of your instance.
In that sense, it is also a portable coding example using ZPM and the objectscript-docker-template

 see Video

I'm almost running out of disk space so I want to move 1 DB to a different hard drive.  
It's a rather simple but lengthy action during a shutdown of IRIS.  
But is this somehow possible under runtime in a stand-alone installation?  
I'm looking for kind of a "local drive failover"  
note: Mirror or Shadow is not an option.  

Hey everyone.

I have been revisiting our backup strategy, and spotted that IRIS supports VSS (Volume Shadow Copy Service) in Windows. This is quite attractive as an approach, as it automatically calls the external freeze and thaw commands.

However when calling these manually, there's quite a few parameters that can be set, and the documentation around VSS only states that the freeze/thaw commands are called.

Is there a way of controlling the parameters used, or at the very least know what the defaults are?

In this case I am trying to just send a simple error to the log in the event the try is not successful.  Have tried a few ideas I have found on the forum but none have worked as of yet.  

   try {
          // Write facility Details to cloned message
      set newPV139 = (FacilityNPI1 _"^" _FacilityName _"^" _ServFacility _"^" _FacilityTIN _"^" _FacilityAddressLine1 _"^" _FacilityCity _"^" _FacilityState _"^" _FacilityZip _"^" _CountyName _"^" _FacilityPhone)
      set newPV139insert = newrequest.SetValueAt(newPV139, "PV1:39(1)")
            } 
                 catch exception {

            }

Ever noticed that the Type column of the Web Applications page in the Security section of Management Portal is showing you redundant information?

Hi Developers, 

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

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

🥇 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

🥈@Dmitriy Maslennikov, Co-founder, CTO and Developer Advocate, CaretDev Corp, Russia

🥉@Henrique Dias Dias, System Management Specialist / Database Administrator, Sao Paulo Federal Court, Brazil

Learn more about the competition and our awesome winners below.

Hi All!

Examining the page here I see we have one-to-many and parent-child relationships supported in the InterSystems Objects model.

Do we support one-to-one too?

anyone know of a simple way to search a blob of text from a list of keywords in one fell swoop, without having to iterate through each keyword and perform an individual search? Ex. 

s keywords="This,blob,text"

s text = "This is a sample blob of text"

i text[keywords w "hit"

Hello,

I am trying to figure out if we can extend a business process in IRIS. My Use Case is that I am developing RESTful Interfaces and my each REST Interface needs to go through certain processes before getting to the actual action.  

e.g. I have 2 REST Interfaces, GetPatient and GetEncounter. Both of these need to invoke "GetToken" Business Operation to go to the Authentication server to get an authentication token before they go ahead and hit the Business Operation to Get the data i.e. Patient or Encounter.

I'm looking for a way to have an IRIS db distributed over several (hw) drives.  
Without touching the internal data structures (e.g. mapping) !  
Are there any options in file systems to achieve this "splitting" or "appending" ? 

Historic background:

• Once upon a time CPUs worked on 32 bit
• Files could mostly not be larger than 2 GB
• And Caché had a (forgotten) option to EXTEND a db to a next file of another 2 GB max. and a next ...

This EXTENT was excellently suited to move fresh and active data
to a faster spindle for more performance.
 

[ oh

After running an extensive block of daily statistics my IRISTEMP has expanded dramatically.   
But FreeSpace shows 97% unused and FREE space.   
How can I shrink IRISTEMP in runtime without shutdown and manual intervention
(which was the traditional approach)

Hey Developers,

Please welcome the new video on InterSystems Developers YouTube:

⏯ System Alerting & Monitoring

We have a Unicode installation of Cache'. A client wants to send us documents that will be machine-read and loaded, automatically. They want to create the documents in ISO-8859-1 ("Latin-1"). We'd need to convert the text to UTF8 for our system. I saw the documentation on the $ZCONVERT function, but I didn't see this option. How should it be done?

Thanks!

Hi guys,

I've created an iris command line utility to interface the Linux command line with Interface IRIS

https://github.com/RamSailopal/iriscmd

It maybe of use to some of the community

Ram

Hi Developers!

This is a release of how did we improve the Developer Community in March 2021. The key features:

• Global Masters badges page
• User mentions page
• Post translation indicator
• Updates in the Jobs section
• Updates to the "New post" button on DC Tag page

See the details below.

FIrst of all thank you for your time in reading this question and writing a response,

We would need some help,

-> Our objective is to control which method is being used in the service: GET POST PUT

We have tried to understand the example REST Service: Demo.REST.DirectoryService

After that we have tried to create our own custom rest service,

please take a few minutes to examine the following code:

Class Servicios.REST.miSCS.Pruebas Extends EnsLib.REST.Service
{

Parameter ADAPTER = "EnsLib.HTTP.

Hi Community,

I use an excellent service to collect time programming. Is the WakaTime: https://wakatime.com/.

This service integrate with main IDE tools, including VSCode and collect time spent by project, language, IDE and code stats at general. See my last 7 days:

These information help me to organize and balance my targets by project.

To use Waka signup the service: https://wakatime.com/signup and into your VSCode, into extensions search waka, see:

Restart your VSCode and now input your api key, you can get your api key into https://wakatime.com/settings/account.

Hello, in a zen page sometimes I find document.getElementbyId("ID") to set a propertybut also zen("ID").setPr.... So what is the real difference and limitations of each?

Hello, Community!

Did you know that InterSystems Learning Services has a comprehensive exam for Technical Specialists on HealthShare Unified Care Record? It really is the gold standard to show that you have the skills and abilities required of competent technical specialists in Unified Care Record. Depending where you are in your career, it can be a valuable door opener or escalator to new opportunities. 

Interested? 

1. Here's what's on the exam. 

2. Here's the publishable credential, valid for 5 years, that you get when you pass the exam.

3.

What is Distributed Artificial Intelligence (DAI)?

Attempts to find a “bullet-proof” definition have not produced result: it seems like the term is slightly “ahead of time”. Still, we can analyze semantically the term itself – deriving that distributed artificial intelligence is the same AI (see our effort to suggest an “applied” definition) though partitioned across several computers that are not clustered together (neither data-wise, nor via applications, not by providing access to particular computers in principle). I.e., ideally, distributed artificial intelligence should be arranged in such a way that none of the computers participating in that “distribution” have direct access to data nor applications of another computer: the only alternative becomes transmission of data samples and executable scripts via “transparent” messaging. Any deviations from that ideal should lead to an advent of “partially distributed artificial intelligence” – an example being distributed data with a central application server. Or its inverse. One way or the other, we obtain as a result a set of “federated” models (i.e., either models trained each on their own data sources, or each trained by their own algorithms, or “both at once”).

InterSystems IRIS 2019.1 has been out for a while and I would like to cover some enhancements for handling JSON which might have gone unnoticed. Dealing with JSON as a serialization format is an important part of building modern applications, especially when you interact with REST endpoints.

The InterSystems IRIS can be extended using Java or .NET components and its frameworks inside Object Script source code.

I created an application called OCR Service It built with Docker and installs Google Tesseract inside docker instance configured with english and portuguese dialects, but is possible install more than other 100 dialects. Google Tesseract can receive images and return text extracted from it, using OCR. The results are very good with the trained dialects. But you can train Tesseract to read car plates and any other textual patterns and load it to extract text.

Hey community,

I want to create my own table resizer. I know that there are some plugins that are doing exactly this but I would like to create my own one. :)

I have created a function, which is called in the onloadHandler and which append a div to each th-element of a given table. The method looks like this:

function initializeTableFeatures(){

    jQuery.each($("#table > table > thead > tr > th"), function() {
         if(this.id !== ""){
              var div = createDiv($(this).outerHeight());
              $(this).append($(div));
              $(this).

In Studio you could open a class directly via it's name, without having to traverse the package tree with multiple clicks until arriving at the desired class.

You would Ctrl + O or (File -> Open) and be able to simply type in the class name, for example:

You press Enter, and viola - the class is opened.

How do you achieve this in VSCode?