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?