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?
Try using PdmString(chg.z_xyz) , Jaspers' JDBC driver doesn't know how to interpred UUIDs.
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
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.