If you need write your organization Data Architecture and map to the InterSystems IRIS, consider following Data Architecture Diagram and references to the intersystems iris documentation, see:

Architecture mapping:

• SQL Database: https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls?KEY=GSQL
• Managed Files: https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls?KEY=AFL_mft and https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls?KEY=SETEDIGuides
• IoT Broker, Events and Sensors: https://docs.intersystems.com/irislatest/csp/docbook/Doc.View.cls?

PORTUGUESE

Olá a todos!

Estou com dificuldades de fazer meu select para retornar palavras que contém acentos.

Na minha tabela TESTE, por exemplo, tenho palavras no campo NOME como Fábio e Fabio, porém se eu coloco a instrução:

SELECT * FROM TESTE
WHERE nome LIKE 'FÁBIO'

a instrução só traz FÁBIO.

Como eu faço para trazer todas as palavras: FÁBIO, FABIO, FABÍO, FABIÓ, FÁBÍÓ, FÂBIO, etc...

Conto com sua ajuda!

ENGLISH

Hello everyone!

Hi Developers,

Please welcome the new voting rules for the InterSystems programming contests!

See details below: 

Dear HealthShare Customer:

This post is part of the HealthShare HS2021-03 Alert communications process.

Hi Community,

System Alerting and Monitoring (SAM) in InterSystems IRIS data platform helps you efficiently monitor and manage your systems. This video shows some solutions it offers for specific challenges faced by developers and operators:

⏯ The Value of System Alerting & Monitoring (SAM)

I started working with InterSystems Caché, however, I am in the Quality area. What is the best way to use the benefits of this tool?

Hi All,
I am implementing REST API's in IRIS using the below link as a guide. 
I chose this approach so i could have a single entry point for requests regardless of namespace

https://community.intersystems.com/post/restful-exception-handling 

a sample form the HIHLib.REST.Server class i am using is below. my question is does IRIS and CSP cache responses for requests to the CSP.REST class?
and if so what parameters or properties do i need to enable?

i notice the %CSP.Page class that %CSP.REST inherits from has an EXPIRES parameter that can be set, and %CSP.

Routing acks from one operation to another:

I was working on a scenario in which I wanted the acks and/nacks received from one downstream system to another interface which is not the source of the original message. Is there a way to achieve this scenario?

The reason being there's a separate interface handling the acks and will be used to manage the errors.

Thank you for the help!

Introduction

InterSystems has recently completed a performance and scalability benchmark of IRIS for Health 2020.1, focusing on HL7 version 2 interoperability. This article describes the observed throughput for various workloads, and also provides general configuration and sizing guidelines for systems where IRIS for Health is used as an interoperability engine for HL7v2 messaging.

Hello, authors of projects published in ZPM.

We ask you to add a module.xml to the file. attribute Description and republish your projects.

To update the description of your module in the public register ZPM, update the release in Open Exchange please. https://openexchange.intersystems.com/markdown?url=assets%2Fdoc%2Freleases.md Thanks.

Standard error logs in IRIS / Caché / Ensemble are written global ^ERRORS.
As this piece dates back some decades back to previous millennium, its structure
is far from the typical SQL storage structures.

Hi, I have a class that extend to other classes.

If I compile one of this classes, no problem is generated.

But if I try to compile the first class using flag c-ukb, all that extend from that and have the Date component generate an error.

The error is about the method %GetPaneContents from abstract class.

Do you already passed this? How can I solve my problem?

I have a need to create a custom deployment package for our production. I can't do a full deployment of the production so I need to create a custom deployment package that will add our new classes, business processes, rest end points and transforms. I would like for the production to add and configure the business services, process and operations as well.

Does anyone have an example for doing this? 

Thanks,

Phil

Hey Developers!

We have great news for InterSystems IRIS developers! We're pleased to invite you all to join our annual competition of creating open-source solutions using InterSystems IRIS! Please welcome:

🏆 InterSystems Grand Prix Programming Contest 🏆

Duration: February 8 - March 8, 2021

Total prize: $16,000 

Where can I download the InterSystems ODBC Cache Driver?

thanks,

Brian

Hi Community,

Please welcome the new video on InterSystems Developers YouTube:

⏯ Deploying InterSystems IRIS Solutions into Kubernetes Google Cloud

Hi everyone.

I wonder, whether is it possible to get description of emoji in COS.

For example, I have data with emojis like 🙏 in database, that should be delivered to transaction system via service. But service doesn't support emojis, so I want to convert emoji to its unicode description like "Person with Folded Hands". Is it possible? I'll be grateful for help

Hello All, Can anyone tell me whats the best python IDE and code editors? I am a little bit confused between Eclipse + Pydev,  Pycharm, Sublime Text,  Visual Studio Code, Vim,  GNU/Emacs,  Atom/Atom-IDE, Cloud9. 

Hi Community!

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Overview: Connecting Devices to InterSystems IRIS for Health

Hi Developers! 

We double up the number of points awarded for each post and translation on Developer Community. Starting from 03/18/21 you get for each article or question:

✅ 200 points on DC EN
✅ 400 points* on DC ES / PT / CN / JP

and
✅ 100 points for each translation!

Also, do you remember that you get a bunch of points for a pack of articles/comments? Please check here:

Is there an easy way to see if a class object has been compiled or needs to be?  Or to get a list of classes that need to be compile in a particular namespace?

Hi,

Im wondering if its possible to pass a SQL query through to the Power BI IRIS Connector? I can't currently see an option - and have tried through advance editor to use M Query syntax to attempt this with no luck. 

Has anyone else in the community had any luck or know if this is supported?

Thanks.

One of the REST APIs we need to call takes one of request parameter as a byte array. I am trying to create a message class and couldnt figure out which is equivalent type that corresponds to Byte[]. I need to read from a jpg file and then convert it to byte[] before i invoke this webservice. Appreciate if anyone can point me in the right direction. I can use %Stream.FileBinary class to store the jpg file after loading from a file. trying to figure out how to convert that to byte[].

Thank you,

Ravi

IRIS use MIRROR to ensure the continuous operation of the hospital business, but MIRROR synchronization data does not contain (web application configuration information, task plans, sql gateway, etc.), about the synchronization of such information do we have a better solution to solve this problem?

It is common to test a connection sending a general SQL instruction to the database, in Oracle we send select 1 from dual, for example, and in IRIS what the best option?

Hey everyone.

I have a process where I create a new %Stream.FileCharacter object, specify the filename (including it's path), write data to the stream, and then save. However for some reason, if the user account does not have write access to the directory, the %Save method is still returning true even though it was unable to actually write the file to the folder.

The location is a UNC path, and I'm wondering if this is tripping me up?

Hi 

I have a class in several namespaces. This class is what I call a common component in that it is a class that performs a certain set of functions that are common to a number of Interfaces. In this example the class is essentially a Message Queue. When a Data Event is created in my source database I want to invoke the CreateMessage() class method in all of Interface namespaces.

The common component class has a name DFI.Common.Queue.ODSMessageQueue. I can inherit the class into one or more classes e.g. DFI.Common.Queue.Interface1MessageQueue, DFI.Common.Queue.Interface2MessageQueue.

Is there any ETL tools for the data process  in the Cache database?

Hi Community!

We're pleased to welcome Xin Yao as our new Moderator in the Developer Community Team!

Let's greet Xin Yao with big applause and take a closer look at his bio!

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems Grand Prix Contest!

Date & Time: Friday, March 12, 2021 – 10:00 EDT

What awaits you at this virtual Meetup? 

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used, bonuses, questions. Plans for the next contests.