RowMerge
Merges content from a multi-record-set databox result into a single string (Keyfax version 4.4.8 and later).
Expression
Databox Value
Result
Comments
Last updated
Merges content from a multi-record-set databox result into a single string (Keyfax version 4.4.8 and later).
This Expression constructs a string from a multi-record Databox such as can be achieved by selecting the multi-record-set option on a SQL Query or HTTP databox.
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
separator - a string containing the characters to use between each formatted string when joining the result together
RowMerge("[name] ([userId]), ",")
<KFXmlValue rows="1"><KFRow id="0"><userId>1</id><name>George Smiley</name></KFRow><KFRow id="1"><userId>2</id><name>Ann Sercomb Smiley</name></KFRow></KFXmlValue>
George Smiley (1), Ann Sercomb Smiley (2)
This expression compliments FieldMerge that achieves this goal only for the first record of a databox result (if multiple records exist).
RowMerge is useful when you require a comma separated list of results from a SQL or HTTP databox.
Last updated