Table name metadata

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

I'm trying to parse the JRXML file to see if there's a way to retrieve the table name of the columns / fields without using alias in the SQL string.  For example, when I have "select * from tableA, tableB where tableA.fk = tableB.id" I would like to find out where each of the field came from.  So far, I can only do it if I have "select a.id as ID_A, b.id as ID_B..." in order to figure it out.  If I have tons of columns, the SQL string will get out of hand and take too long to write.  I see JRField has a getProperties function but the API doc didn't really explain what kind of properties it will hold.

dwt.cheung's picture
Joined: Feb 11 2013 - 10:05pm
Last seen: 9 years 4 weeks ago

0 Answers:

No answers yet
Feedback