Cust_Rcrd_List_Values

Returns values of a column in the CUST_RCRD table for the rows selected by a list of key values.

Arguments

Cust_Rcrd_List_Values(
<Record_Class>	// In CUST_RCRD.
, <col name>	// A column name in CUST_RCRD.
, <key list>	// List of zero or more possible RCRD_KEY values.
, <Delims>	// One or two characters which serve as delimiters in <key list>.
, <occurrence>	// An occurrence (index) within <key list>; 0 for all.
)

Examples

Assume that CUST_RCRD table contains the following rows:

RCRD_CLASS	RCRD_KEY	%T001	%T002
CustType	123	abc	ABC
CustType	234	def	DEF
CustType	345	ghi	GHI
CustType	456	jkl	JKL
CustType	567	mno	MNO
CustType	678	pqr	PQR

Cust_Rcrd_List_Values(
"CustType"
, "%T001"	// Get the value of "%T001".
, "234,"	// List of key values.
, ","	// List delimiter.
, 1	// Use first key in list.
)

Returns: "def"

Cust_Rcrd_List_Values( "CustType", "%T001", "234", ", ", 1 )

Returns: null // no delimiter in the key list

Cust_Rcrd_List_Values( "CustType", "%T002"

, "123,999,234,"

, ",",3 // no delimiter in the key list

)

Returns: "DEF"

Cust_Rcrd_List_Values( "CustType","%T002", "123,999,234,"

,",",2 )

Returns: null // No record for key "999".

Cust_Rcrd_List_Values( "CustType" ,"%T002"

, "[123][678]"

, "[]" // List uses left & right brackets.

, 2 )

Returns: "PQR"

Cust_Rcrd_List_Values( "CustType" , "%T002"

, "[123][678]"

, "[]"

, 0 // Want all occurrences.

)

Returns: "[ABC][PQR]"

Cust_Rcrd_List_Values( "CustType"

, "RCRD_KEY" // Probing the key column.

, "[123][678]"

, "[]" ,0

)

Returns: "[123][678]" // Yes, key values are there

Cust_Rcrd_List_Values( "CustType" , "RCRD_KEY"

, "[999][678]" // First one is a dud.

, "[]" ,0

)

Returns: "[678]"

Cust_Rcrd_List_Values( "CustType" , "RCRD_KEY"

, ".123.999.234."

, ".."

, 0

)

Returns: ".123.234."