Clarity PPM

Expand all | Collapse all

Large string attributes in a gel script

Jump to Best Answer
  • 1.  Large string attributes in a gel script

    Posted 04-20-2016 06:51 AM

    HI ,

     

    I wanted to know if there is any limitation  to display a large string attribute in a Gel notification .

    I have tried it but got some text like com.ca.clarity.jdbc.oraclebase.ddz@2c501a54  instead of text entered in the fields.

    Its a simple gel script ,I have used Gel :email tag for sending email

     

    Below is the sample notification I received :

     

    ---------------------------------

     

    Hi Supriya Chakraborty,

    Your project test has been Active.

    Scope:
    com.ca.clarity.jdbc.oraclebase.ddz@5ea75a4a

    Executive summary:
    com.ca.clarity.jdbc.oraclebase.ddz@3d18e0d2

    Key learnings:
    com.ca.clarity.jdbc.oraclebase.ddz@2c501a54

    Thank you for your contribution to the project.

    With kind regards,

      test.user

     

    --------------------------------------------------------------------------


    Here Scope ,Executive Summary and Key Learnings are the Large Strings fields.

     

    Any advise would be of great help .

     

    Regards,

    Supriya Chakraborty



  • 2.  Re: Large string attributes in a gel script
    Best Answer

    Posted 04-20-2016 07:53 AM

    LARGE STRINGs are binary on the database, if you need to treat them as strings (e.g. in GEL) then just convert them.

     

    For example (on ORACLE) I would SELECT them with a TO_CHAR conversion in my SQL statement.  (in SQLServer I would CAST them to a nvarchar(max) )



  • 3.  Re: Large string attributes in a gel script

    Posted 04-22-2016 06:26 AM

    Thanks for your inputs David.

    I was able to address the issue.