Symantec IGA

 View Only
  • 1.  Ca Identity Manager: Send Email With a List of Items

    Posted Jul 30, 2019 04:38 PM
    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


  • 2.  RE: Ca Identity Manager: Send Email With a List of Items
    Best Answer

    Broadcom Employee
    Posted Jul 31, 2019 11:48 AM
    Have you try to use /n /r as a delimiter and see if that work?


  • 3.  RE: Ca Identity Manager: Send Email With a List of Items

    Posted Jul 31, 2019 01:02 PM
    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