Search

Clear filter
Article
Sergey Kamenev · Jul 7, 2017

Globals - Magic swords for storing data. Sparse arrays. Part 3

of our universe not just because of its flexibility, but also thanks to its ability to quickly save a data thread while concurrently creating index globals for quick search. If we go
Article
Sergey Kamenev · May 23, 2019

PHP module for working with hierarchical data in InterSystems IRIS

parameters of this function are strings or numbers. The first one is the name of the global, then there are the indexes, and the last parameter is the value. iris_set('^time',1
Article
José Pereira · Jun 5, 2021

FHIRaaS overview

. For instance: ``` curl -X GET "https://fhir.lrwvcusn.static-test-account.isccloud.io/Patient" -H "accept: application/fhir+json" -H "x-api-key: your-apy-key" ``` ### OAuth 2.0
Article
Theo Stolker · Feb 2

DB.Changelog: Keeping track of database changes using SQL Triggers and CodeMode = objectgenerator

ChangeLog.DB.NameValues Extends %Persistent { /// Name Property name As %String; Index nameIndex On name [ Unique ]; /// Value Property value As %String(MAXLEN
Article
Yuri Marx · Feb 25, 2021

Day 3: Developing with InterSystems Objects and SQL

to SQL commands, from terminal, execute do $system.SQL.Shell(). Persistent classes have a system generated ID, if you need ID controled by you, use IDKEY index with one or more
Question
Eduard Lebedyuk · Feb 7, 2016

Best practices to store user information/settings in Caché

User As Security.Users; Property Settings As %String; Index UserIndex On User [ IdKey, PrimaryKey, Unique ]; /// Set settings for User equal to Settings ClassMethod
Question
Scott Roth · Nov 23, 2016

Text File Fixed Format

91 b/m Average Seizure Energy Index 7471.4 ?V? Postictal Suppression Index N/A Maximum Sustained Power 15787.0
Question
Stefan Schick · Mar 24, 2022

Howto add / remove searchtable items

] { Parameter DOCCLASS = "EnsLib.HL7.Message"; Parameter EXTENTSIZE = 4000000; /* Re-declare indices because the superclass is abstract */ Index indexValue On (PropId, PropValue
Question
Ikara Ikliki · Nov 15, 2019

Status ErrorList parameter: When using $SYSTEM.Status.DecomposeStatus(tSC, .tErrorList) what is the type of tErrorList returned and how to intialize

own error Let me know if you need any help } } The tErrorList is returned as an array. tErrorList itself (without index) is an increment
Question
Kurro Lopez · May 24, 2019

How to copy array values from JSon to object using DTL

a nonexisting Next methodyou could create a loop using <WHILE> and do a "manual" loop.For the condition source.retorno.datos.polizas.poliza.%Size() gives you the index
Question
Vivek Ranjan · Mar 12, 2018

Persistent table with %GUID As property

: USER>set obj = ##class(Test1).%New() USER>set obj.Property1 = "Hello" USER>w obj.%Save() 1 USER>w obj."%%GUID" FC381F94-277E-11E8-82F0-005056B479AA The ^OBJ.GUID index that this creates can be accessed via %ExtentMgr.GUID.
Question
Mathew Lambert · May 23, 2018

##class( autocomplete for classnames

longer to index prior to cache existing, and that is why you encountered the performance hit. @Scott.Morrison9195 @Fred.Gustafsson, thank you for bringing this issue to our attention
Question
Martin Karas · Oct 1, 2019

NoExtent and object references

to one object only. Adding a BitMap extent index to class B helps compensate for the fact that all B objects are stored together, and improves the performance of queries on the subclasses.
Question
Arto Alatalo · Aug 12, 2019

How to read global via Stream interface

an adapter to a function expecting Stream? Nice, thanks. But it seems that this way will work only if the global has an ID as first index. This way involves copying of the data
Question
Rochdi Badis · Apr 10, 2022

SQL query confusion

. In this case, you should ignore host variables. Host Variables You can also try rebuilding the Index Table or clearing Cached Queries. Portal uses cached query and in its code it uses