RTC Project Area Database table
![]()
I know that it is not recommended to query directly on RTC database tables, but sometimes we have a need to do this. In this case, I want to query for All users within a project area. Specifically in my case, I want to be able to grab no only the users name, but also their user ID. Any advice on which tables I would join to be able to pull these details? Looks like CONTRIBUTOR_RECORD_USER_IDS and CONTRIBUTOR_RECORD get me partially what I need. Just missing the Project Area table.
|
One answer
![]()
don't see why you would need to use the database to get that info.
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.
this is an object oriented system.
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.