I tried a lot of things
For example;
- Replace the ; for:
\n, \\n, /n, //n, \r, \\r, /r, //r, unicode, ascii code ---> For the email is plain text and the result is for example role1\n role2\n role3
- Concatenate the new line in the SQL Query with CHR (10) and CHR (13) but for the email is plain text always so the platform erased the CHR and literally add an space
- Concatenate html tags in the SQL Query (<br>)
Regards
Martin
Original Message:
Sent: 07-31-2019 11:47 AM
From: Yuan-Heng Lin
Subject: Ca Identity Manager: Send Email With a List of Items
Have you try to use /n /r as a delimiter and see if that work?
Original Message:
Sent: 07-30-2019 04:37 PM
From: Martin Cederbaum
Subject: Ca Identity Manager: Send Email With a List of Items
Hi,
Here's my problem.
I need to create an email that when modifying an specific user, lists all the roles associated with that user.
The problem is that when I'm doing the query to the database and received the email, the roles are one next to each other separated by ^ (I made a replace so that they are separated by ;).
e.x: role1; role2; role3;
The idea is that in the email the roles appear as a list (one below the other) and not in the current way. Is there a way to do this?
e.x: role1;
role2;
role3;
Thanks in advance
Regards
Martinn