Hey Developers, 

Learn how to use InterSystems IRIS data platform to meet change data capture (CDC) challenges created by data silos:

⏯ Stay in Sync with Change Data Capture

Hello Again,

We still need additional beta testers for this exam so that we can set a statistically valid passing score. Thus, if you match the exam candidate description given below, we would like you to beta test the exam!

Exam title: HealthShare Patient Index Technical Specialist

Exam candidate: An IT implementation professional who:

• has 6-12 months experience with installing, configuring and supporting the HealthShare Patient Index product to provide either a standalone system or as a master patient index for the HealthShare Unified Care Record, and
• Hello Again,We still need additional beta testers for this exam so that we can set a statistically valid passing score.

New to Health Connect so please forgive me if this is a stupid question! Is there a specific error code returned when a user initiates an abort from the jobs tab of the business host? I want to be able to treat the Abort as Completed due to our complex business process. Currently, hitting abort just retries the message to the same business operation. Want I want to do is provide the error code used by the Abort (if there is one) and treat it as OK

Thanks in advance.

I have a client running cache on an AIX platform. I put together a objectscript to allow for the viewing the processes running against the database using a select from SYS.Process. One of the values I want in the view of the processes information is Jobtype but I want to convert it from the numeric value to a string value. In the Intersystems documentation there is a reference to an include file $syPidTab.inc that should include macros that make this translation. I have not been able to track down this include file.

There is  a finite list of date formats that users want to use to enter a date in a form. These formats include single digits for month and day and double digits for year.  The field is represented by a dateText control.

How would one get to allow a dateText control to accept multiple date formats ? I see only 3 listed here, do those include using single digits for month and day ?

I tried to set the value of format = "#(myPageProperty.myValue)# " but I got a compilation error in Studio so that went nowhere. Has anyone ever been able to set the format value depending on the user input value?

There is  a finite list of date formats that users want to use to enter a date in a form. These formats include single digits for month and day and double digits for year.  The field is represented by a dateText control.How would one get to allow a dateText control to accept multiple date formats ? I see only 3 listed here, do those include using single digits for month and day ? I tried to set the value of format = "#(myPageProperty.myValue)# " but I got a compilation error in Studio so that went nowhere.

Hello,

I am trying to set up a user that can view the summary in SDA in the clinical viewer.

Is there a specific role that can be assigned that provides a view of the SDA?

https://docs.intersystems.com/hs20202/csp/docbook/DocBook.UI.Page.cls?K…

The August 2021 Learning newsletter is now available exclusively at learning.intersystems.com!

• Get a sneak peek: Virtual Summit Experience Labs 2021
• Build Your First Data Model with Adaptive Analytics
• Try InterSystems IRIS Community Edition for free!
• Check out analytics from InterSystems documentation
• Sign up for upcoming virtual classroom courses

Subscribe here!

Psst: Missing this newsletter in your inbox? Not to worry — we will be back to our regular emailing schedule in September. 

What learning resource names appeal to you? Let InterSystems Online Learning know in this 5-minute survey!

We invite you to the webinar "InterSystems Reports",  on Tuesday, September 7th, at 10:00 (Moscow time). The language of the webinar is Russian.

InterSystems Reports, a part of InterSystems IRIS and InterSystems IRIS for Health, is a robust, modern report generation and publishing solution that includes:

• Report Designer - a tool for report developers to create and preview reports.
• Report Server, which gives users access to run, schedule, filter, and modify reports.

In this webinar, we'll cover all the steps of working with the InterSystems Reports, including:

• We invite you to the webinar "InterSystems Reports",  on Tuesday, September 7th, at 10:00 (Moscow time). The language of the webinar is Russian.Report Designer - a tool for report developers to create and preview reports.Report Server, which gives users access to run, schedule, filter, and modify reports.

If one of your packages on OEX receives a review you don't get notified by OEX only on YOUR package.
​​​So @Evgeny Shvarov  suggested publishing my monthly summary of reviews here in DC.
It reflects my experience with the status I found at the time of my review.

Hey Developers,

