New post

Find

Question
· Dec 31, 2024

How to Connect Laravel 11 with InterSystems IRIS Data Platform via ODBC?

Hi everyone,

I'm trying to connect my Laravel application with the InterSystems IRIS Data Platform using ODBC.I need help setting up the ODBC connection and querying the database properly. What is the proper way to configure Laravel to work with an ODBC connection to InterSystems IRIS?

Any help would be greatly appreciated!

Thanks in advance!

1 Comment
Discussion (1)1
Log in or sign up to continue
Question
· Dec 30, 2024

Unique Index Open on Empty String

I have a unique index on two properties in a class, and I want to open the instance by index key with one of the two properties is set to the empty string. Is this possible to perform?

Take the example class here

Class TestIndex
{

Property Mandatory as TestClass [Required];
Property Alternate as TestClass;
Property AltOrEmpty As %String [ Calculated, Required, SqlComputeCode = {Set {*} = $Case({Alternate},"":$c(0),:{Alternate})}, SqlComputed ];
Index AlternateMandatory on (Mandatory, AltOrEmpty) [ Unique ];
}

And example data as

Mandatory Alternate AltOrNUL
2    
2 3 3

I can open the second line in the table as 

>set testInstance = ##class(TestIndex).AlternateMandatoryOpen(2,3,.st)
>w st
1

And I want to be able to use the same functionality to open the first line. This would be as open on one valid Id and on empty string, which results in an attempt to open NULL and fails. 

>set testInstance = ##class(TestIndex).AlternateMandatoryOpen(2,"",.st)
>zw st
ERROR #5770: Object open failed because 'AlternateMandatory' key value of '2:NULL' was not found

I am wondering if there is a syntax that would work to find and open this instance based on the unique index containing the empty string, or not based on the inherent design to have a unique index on an empty string.

2 Comments
Discussion (2)2
Log in or sign up to continue
Digest
· Dec 30, 2024

Publicações Desenvolvedores InterSystems, Dezembro 23 - 29, 2024, Resumo

Dezembro 23 - 29, 2024Week at a GlanceInterSystems Developer Community
Digest
· Dec 30, 2024

InterSystems Developers Publications, Week December 23 - 29, 2024, Digest

Articles
Announcements
#InterSystems IRIS
#IRIS contest
#Developer Community Official
Questions
Discussions
December 23 - 29, 2024Week at a GlanceInterSystems Developer Community
Question
· Dec 30, 2024

[Duda] Gestionar alertas cuando hay mensajes encolados y/o el tiempo de espera es excesivo

Buenos días,

Muchas gracias por leerme y sobre todo gracias por su ayuda al responder.

 

He estado indagando sobre cómo enviar alertas cuando en una Producción de Interoperabilidad, el tamaño de la cola y/o el tiempo de espera son excesivos.

 

He visto que en las Operaciones y los Procesos, existe el apartado de "Control de Alertas" en la Configuración:

 

He probado a poner "Alerta sobre el tamaño de la cola" a 1, he desactivado la operación, he reenviado 2 mensajes, he comprobado que se encolan:

Sin embargo, no veo que al "Gestor de notificaciones de alerta" de la Producción: "Ens.Alerting.NotificationManager"

Le llegue un mensaje...

¿Me podrían ayudar con esto? ¿En qué sección / log se ve lo que se envía cuando el tamaño de la cola excede a lo especificado en Control de Alertas > Alerta sobre el tamaño de la cola?

 

Gracias por su ayuda

 

He estado indagando en varios recursos previamente a preguntar:

https://community.intersystems.com/post/ensemble-business-operation-queu...

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

https://community.intersystems.com/post/email-alert-operation

https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cls...

 

Si me pueden ayudar se los agradezco infinito.

Gracias. 🙂🙂🙂

3 Comments
Discussion (3)2
Log in or sign up to continue