RTC Project Area Database table
One answer
from a utility I have
for (IContributorHandle member : iprja.getMembers())
{
IContributor user = (IContributor) auditableClient.fetchCurrentAuditable(member, ItemProfile.createFullProfile(IContributor.ITEM_TYPE), null);
}
Comments
I appreciate the feedback. I guess the reason I am looking for the db table is because I am more comfortable with SQL. If I am being honest, I am not sure how to use the information provided above.
I can affirm what Sam has said. There are many things going on in the database that are better accessed through tooling other than SQL [ I'm a competent DB2 admin ]. If you want to do something one-off, RTC eclipse can export information about a given project into a collection of (local) html pages.
Alternately for automation, a very small java program can do quite a lot when it comes to ferreting out user information. This excellent article on examining repository contributors and roles is a good place to start.
this is an object oriented system.
to reduce memory, the objects are 'handles' (persistent pointers) to the data.
you use one of the
auditableClient.fetchCurrentAuditable()
methods to get back some or all of the data elements of an object.
(if u only need the name, why get everything?)..
a contributor 'object' has a lot of data elements.. name, userid, email address, etc,etc,etc...
if you look in the javadoc you will be able to look at the methods for retrieving the data from the object (no direct access).
how the data is stored in the database is not disclosed, and is volatile.. the methods are not volatile.