Portal

How can I insert a line return in a Semarchy form?

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.

Example:

Original SemQL, using comma as separator.

LOOKUP
string_agg FDN_Product
separated by ', '
from PersonProducts
order by FDN_Product
END

Original Result

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

Updated Result

References: 

https: //markdown-guide.readthedocs.io/en/latest/basics.html#line-return

https://stackoverflow.com/questions/31039189/add-line-breaks-to-nested-lists-in-markdown