New video is already on InterSystems Developers YouTube:

⏯ Becoming More Effective with HL7 Feeds

Hi 

I am getting below error while associating Facebook account :

App Not Setup: This app is still in development mode, and you don't have access to it. Switch to a registered test user or ask an app admin for permissions.

Please note upon opening from Facebook account is working fine, only issue is when opening from InterSystems site.

Thanks

Hey Developers,

Learn about InterSystems Reports, powered by Logi Analytics, a report-generation tool that enables you to rapidly create and view visual reports of your data.

⏯ A Look at InterSystems Reports

In Caché, it's possible to iterate a local array using $QUERY() :

set a("foo") = 50
set a("bar") = 30

set key = "a"
for
{
     set key = $QUERY(@key)
     quit:key="" 
     write key_" = "_@key
}

This code works perfectly, unless it's called in a job (eg: a routine called by the JOB command).

In that case, $QUERY will return an empty string. It's like the array cannot be referenced anymore by simply using it's name.
It works using $ORDER(a("")) but I would like to use $QUERY if possible (because my array has several dimensions and it would require several for loops).

I've created a custom class that extends to the standard HS.Message.PatientSearchRequest. Inside the custom class i just want to pass the data as input only.

But i am getting ERROR #6277: Type attribute, s01:AcoPatientSearchRequest, does not specify valid type for XML input tag: pRequest (ending at line 5 character 171)
</error>

I tried adding Parameter XMLIGNOREINVALIDTAG = 1; and

Parameter XMLSEQUENCE = 0;

but does not seem to work. 

