CA Service Management

  • 1.  SREL field in Jasper Reporting

    Posted May 19, 2017 06:08 AM

    Hi Team,

     

    I have few custom fields on Change Order which are SREL to Contacts and some other custom tables. How can I use those fields in Jasper Reports as when I am trying to add those fields in Jasper query its showing error:-

     

    In the source, I can see the classes are like this:-

    <field name="chg.z_xxxx" class="byte[]"/>
    <field name="chg.z_xxxx" class="byte[]"/>

     

     

    How can I get rid of this issue?

     

    Thanks

    Ishani



  • 2.  Re: SREL field in Jasper Reporting

    Posted May 19, 2017 07:14 AM

    Try using PdmString(chg.z_xyz) , Jaspers' JDBC driver doesn't know how to interpred UUIDs.



  • 3.  Re: SREL field in Jasper Reporting
    Best Answer

    Broadcom Employee
    Posted May 19, 2017 04:42 PM

    Ishani/Cristi,

     

    Are you trying to really display the "id" of the srel field in question here?  Or another attribute of that srel field.


    Example:    chg.ztest  -->   SREL ->  ztest.id

      and ztest table has,   name, description, etc., etc.,

     

    So, if you really want to display the id itself, then PdmString would help.

     

    But if you are looking to display an extended attribute like,   ztest.name,  then you need to create an attribute alias like the one being discussed here: https://communities.ca.com/message/241980735?commentID=241980735&et=watches.email.thread#comment-241980735 

     

    Hope this helps

    _R



  • 4.  Re: SREL field in Jasper Reporting

    Broadcom Employee
    Posted Nov 06, 2017 10:14 AM

    Ishani..........

     

    Did the information provided by Raghu address your issue with SRELs within Jasper reports?

     

    If so, please mark Raghu's answer as correct to close out this thread.