Search

Clear filter
Article
Luis Angel Pérez Ramos · Feb 20, 2023

Connecting to MySQL database from a Business Service using JDBC connections

parameters: System: MySQL Server: mysql User: root Date: SYS You will find a new database configured named test if you access it you will find a table named patient with two
Article
Tani Frankel · Mar 29, 2016

Getting Production Setting's Value

(NameExists) in the documentation Note, that the index "Name" is defined in this class. <Index>Exists is just an automatically generated method that returns a boolean (Passed
Question
Steve Pisani · Feb 15, 2016

Retrieving last known record (based on a date) in series of logged events

value equal to true would be used to build a cube You can calculate such property on a class side, something like this. Index by CitizenRef and RelocationDate, and method which
Article
Dan Pasco · Feb 22, 2024

IRIS 2024.1 Preview - New Feature

to interpret JSON expressions for each row in the table, without using indexes. The ISO Standard syntax for JSON_TABLE includes a FORMAT keyword. We are working on a binary compressed
Article
Luis Angel Pérez Ramos · Feb 7, 2024

Sending WhatsApp messages from InterSystems IRIS production

with glucose level data for a certain patient. Depending on the level received, we will send the patient one message template or another. Business Service We will start
Article
Robbie Luman · Aug 15

Beginner's Guide to %JSON and Dynamic Entities in IRIS

to understand that dynamic arrays will be 0-indexed, as opposed to standard IRIS arrays which are 1-indexed. All dynamic arrays start at index 0. Getting back to arrays, once you
Article
David E Nelson · Mar 9, 2017

Machine Learning with Spark and Caché

into a vector. It also involves indexing the classes, replacing "Iris-Setosa" with 0.0, "Iris-verisicolor" with 1.0, and "Iris-Virginica" with 2.0. Randomly divide the Iris data
Question
Token Ibragimov · Aug 8, 2019

Sending Get request

zeros in request ?GET /201506/91001?PAGE=INDEX HTTP/1.1must be/201506/091001 You already using concatenation, it, means, that you lost leading zero, somewhere before. You may have
Question
Evgeny Shvarov · Oct 6, 2022

What is the Analog of $DATA for Embedded Python

at index ^Global("x","y")? E.g.: In ObjectScript I'd do the following: set result=$data(^Global("x","y")) How do I do the same in Embedded Python? I checked the documentation
Question
Evgeny Shvarov · Apr 10, 2021

Do we have one-to-one relationships in IRIS

" feature -> Class Sample.Person Extends (%Persistent, %Populate) { - - - Property Spouse As Sample.Person Index sp On Spouse [ Unique ]; // to verify 1:1
Question
Patrik Spisak · Nov 28, 2024

Embedded SQL - CODE 100

value, in my case ID I got same result. SQLCODE 100 but from management portal SQLCODE 0 and returned 6 IDs. I created new Index to the table and rebuild indices and now its works. But its weird why I got different result in embedded SQL and management portal.
Question
John Hotalen · Jan 26, 2022

ZEN Tablepane double click issue

to this dblclick="zenPage.resolveQATicket();" and within the resolveQATicket client method I try to retrieve the selected row index, so I can do some actions
Question
Daniel Lee · Aug 1, 2023

How to search for messages based on size

the property FullSize in a SQL statement: SELECT ID FROM EnsLib_HL7.Message WHERE FullSize > ? Take care because this is a calulated proprety and doesn't have a index. As others have
Question
Ran Kahane · May 17, 2023

Identity property - CacheSQLStorage

, Transient ]; Index PMKey On (Subscript1, Subscript2) [ IdKey, PrimaryKey, Unique ]; Storage MainStorage{<SQLMap name="MainMap"><Data name="Data"><Delimiter>"$c(31)"<
Article
Iryna Mykhailova · Oct 30, 2018

Caché eXTreme for .NET - direct access to globals from C

first return to the level of a single index. To do this, use the SetSubscriptCount() method with parameter 1. And further, using the Set() method, simply add subscripts