AQL to search for Build Status

Build has following properties.

"statuses" : [ {
    "status" : "Staged",
    "comment" : "Tested on all target platforms.",
    "repository" : "maven-demo-local",
    "timestamp" : "2016-01-21T16:08:38.355-0800",
    "user" : "admin",
    "ciUser" : "admin",
    "timestampDate" : 1453421318355
  } ]

Enhance AQL to add search feature for builds by there Status. The search facility is provided only at build level to search artifacts, dependencies etc. We need promotion subdomain of build with fields status, repository, user, timestamp etc.

All this information we can find in BUILD_PROMOTION table.

Objective Use Case: Search for the builds which has a specific status, by searching for the builds we can get information about latest build with "release" status. Which we can add to buildDependencies of other build for build promotion purpose.