A list function that indicates whether the specified element exists and has a data value.
Examples
The following examples show the results of the various values of the position argument.
All of the following $LISTDATA statements return a value of 1:
SELECT
$LISTDATA($LISTBUILD("Red",,Y,"","Green")),
$LISTDATA($LISTBUILD("Red",,Y,"","Green"),1),
$LISTDATA($LISTBUILD("Red",,Y,"","Green"),4),
$LISTDATA($LISTBUILD("Red",,Y,"","Green"),5),
$LISTDATA($LISTBUILD("Red",,Y,"","Green"),-1)
The following $LISTDATA statements return a value of 0 for the same five-element list:
SELECT
$LISTDATA($LISTBUILD("Red",,Y,"","Green"),2),
$LISTDATA($LISTBUILD("Red",,Y,"","Green"),3),
$LISTDATA($LISTBUILD("Red",,Y,"","Green"),0),
$LISTDATA($LISTBUILD("Red",,Y,"","Green"),6)