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);
}
from a utility I have
for (IContributorHandle member : iprja.getMembers())
{
IContributor user = (IContributor) auditableClient.fetchCurrentAuditable(member, ItemProfile.createFullProfile(IContributor.ITEM_TYPE), null);
}
Comments
