Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Considering the above example, if you want to give end-user an ability to generate the report by filtering on the specific test case execution status, the same can be added in a `WHERE` clause as described below :

    • Syntax : <tablename>.<columnname> IN (@`filter.<tablename>.<columnname>`)

    • Example : testexecutions.tcExecutionStatusName IN (`@filter.testexecutions.tcExecutionStatusName`)

    • SQL Query

      Code Block
      languagesql
      SELECT
      DATE_FORMAT(testexecutions.tcExecutionEndTime, "%m/%d/%Y") "ExecutionDate",
      testexecutions.tcExecutionStatusName "Execution Staus", 
      COUNT(1) as "Test Case Count"
      FROM testexecutions
      WHERE testexecutions.projectID in (`@filter.project`)
      AND testexecutions.releaseID in (`@filter.release`)
      AND testexecutions.cycleID in (`@filter.cycle`)
      AND testexecutions.tcExecutionEndTime >= (`@filter.date Execution Start`)
      AND testexecutions.tcExecutionStatusName IN (`@filter.testexecutions.tcExecutionStatusName`)
      GROUP BY DATE_FORMAT(testexecutions.tcExecutionEndTime, '%m/%d/%Y'), testexecutions.tcExecutionStatusName

    • Apply the Filter

      Image RemovedImage Added


      The Filter added on a text field in a query allows you to specify multiple values in a filter option. The multiple values can be specified by ‘pressing enter after typing’ (i.e. add first value ⟶ press enter ⟶ add next value ⟶ press enter and so on).

Note : If a filter is not applied, then the report shows data of the current project and of last 1 month.

...