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 ]
{

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. We are based in

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

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 Community,

We are pleased to invite all the developers to the upcoming InterSystems Analytics Contest Kick-off Webinar! The topic of this webinar is dedicated to the Analytics contest.

On this webinar, we’ll demo AtScale, InterSystems Reports (Logi), IRIS BI, IRIS NLP and answer the questions on how to develop, build, and deploy Analytics applications using InterSystems IRIS.

Date & Time: Monday, August 23 — 10:00 AM EDT

Speakers:  
🗣 @Carmen Logue, InterSystems Product Manager - Analytics and AI
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

Team,

I am trying to use Visual studio code(1.57) for class development and for compiling classes (intersystems tools extension) . It works.

Now, i would like to use TFVC (Team Foundation Version Control) for source control.  

I can see download option where i can manually download the Namespace as folder and classes as files.

Since whenever i save the file, it directly pushes the change to remote system. I am not sure where the local workspace is.

How to configure VS Code to track my changes and Check In / Check out the code.

Data transformations can be changed in Management portal, but the modifications are not synced with visual studio code. Classes are synced from VSCode to Iris. VSCode can take care of the git repository.

I am curious to know how people are developing data transformations on Iris with VSCode? Are you editing the DT classes with VSCode and forget about the UI? Are you exporting from management portal the files to VSCode directory? Are you using a source control hook?

Thank you

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Visual Studio Code for ObjectScript: Server-Side Source Control

After linking in Oracle Table with Field Column's Data Types of NUMBER, my updates into these table fields are resulting in data that is being rounded to 2 decimal places. I insert a record with 1234.1234 and 1234.12 is stored.

It appears Cache xDBC might be manipulating my values prior to sending to Oracle. Is there a setting or system parameter that is controlling this? If so, is there a way to relax this from occurring so the values I send are being stored in Oracle with the same values?

Hey Developers,

New video is already on InterSystems Developers YouTube:

⏯ Visual Studio Code for ObjectScript: Choosing an IDE/Source Code Combination

Hi all
    Is there anyway to decrypt the PBKDF2 encrypted data in a table?

Thanks,
Syed M

I want to try SAM in AWS. I followed these steps:

docker pull store/intersystems/sam:1.0.0.115

git clone intersystems-community/sam: System Alerting and Monitoring (SAM) (github.com)

git clone https://github.com/intersystems-community/sam

tar zpxvf sam-<version>.tar.gz

tar zpxvf sam-1.0.0.115-unix.tar.gz

$ cd sam-<version>

cd /home/ec2-user/git/sam/sam-1.0.0.115-unix/

$ ./start.sh

Hi Developers, 

We've launched a friendly discussion on Global Masters called "Let’s meet developers' pets!" and invite all of you to join!

There are already so many cute photos from the community members. So, whether you have a dog 🐶, cat 🐈, hamster 🐹,  or gecko🦎, we want to see them!

Hey Developers, 

Are you ready for the new challenge? We're pleased to announce the first InterSystems technical article writing competition:

🏆 InterSystems Tech Article Contest 🏆

Write an article on any topic related to InterSystems technology from July 15 to August 15August 22 – extended!

Prizes for everyone: Everyone who publishes an article on DC during this period will receive a special prize pack!

Main Prize: Apple iPad

Join our new contest and your content will be seen by over 55K monthly readers! Details below. 

So I've got the IRIS AMI spun up in AWS EC2; it seems to be running fine.  
I've added an EBS volume to it for persistent storage, and now I'm pondering how to make it actually do something useful.  

What's the best way to do deploy code to this instance?  I can think of a few ways to do it, but what's the least painful way?  Push my code to an S3 bucket and figure out how to load it at system start?  Github project?  

I have attached a document that describes the product I have developed called NiPaRobotica Pharmacy. This is an interface I developed that accepts Pharmacy Dispense Requests and converts the line items on the order into dispense dialogues which it sends to pharmacy robots. I deployed the interface into 3 Hospital pharmacies two of which had 6 robots that were arranged in such a way that the dispense chutes channelled medications to desks by the pharmacists sitting in windows serving 1200 patients a day. The robots cut the average waiting time from 2 hours down to one hour. I then deployed the

I have described my efforts to optimize IRIS Mirror deployment in AWS ElasticContainer Service (ECS) in my prior article.

IRIS Mirror in the cloud (AWS) | InterSystems Developer Community | AWS
 

I have come to the opinion that IRIS Mirror is not as reliable as needed when deployed in ECS. The root of the problem is the fact that ECS randomly assigns one of the available IP addresses to each EC2 host or Fargate task it starts.

These get stored in iris.cpf file in MapMirrors section as shown here:

[MapMirrors.IRISMIRROR]

Hey everyone as you may know I am a beginner and I am kindly asking for some assistance in a problem I have been solving. The problem is that I am calling a user defined function within a procedure called occupiedseatsAdj and the compiler comes up with this error.