RowMerge
Returns a string in list format that contains all referenced data from a multi-record-set Databox (Keyfax version 4.4.8 and later).
This Expression constructs a string from a multi-record-set, multi-value Databox such as an HTTP Request or a SQL Query.
The syntax of the call is:
format - a string containing a string with square bracketed column names to indicate the positions at which the column values should be substituted into the string
seperator - the string to use between each row's data e.g. a comma with a space (", ") produces a reasonable output for a list
RowMerge("[name] ([userId])", ", ")
<KFXmlValue rows="2"><KFRow id="0"><userId>1</id><name>George Smiley</name></KFRow><KFRow id="1"><userId>2</id><name>Tobey Esterhase</name></KFRow></KFXmlValue>
George Smiley (1), TobyEsterhase (2)
RowMerge requires that the databox contains a KFXmlValue with an attribute rows to indicate that it is a multi-record-set result.
Last updated