Scenario: In a form with a lookup SemQL expression, the business need is to have each returned Product displayed on a separate line. Currently, Products are separated by a comma and share a single line.
Solution: Between single quotes, add 2 spaces and the Enter/Return key.
Original SemQL, using comma as separator.
LOOKUP string_agg FDN_Product separated by ', ' from PersonProducts order by FDN_Product END
Image 1: Illustration depicts products on a single line separated by comma.
Modified SemQL using 2 empty spaces + Return/Enter for a line return.
LOOKUP string_agg FDN_Product separated by ' ' from PersonProducts order by FDN_Product END
Image 2: Illustration depicts products on separate lines.