Handle Arrays Using Get and Set¶

Introduction¶

This page describes how to handle arrays using the Get and Set functions.

Array Handling¶

Array handling can be accomplished using this syntax:

Set("varname","value",-1);

This will create an array variable called varname and append value to it. Note that you can use either a string varname or a global variable named varname. The array can be read in a sorted manner by using SortArray.

When to Use Global Variables¶

There are scenarios where building global variables dynamically is valuable, leveraging the capability of Set to work with a string as the variable name. For example, you can incorporate the data value into the global variable name and use it later in the workflow, such as when using a condition filter. For example:

soql = "Select purchase_order_number__c from PO_c";
arr = Array();
arr = SFLookupAll(<tag>,soql);
i = 0;
While(i < Length(arr),
Set("po_num_" + arr[i],true);
i++;
);

For use with the above example, the condition filter could be defined as follows:

If(Length(Get("po_num_' + <source_po_value>)) > 0, true, false);

It is true that this could also be accomplished with a dictionary. With smaller datasets, global variables and dictionaries are equivalent. But when dealing with larger datasets, performance will be faster using a specific global variable rather than a dictionary.