How do you find the database field names used by a report?


The following question came my way recently: “I would like to write a Risks report that can be output through an external report server using the TRIRIGA data tables, but I am unable to find any of the text fields in the T_TRIRISKITEM table being used by the canned TRIRIGA All Risk Items report.”

In case it is useful for others (I am sure this has come up for others when writing external reports as well), I have posted this question and will be following up with an answer. What’s challenging here is that no public-facing TRIRIGA entity relationship diagrams exist and database table names are not published in TRIRIGA client-facing documentation. Even if you can determine the table name to look at (here, T_TRIRISKITEM), how do you find the specific fields you need? Is there a trick to finding what database field or column names are used when a TRIRIGA report or query is run?

Continue reading

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s