Updated on 2025-09-05 GMT+08:00

Collection Functions

The following table lists the collection functions supported by SecMaster SQL syntax.

Table 1 Collection functions supported by SecMaster SQL syntax

Function

Function Description

array[INT]

Returns the element at the INT position in the array. The index starts at 1. For example, id_list[1].

map['key']

Returns the value corresponding to the specified key in the map. For example, extend['id'].