How to query RRC Database?
4 answers
Hi Canberk,
I had a look at the XML configuration drivers that ship with the CLM 3.0.1 release, but unfortunately it doesn't look like Jazz Team Server is exposing role information for contributors or project areas. The "contributor" resource for the JFS will show pretty much everything else (ie - user ID, unique ID, email address, context ID, modified, itemID, name, archived, and a few other things that aren't exposed by default), but role information is not included.
It looks like there is a "readAccess" resource that can be used to look up if a user is a member of certain projects, but no role information can be obtained. Despite the above, I would suggest having a look at the reporting data models that ship with the release, and create an RFE against Foundation to have role based information exposed in a future release if you still need that information. Although I don't have an answer to your question on querying the DB directly, I hope this information helps.
I had a look at the XML configuration drivers that ship with the CLM 3.0.1 release, but unfortunately it doesn't look like Jazz Team Server is exposing role information for contributors or project areas. The "contributor" resource for the JFS will show pretty much everything else (ie - user ID, unique ID, email address, context ID, modified, itemID, name, archived, and a few other things that aren't exposed by default), but role information is not included.
It looks like there is a "readAccess" resource that can be used to look up if a user is a member of certain projects, but no role information can be obtained. Despite the above, I would suggest having a look at the reporting data models that ship with the release, and create an RFE against Foundation to have role based information exposed in a future release if you still need that information. Although I don't have an answer to your question on querying the DB directly, I hope this information helps.