Commencer un nouveau sujet
Répondu

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

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


Meilleure réponse

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

Image 1: Illustration depicts products on a single line separated by comma.
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


Updated Result

Image 2: Illustration depicts products on separate lines.
Image 2: Illustration depicts products on separate lines.

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

1 commentaire

Réponse

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

Image 1: Illustration depicts products on a single line separated by comma.
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


Updated Result

Image 2: Illustration depicts products on separate lines.
Image 2: Illustration depicts products on separate lines.

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

Connexion pour poster un commentaire