Search

Clear filter
Question
Scott Roth · Jan 18, 2018

Using StartsWith with a data lookup table

EN",BUC OR")An HealthShare expert might be able to answer if it is possible to have an index on the fields of your WHEN condition.A different approach could be to handle the whole
Question
Hannah Sullivan · Aug 24, 2023

How to best cascade deletes for a property that is a list of a persistent class

impressive design.So you need to add an index on the ELEMENTS of your Property Organizationsto find all affected objects.some example of how to Thank you for the clarification
Question
John Bradshaw · Jul 12, 2023

Help with global mapping with two namespaces with a static subscript

As %String [ Required ]; /// Contact Row IDProperty RowID As %Library.String(SELECTIVITY = 1, TRUNCATE = 1) [ Required ]; Index RowIDBasedIDKeyIndex On (NS, RowID) [ IdKey, PrimaryKey
Article
Yuri Marx · Apr 4

Part III: Studying for IRIS Developer Professional Certification with the "Ask Developer Community AI

| InterSystems IRIS Data Platform 2024.34.InterSystems Embedded Python in glance5.Python (Tools/APIs) | InterSystems API Index | InterSystems IRIS Data Platform 2024.36.New
Article
José Pereira · Dec 27, 2021

Using Python to Implement an IMAP Client in InterSystems IRIS

from a list by its index, using the [\_\_getitem\_\_](https://docs.python.org/3/reference/datamodel.html#object.\_\_getitem\_\_) special method: USER>Set b = ##class
Article
Henry Pereira · Dec 1, 2021

Data anonymization, introducing iris-Disguise

that follow. It is certainly a non-trivial feature to implement, but it gives you the ability to keep a patient encounter intact as the visit goes from admit to discharge. This scares
Question
Nicky Zhu · Sep 3, 2018

Why does a DT succeed in test while failed in run time

;/UBadguanxing> ...</Record></test>The value of UBadguanxing will trigger the generation of labresult.the result is as below: <Container> <Patient>
Article
Eduard Lebedyuk · Aug 3, 2020

Creating classes/tables with more than 999 properties in InterSystems IRIS

in IRIS or Caché. Entity–attribute–value model is usually used for this purpose. I have already written about this at the time: SQL index for array property elements. That's
Article
Yuri Marx · Jul 20, 2022

Create Stored Procedures using Embedded Python

Python has become the most used programming language in the world (source: https://www.tiobe.com/tiobe-index/) and SQL continues to lead the way as a database language. Wouldn't
Article
Brendan Bannon · Jul 15, 2021

Embedded SQL new in InterSystems IRIS

is flexibility in a live environment. In the past, if you add an index or ran TuneTable, the SQL in Cached Queries would make use of this new information right away while embedded SQL
Question
Krishnamuthu Venkatachalam · Sep 12, 2020

Calling a classmethod of an instance from another instance via native method

to interact with is linked to an underlying Global Definition (Data, Index and Stream) then use the Global Mapping to Map the Globals used by the class into Namespace A 5) The Class
Article
Benjamin De Boe · Jan 10, 2023

Columnar Storage in 2022.3

in a columnar index or data map. Also, you'll see it combine columnar and bitmap indices in a number of cases, which is great if you're starting off by adding columnar indices to an existing
Question
Gaolai Peng · Sep 18, 2017

How to import a tab separated text file into a SQL table programmatically

= "Pending" ];Index idxRPPI On RPPI;ClassMethod LoadFromFile(){ Set pFileName="C:\mytest.tsv" Set pDelimiter= $C(9) Set rowType="RPPI varchar(50),Name varchar(516),BirthDate Date
Article
Murray Oldfield · Mar 11, 2016

InterSystems Data Platforms and performance – Part 2

is here](https://community.intersystems.com/post/capacity-planning-and-performance-series-index) ***Edited Oct 2016...*** *[Example of script to extract pButtons data to a .csv
Article
Maks Atygaev · Dec 11, 2016

Declarative development in Caché

://www.tiobe.com/tiobe-index/). [Edit, changed to 8. Pretty sure C and ASM don't have anything like this.]I don't want to say this is you, but some people have no room for innovation