Caché | InterSystems Developer Community

Article

Daniel Aguilar · Mar 22 3m read

Tasks & Tricks: The Dev's Fish & Chips

Hi Community!

Do you usually work with automated tasks? Then let me share with you a pair of tips ;-)

Tip 1: How to know when my automated task will end (approximately)

#Tutorial #Caché #InterSystems IRIS

9 4

2 156

Article

Hiroshi Sato · Mar 21 2m read

SQL access method for properties that define list collections

InterSystems FAQ rubric

Properties defined in list collections (Property XXX As list of %String;) can be manipulated using SQL functions: $LISTBUILD(), $LISTFROMSTRING().

For each SQL function, please refer to the document page below.

#Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health

3 1

1 142

Article

Hiroshi Sato · Mar 28 1m read

How to register and reference task schedules programmatically

InterSystems FAQ rubric

Here, we will introduce a sample code for registering and referencing task schedules.

①Sample of task schedule registration

*Create a task to execute do ^TEST every day at 1:00 am.

#System Administration #Tips & Tricks #Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health

5 1

0 103

Article

Hiroshi Sato · Mar 7 1m read

Performing index rebuild in multiple processes while using an application

InterSystems FAQ rubric

You can use the %IndexBuilder class to perform index rebuilding using multiple processes.

Here is an example for the purpose of defining the standard index HomeStateIdx for the Home_State (state information of contact address) column of Sample.Person.

The steps are as follows:

1. Hide the index name to be added/rebuilt from the query optimizer.

#Tips & Tricks #Caché #InterSystems IRIS #InterSystems IRIS for Health

2 0

1 137