Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007
    Posts
    2

    Red face Unanswered: Help needed for the following scenario

    Hi all,
    Heres the scenario i want to make a query of
    I have four Tables namely: Bug, Test, REQ and REQ_COVER
    Bug Schema:
    BUG_ID
    TEST_REFERENCE
    BUG_DESC
    BUG_RESPONSIBLE

    TEST Schema:
    TEST_ID(Relation with BUG.TEST_REFERENCE
    TEST_NAME

    REQ Schema:
    REQ_ID
    REQ_NAME

    REQ_COVER Schema:
    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).

    Any assistance will be highly appriciated

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    please give sample output from the query
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jan 2007
    Posts
    2

    Output needed

    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)
    Last edited by khanahmer; 01-19-07 at 02:03.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •