This flow demonstrates how to get a list of features whose associated automated test runs failed in the last 24 hours.

The list of associated tests includes:

• Automated tests directly associated with the feature.

• Automated tests associated with the feature's children (stories and defects).

Areas: Backlog, Test runs 

In this topic:

Entity relationship diagram

We need to access the following entities for this flow, and understand the relationships between these entities.

Back to top

Flow

Let's create the REST API call step-by-step.

1. We can start by listing all the features in the workspace.

   GET .../api/shared_spaces/<space_id>/workspaces/<workspace_id>/features

2. Let's build our query_clause. We are only interested in the features that are associated with tests whose runs failed and had run in the last 24 hours.

   This query has two sets of criteria. We want to list any failed tests that are related to the feature directly, and any failed tests that are related to the feature's children. We will use the || to indicate the OR condition, so that any run that matches both cases is listed.

   Additionally, this is a nested query. We will be querying for certain runs of the tests associated with the features in our workspace.

   Let's start from the outermost clauses of the query clause that checks for the runs of tests related to the feature's children. We will fill in the <inner_query> soon.

   This part of the query clause shows that we are looking for the user stories and defects (children) of the feature that have tests whose last runs match the inner_query clause.

   GET .../api/shared_spaces/<space_id>/workspaces/<workspace_id>/features?query="children EQ {test EQ {<inner_query>}}"

3. Now that we see how to look for the last runs of tests related to our features' children, we can specify which last runs we want to get by filling in the inner query. We want to access only those runs with a failed status.

   This is an example of how to work with list nodes. One of the available lists for automated tests in ALM Octane is run_status, which is a list_node. We want to compare the last automated run's status with the run_status list's value failed.

   GET .../api/shared_spaces/<space_id>/workspaces/<workspace_id>/features?query="children EQ {test EQ {last_runs EQ {status EQ {logical_name EQ ^list_node.run_status.failed^}"

4. Now we see features in the workspace that are associated with failed runs for automated tests. But we want to see only those features associated with failed runs created in the last 24 hours.

   This is an example of how to work with creation time fields. Note the format of the date. Assuming today is July 20, 2016 at 6:45, we would query for runs after July 18, 2016.

   GET .../api/shared_spaces/<space_id>/workspaces/<workspace_id>/features?query="children EQ {test EQ {last_runs EQ {status EQ {logical_name EQ ^list_node.run_status.failed^};creation_time GT ^2016-07-18T06:45:48Z^}}}"

5. Now we have exactly what we need to list the features whose children's test runs failed. We can add the || operator to add the second part of our query, which looks for features whose test runs failed (not the children's): 

   GET .../api/shared_spaces/<space_id>/workspaces/<workspace_id>/features?query="children EQ {test EQ {last_runs EQ {status EQ {logical_name EQ ^list_node.run_status.failed^};creation_time GT ^2016-07-18T06:45:48Z^}}}||test EQ {last_runs EQ {status EQ {logical_name EQ ^list_node.run_status.failed^};creation_time GT ^2016-07-18T06:45:48Z^}}"

The complete REST API call for this flow is: 

Back to top

Javascript example

/**
 * Flow:  How to find features in this release with failing tests (within the last 24 hours)
 * @param requestor
 */
function getFeaturesInReleaseWithFailingTests(requestor) {
  var last24HoursDateString = getLast24HoursDateString();

  requestor.get('/features?query="children EQ {test EQ {last_runs EQ {status  EQ {logical_name EQ ^list_node.run_status.failed^};' +
    'creation_time GT ^' + last24HoursDateString + '^}}}' +
    '||' +
    'test EQ {last_runs EQ {status  EQ {logical_name EQ ^list_node.run_status.failed^};' +
    'creation_time GT ^' + last24HoursDateString + '^}}"', function(error, message, features) {
    console.info(features);
  });
}

exports.getFeaturesInReleaseWithFailingTests = getFeaturesInReleaseWithFailingTests;

function getLast24HoursDateString() {
  var date = new Date();
  date.setDate(date.getDate() - 1);

  return date.toISOString();
}

Back to top

See also:

• How to work with the REST API
• Common flows and ER diagrams