KB Article #176397
arrays & DML
Problem
-- there are no arrays in DML.-- how to store values in an Array/List/table (during runtime) and later do lookup from the list.
-- don't want to use external database to store values
Resolution
There are different options that can be used :* create a few Java custom functions that use an array or list for what you want to achieve (add, list, remove, etc…)
* use an attribute with an array field structure in it. I would advise keeping a separate field as well that keeps the count of how many items are stored in your array.
* use a variable to keep a list of values with a separator (ex. ‘|' or ‘;'). The DML function findString(), countString(), index(), etc… can extract the values you need or know how many you have.