Jump to content
Changes to the Jaspersoft community edition download ×

Table name metadata


dwt.cheung

Recommended Posts

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.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...