6 Replies Latest reply: Feb 9, 2012 6:25 AM by jagan mohan rao appala RSS

    Aggr query

      Hello,

       

      I have a complex query I am looking help with and would appreciated suggestions how to get it resolved. In the table below I have multiple test sets, and test cases which are attached to each test set (a test set is above a test case in the hiearchy and a test case can be in different test sets, e.g. Test case ID 1).

       

      What I want to find out is the number of Test sets that have been successfully passed (i.e. all test cases within a test set must have a status of "Passed") and also the date at which each have been completed (the date to use would be the max Test case complete date). I want to display the information in a text box and a bar chart. As per my example I have 2 test sets that are passed (Testset1 with a complete date of 21/01/12 and Testset4 with a complete date of 17/02/12).


      To get around the issue of Test case ID's being displayed in mulitple Test sets I created a new field and simply mergerd Test Set and Test case ID. I think aggr is the most appropiate method to resolve this but am having issues with this.

       

      Thanks,


      Ralph

       

       

      Test setTest case IDTest case statusTest case complete date
      Testset11Passed20/01/12
      Testset12Passed20/01/12
      Testset13Passed21/01/12
      Testset24Passed06/02/12
      Testset25Failed06/02/12
      Testset36Failed14/02/12
      Testset31Passed15/02/12
      Testset37Not completed16/02/12
      Testset42Passed17/02/12