Clarity PPM

Expand all | Collapse all

New line CDATA (Gel Script)

Jump to Best Answer
  • 1.  New line CDATA (Gel Script)

    Posted 10-22-2015 01:54 AM

    Hi All,

     

    I have custom gel script to select description (String) of project from oracle database and sent to user via email

    In the email content I use CDATA and html tag "Text Area" as below

     

    <textarea>

    ${v_cr_description}

    </textarea>

     

    The problem is when user use "Enter" in the description. It's not show new line in the email content.

     

    I try use REPLACE function as below when select description field.

    1.REPLACE(a.GS_CR_DESCRIPTION,chr(10),'<br>') AS GS_CR_DESCRIPTION

    2.REPLACE(a.GS_CR_DESCRIPTION,chr(10),'\n') AS GS_CR_DESCRIPTION

     

    but It's not work.

     

    Thanks,

    Peerawat K.



  • 2.  Re: New line CDATA (Gel Script)

    Posted 10-22-2015 03:50 AM

    <br> has worked in the past I believe, but earlier Clarity versions used &#xA; as well to break lines in GEL emails - see this thread ; RE: how to use newline while concating data in foreach

     

    Your problem could be that the chr(10) is not recognised in your 'description' though - so your 'replace' would just never work? Have you tried chr(13) as well?

    ( chr(10) is LF, chr(13) is CR )



  • 3.  Re: New line CDATA (Gel Script)

    Posted 10-22-2015 06:19 AM

    Thank for your reply David.

     

    My field that I select is Description (String)

    111111111111111111111

    tttttttttttttttttttttttttttttttttt

    5555555555555555555

     

    I try

    1.REPLACE(a.GS_CR_DESCRIPTION,chr(13),'&lt;br&gt;') AS GS_CR_DESCRIPTION

    Result: 111111111111111111111<br> tttttttttttttttttttttttttttttttttt<br> 5555555555555555555

     

    2.REPLACE(a.GS_CR_DESCRIPTION,chr(13),'&#xA;') AS GS_CR_DESCRIPTION

    Result: 111111111111111111111 tttttttttttttttttttttttttttttttttt 5555555555555555555

     

    Still not work



  • 4.  Re: New line CDATA (Gel Script)

    Posted 10-22-2015 06:25 AM

    I'm not a html guy, but Google-ing suggests trying using the ASCII characters &#013; &#010;

     

    Ref : HTML Display line breaks within textarea - Stack Overflow



  • 5.  Re: New line CDATA (Gel Script)

    Posted 10-22-2015 12:50 PM

    Given that a textarea tag is an input tag, you should probably start by using something else.

     

    edit: meant to paste the following.

     

    Maybe try something like this:

    <div>${v_cr_description.replaceAll("(\r\n|\n)", "&lt;/br &gt;")}</div>
    


  • 6.  Re: New line CDATA (Gel Script)

    Posted 10-28-2015 11:18 PM

    Thanks for reply Andrew_Lerner

     

    I try as you guide, It's same result



  • 7.  Re: New line CDATA (Gel Script)
    Best Answer

    Posted 10-29-2015 03:44 AM

    Really? This sscce works for me:

     

    Set the emailRecipient parameter to your own email, the testProjectInternalId parameter to the internal id of a known project with that of a project with CR/LFs in its description.

     

    <gel:script xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
        xmlns:core="jelly:core"
        xmlns:file="jelly:com.niku.union.gel.FileTagLibrary"
        xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"
        xmlns:soap="jelly:com.niku.union.gel.SOAPTagLibrary"
        xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/"
        xmlns:sql="jelly:sql" xmlns:xog="http://www.niku.com/xog" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
    
    
        <gel:parameter var="emailRecipient" />
        <gel:parameter var="testProjectInternalId" default="5000000" />
    
    
        <gel:setDataSource dbId="niku"/>
    
    
        <core:catch var="err">
        <sql:query var="rstProject">
        SELECT DESCRIPTION 
        FROM INV_INVESTMENTS II
        WHERE II.ID = ${testProjectInternalId}
        </sql:query>
    
    
        <core:set var="description" value="${rstProject.rows[0].get('DESCRIPTION')}" />
    
    
        </core:catch>
        <core:if test="${err != null}">
        ${err}
        </core:if>
        <core:set var="newDescription" value='${description.replaceAll("(\r\n|\n)", "&lt;/br &gt;")}' />
        <gel:log>${newDescription}</gel:log>
        <gel:email from="server@example.com" to="${emailRecipient}" subject="Project Carriage Return - Line Feed Test"><![CDATA[
            <html>
                <header></header>
                <body>
                    <div>${newDescription}</div>
                </body>
            </html>        
            !]]>
        </gel:email>    
    </gel:script>
    


  • 8.  Re: New line CDATA (Gel Script)

    Posted 10-29-2015 04:03 AM

    For the first I try replace in div tag. So I change replace before gel email tag.


    It's work, Thank you Andrew_Lerner.