Search

Clear filter
Question
Arockia Raj B · May 19, 2017

SQL/Non-SQL

Caché comes with 3 models "out-of-the box": Globals, SQL, Caché Objects.Everything in Caché is stored in Globals, which are multidimensional key-value indexed variables with persistent
Article
Mike Kadow · Oct 24, 2016

NewBie's Corner Session 22 Parameters Part III

" for an index of all NewBies' Posts Hi, Mike!
Article
Eyal Levin · Apr 8, 2024

using Procedure Parameters with ODBC/JDBC

ObservationValueDisplay, ObservationValueText, PerformerDisplay, PerformerIdentifier FROM BIProjection.Observation where ObservationLastUpdated > maxDate") do $system.SQL.Execute("BUILD INDEX
Question
maxime keltsma · Apr 18, 2024

Direct access to a global without SQL

Ideally though, you would have an index defined, and this could be read much more efficiently than having to scan an entire global set count=0 set existscheck=0 //Set to 1 if we only
Article
Jon Jensen · Feb 4, 2016

Show post rating with colored stars

It shows a numerical average inder the stars, but the stars are all just outlines. I thought if there was an average rating, that the stars would be colored yellow.
Article
Yuri Marx · Apr 6, 2022

Unit Tests: Quality of your ObjectScript Code

analysis solutions are used (there is no functionality execution at the time of testing) of the source code, where naming patterns, indentation, declared and unused variables, coupling index
Article
Niyaz Khafizov · Oct 8, 2018

Record linkage using InterSystems IRIS, Apache Zeppelin, and Apache Spark

(params[columnsSize + i][:params[columnsSize + i].index('-')])) secPart2 = '-' for elem in params[columnsSize + i][params[columnsSize + i].index
Question
Evgeny Shvarov · Dec 24, 2022

How Can I Check That IRIS is IRIS for Health?

Asking @Patrick.Jamieson3621 - is what Danny suggested above an eligible way to make sure IRIS is an IRIS for Health indeed?
Question
Nikita Savchenko · Nov 26, 2017

What is the Best Way to Rename Persistent Classes which Already have Data?

This value is not only in the data global but it will also be present in index globals. Even if you do not rename the globals you will have to update these values.
Article
Evgeniy Potapov · Jan 15, 2022

Your own webserver logfile analyser

I had published The Article about the dataset from a real webserver, which can demonstrate how can activity and load of the Apache webserver depends on day of week, search engines indexing
Question
Virat Sharma · Jan 30, 2023

SQL Query Help in $ListGet

Maybe have a look at %Library.FunctionalIndex and look at the defining indexes section in the documentation for BuildValuesArray() See the answers here.
Question
Marco Blom · Jun 20, 2023

IRIS Nodejs Quickstart

exists or add a new declaration (.d.ts) file containing `declare module 'intersystems-iris-native';`ts(7016) module "C:/Nodejs Quickstart/Solutions/intersystems-iris-native/index
Question
Ondřej Hoferek · Jun 10, 2016

Passing a Dictionary (array of data types) from .Net to Caché

The System.Array must have zero-based indexing.arrayIndex: The zero-based index in array at which copying begins.
Article
Wilber Tang · Jul 25, 2016

Tips & Tricks - How to remove a group of HL7 segments

RemoveSegmentAt(), for example, can be used to remove a segment by path or index, but only one segment at a time.
Discussion
Evgeny Shvarov · Aug 18, 2019

How do You Document Globals You Use in a Project

But if you use globals for calculations, temporary storages, for special indexes or for some other purposes - how do you document it? Possible options which come to my mind: 1.