Class MC.ACO.Message.AcoPatientSearchRequest Extends HS.Message.PatientSearchRequest [ ClassType = persistent, Inheritance = right, ProcedureBlock ]
{

Parameter I've created a custom class that extends to the standard  HS.Message.PatientSearchRequest. Inside the custom class i just want to pass the data as input only.But i am getting ERROR #6277: Type attribute, s01:AcoPatientSearchRequest, does not specify valid type for XML input tag: pRequest (ending at line 5 character 171)</error>I tried adding Parameter XMLIGNOREINVALIDTAG = 1; and Parameter XMLSEQUENCE = 0;but does not seem to work.

Hi guys,

Is there a way for me to break down the what contributes to the 100% highest license use so i can clearly analyze what processes or user has consume these licenses which cause the 100% license usage?

Hey Community,

Our first InterSystems Tech Article contest is over. Lots of new content to read: 23 amazing articles 🔥

Big thank you to everyone who participated in our writing competition!

And now it's time to announce the winners... excited?

Hi

   We have an application that is logged using AWS SSO.
   We are passing username and password from the AWS SSO to our application for validating the user.
   But what we need is, we need to login to application without using the password.
   Is there any possible way available for this?

Thanks,
Syed M

Our client is a UK-based company with subsidiary operations in the USA, France, Germany and China. The Company supplies materials which are used for research, development, and specialised manufacturing applications worldwide. The Business Intelligence department is a small but integral part of the company. The department provides support to the wider business through information systems. We are currently seeking a Business Intelligence Caché Specialist that will be responsible for supporting and developing the existing Caché system, which is used widely within the business. Our client is a UK-based company with subsidiary operations in the USA, France, Germany and China. The Company supplies materials which are used for research, development, and specialised manufacturing applications worldwide. The Business Intelligence department is a small but integral part of the company. The department provides support to the wider business through information systems. We are currently seeking a Business Intelligence Caché Specialist that will be responsible for supporting and developing the existing Caché system, which is used widely within the business.

Hi,

I am getting below error while starting production
ERROR <Ens>ErrException: <CLASS DOES NOT EXIST>zgetProductionItems+29^Ens.Director.1 *HS.FHIRServer.Interop.Service -- logged as '-' number - @''

Thanks

After setting AllowedIPAddresses with a valid IP address 

i get the following errors.

ERROR <Ens>ErrException: <READ>zOnTask+44 ^EnsLib.TCP.InboundAdapter.1 -- logged as '-'
number - @''

what am i doing wrong?

and question:

where in the message viewer can i see the source IP of the message?

Thanks

In my Business Operation I need to execute a bookkeeping method every X seconds.

How can I do that?

There are two workarounds (I dislike both):

1. Execute bookkeeping on process start - but there might be no requests at all
2. Create a BS that sends messages to BO every X seconds - it makes production more complex and also queues might not guarantee that the method is executed on schedule.

Thoughts?

Hi Developers!

Here're the technology bonuses for the InterSystems Analytics contest that will give you extra points in the voting.

Adaptive Analytics (AtScale) Cubes usage - 4 points
InterSystems Adaptive Analytics provides the option to create and use AtScale cubes for analytics solutions.

You can use the AtScale server we set up for the contest (URL and credentials can be collected in the Discord Channel) to use cubes or create a new one and connect to your IRIS server via JDBC.

The visualization layer for your Analytics solution with AtScale can be crafted with Tableau, PowerBI, Excel, or Logi.

Documentation, AtScale documentation

Training

Hi Experts,

SQL access,

In the component window, I see that some of the fields have no reference to SQL, for example: The active flag. 

how to know all the active elements, when getdate()>= DateTo or between time between From and To does not work in SQL, I see some existing code, with reference to CAST, please can you provide more details? Thanks a lot.

Can someone tell me why this query 

select vet.ID, svp.ID_PACIENTE, vet.conselho, vet.uf, vet.numConselho, vet.nome, svp.SEQ_SOLICITANTE, vet.numConselho , vlab.numConselho
from RPE.Veterinario vet
inner join RPE.VeterinarioLab vlab
    ON vet.conselho = vlab.conselho
    AND vet.numConselho = vlab.numConselho
    AND vet.uf = vlab.uf
left join MySevi.SolicitanteVeterinarioPaciente svp
    on svp.ID_VETERINARIO = vet.ID
where svp.ID_PACIENTE in ('6408||284144||47633', '6408||284145||47634')

does't return any value and this query

Can someone tell me why this query select vet.ID, svp.ID_PACIENTE, vet.conselho, vet.uf, vet.numConselho, vet.nome, svp.SEQ_SOLICITANTE, vet.numConselho , vlab.numConselho
from RPE.Veterinario vet
inner join RPE.VeterinarioLab vlab
    ON vet.conselho = vlab.conselho
    AND vet.numConselho = vlab.numConselho
    AND vet.uf = vlab.uf
left join MySevi.SolicitanteVeterinarioPaciente svp
    on svp.ID_VETERINARIO = vet.ID
where svp.ID_PACIENTE in ('6408||284144||47633', '6408||284145||47634')does't return any value and this queryselect vet.ID, svp.ID_PACIENTE, vet.conselho, vet.uf,

How can you find referenced entries in a table that have been deleted with the drop column?
I have to find all fields in the database afterwards and then delete them properly.
Has anyone had this problem yet?
Can the information be found in the class or storage definitions?
Thanks for a quick feedback.

Hi,

How to import production from online lab to local windows 10 instance?

Thanks

Hi,

I wonder if anyone could help me.

I'm used to writing Microsoft SQL database queries, but at the moment I am also trying to write reports on an IRIS database (used to be cache) in Microsoft BIDS.

My chief headache is parameters. They don't behave the "normal way" in BIDS, in that you can't rename them. Therefore, referencing them in the main code is a nightmare for me.

Say my report has two parameters. If i want to refer to both in a dataset, I have to list them in the order they are in the report and both by using a question mark, ie:

WHERE
column1 = ?

and column 2 = ?

Hi,I wonder if anyone could help me.I'm used to writing Microsoft SQL database queries, but at the moment I am also trying to write reports on an IRIS database (used to be cache) in Microsoft BIDS.My chief headache is parameters. They don't behave the "normal way" in BIDS, in that you can't rename them. Therefore, referencing them in the main code is a nightmare for me.Say my report has two parameters. If i want to refer to both in a dataset, I have to list them in the order they are in the report and both by using a question mark, ie:WHEREcolumn1 = ?and column 2 = ?