Skip to content

Record Reference

3 min read

Use this page to check, before you ask, whether Oracle knows about the thing you want. You never need to name any of this in a question.


RecordsAsk things like
Test casesHigh priority test cases in the Checkout folder
RequirementsApproved requirements with no test coverage
TasksTasks that have not been started
Requirements and tasksAll the requirements and tasks
DefectsOpen critical or blocker defects
ReleasesReleases that are risky
Test runsTest runs still in progress that are healthy
Release executionsRelease executions that have stalled
Test cases in runsTest cases in the Smoke run
LabelsLabels nobody uses
Shared stepsShared steps in this project only
ParametersWorkspace level parameters
Custom fieldsWhich custom fields are required

As well as each record’s own fields, Oracle knows your custom fields, folders, labels, releases and team members. See What Oracle Is Shown.


These let a question reach beyond the record it is about. Oracle checks the linked records for each one, which is how Test cases that have an open defect against them works.

LinkAsk
Never executedTest cases that have never been executed
Not in any runTest cases that have never been added to any run
Executed recentlyTest cases not run in the last 10 days
Last result was”…that last failed”
In a run that still existsleaves out test cases whose run was deleted
LinkAsk
Has an open defectTest cases that have an open defect against them
Has a linked defectany defect, open or closed
OpenOpen defects
Linked to a test caseDefects with no test case linked
LinkAsk
Has test coverageRequirements with no test coverage
Verified by a passing testRequirements that have tests but nothing passing

The difference matters: coverage counts the link, verification counts the result.

Section titled “Requirement links on a test case vs. in a run”

A test case shows the requirements it is traced to now. A test case in a run shows the requirements it was traced to when it was added to that run. The two can differ if the tracing changed later.

This decides which question to ask, and the wrong one gives a wrong answer rather than an error:

  • Failures in release 4.2 per requirement looks at the test cases inside that release’s runs, which is what you want: those results belong to that release.
  • Asking the same thing about repository test cases looks at each test case’s most recent result in any run. A test case that failed in an unrelated smoke run but passed in the release you care about would be reported as a failure of that release.
LinkAsk
In a releaseTest cases that are in no release
Linked to a releasedefects raised against one
Linked to a run or executioneither kind
Linked to a standalone test runruns outside a release
Linked to a release executiononly executions inside a release
Has unassigned work not yet startedTest runs signed off with unassigned work left in them
LinkAsk
A CI pipeline has run itAutomated test cases no pipeline has ever run
FlakyFlaky test cases

Test cases a pipeline runs that are not marked automated uses the same link the other way round: a CI pipeline really runs the test case, but it isn’t marked as automated.


You can ask about labels, shared steps, parameters and custom fields like anything else, which makes it easy to tidy up your project’s setup:

  • Labels nobody uses
  • Shared steps nobody uses
  • Which custom fields are required
  • Custom fields shown on defects
  • Custom fields that are not set up in this project

Each of these records knows how often it is used, so “nobody uses” is a real condition, not an estimate.


Releases, test runs and release executions also have figures that aren’t stored on the record: the readiness verdict, the reason behind it, the readiness gates that failed, and the execution figures. Oracle calculates them when you ask.

They have their own page: Readiness Questions.