Unanswered: Help needed for the following scenario
Heres the scenario i want to make a query of
I have four Tables namely: Bug, Test, REQ and REQ_COVER
TEST_ID(Relation with BUG.TEST_REFERENCE
RC_REQ_ID (Relation with REQ.REQ_ID)
RC_TEST_ID (Relation with TEST.TEST_ID)
Now I need to have following data:
Number of BUG_ID by BG_RESPONSIBLE with Number of Distinct TEST_ID and Number of Distinct REQ_ID.
i.e. how many BUG_ID (number of bugs )are assigned to BG_RESPONSIBLE (list of users) and that BUG_ID is assoiciated with how many TEST_ID(TestCases) and those TEST_IDs are associated to how many REQ_ID(Requirements).
BG_RESPONSIBLE || Count(BUG_ID against BG_RESPONSIBLE) || Count(TEST_ID against BUG_ID for BG_RESPONSIBLE) || Count(REQ_ID against TEST_ID against BUG_ID for BG_RESPONSIBLE)
Ineed the records in above table Columns are separated by || signs.
Actually this is custom Bug tracker. And i need to know the total number of Bugs , total number of test cases they belongs to and the total number of requirements associated with those test cases.. all against each developer (BG_RESPONSIBLE)