Available Custom Reports¶

How to use this page

SpiraPlan has a number of database views available for creating custom reports using ESQL queries. Below, each available table is listed with all of their exact field names.

Artifact Associations¶

ARTIFACT_LINK_TYPE_ID
SOURCE_ARTIFACT_ID
SOURCE_ARTIFACT_TYPE_ID
DEST_ARTIFACT_ID
DEST_ARTIFACT_TYPE_ID
CREATOR_ID
CREATION_DATE
COMMENT
SOURCE_ARTIFACT_TYPE_NAME
DEST_ARTIFACT_TYPE_NAME
CREATOR_NAME
ARTIFACT_LINK_TYPE_NAME

Artifact Attachments¶

ARTIFACT_TYPE_ID
ARTIFACT_ID
ARTIFACT_TYPE_NAME
ARTIFACT_NAME
COMMENT
CREATOR_ID
CREATION_DATE
CREATOR_NAME
ATTACHMENT_ID
PROJECT_ID
ARTIFACT_STATUS_NAME

Artifact Types¶

ARTIFACT_TYPE_ID
NAME
PREFIX

Attachments¶

ATTACHMENT_ID
ATTACHMENT_TYPE_ID
AUTHOR_ID
EDITOR_ID
FILENAME
DESCRIPTION
UPLOAD_DATE
EDITED_DATE
SIZE
CURRENT_VERSION
PROJECT_ID
PROJECT_ATTACHMENT_FOLDER_ID
CONCURRENCY_DATE
DOCUMENT_STATUS_ID
DOCUMENT_TYPE_ID
DOCUMENT_STATUS_NAME
DOCUMENT_TYPE_NAME
TAGS
CUST_01...
CUST_99
IS_KEY_DOCUMENT
DOCUMENT_STATUS_IS_OPEN_STATUS
PROJECT_IS_ACTIVE
PROJECT_GROUP_ID
PROJECT_NAME
AUTHOR_NAME
EDITOR_NAME
ATTACHMENT_TYPE_NAME
PROJECT_ATTACHMENT_FOLDER_NAME

Attachment Folders¶

PROJECT_ATTACHMENT_FOLDER_ID
PROJECT_ID
PARENT_PROJECT_ATTACHMENT_FOLDER_ID
NAME
PROJECT_NAME
PROJECT_GROUP_ID

Automation Hosts¶

AUTOMATION_HOST_ID
PROJECT_ID
NAME
DESCRIPTION
TOKEN
LAST_UPDATE_DATE
IS_DELETED
CUST_01...
CUST_99
PROJECT_NAME
PROJECT_GROUP_ID
IS_ACTIVE
IS_ATTACHMENTS
CONCURRENCY_DATE
LAST_CONTACT_DATE

Baselines¶

See this KB for some examples of using this custom report table.

BASELINE_ID
PROJECT_ID
CREATOR_USER_ID
CHANGESET_ID
RELEASE_ID
NAME
DESCRIPTION
IS_ACTIVE
IS_APPROVED
IS_DELETED
CREATION_DATE
LAST_UPDATE_DATE
CONCURRENCY_DATE
BASELINE_CREATOR_LOGIN
CHANGESET_CREATOR_ID
CHANGESET_CREATOR_LOGIN
ARTIFACT_TYPE_ID
ARTIFACT_TYPE_NAME
CHANGESET_DATE
CHANGESET_TYPE_ID
CHANGESET_TYPE_NAME

Builds¶

BUILD_ID
BUILD_STATUS_ID
RELEASE_ID
PROJECT_ID
NAME
DESCRIPTION

Comments¶

ARTIFACT_ID
CREATOR_ID
COMMENT_TEXT
CREATION_DATE
CREATOR_NAME
ARTIFACT_TYPE_NAME

Components¶

COMPONENT_ID
PROJECT_ID
NAME
IS_DELETED
IS_ACTIVE
PROJECT_NAME
PROJECT_GROUP_ID

Custom Lists¶

CUSTOM_PROPERTY_LIST_ID
PROJECT_ID
NAME
IS_ACTIVE
IS_SORTED_ON_VALUE
PROJECT_NAME
PROJECT_IS_ACTIVE
PROJECT_TEMPLATE_ID

Custom List Values¶

CUSTOM_PROPERTY_VALUE_ID
CUSTOM_PROPERTY_LIST_ID
NAME
PROJECT_ID
CUSTOM_PROPERTY_LIST_NAME
CUSTOM_PROPERTY_LIST_IS_ACTIVE
PROJECT_NAME
PROJECT_IS_ACTIVE
IS_ACTIVE
IS_DELETED
DEPENDENT_CUSTOM_PROPERTY_LIST_ID
PARENT_CUSTOM_PROPERTY_VALUE_ID

Custom Property Definitions¶

CUSTOM_PROPERTY_ID
CUSTOM_PROPERTY_TYPE_ID
PROJECT_ID
ARTIFACT_TYPE_ID
NAME
PROPERTY_NUMBER
IS_DELETED
CUSTOM_PROPERTY_LIST_ID
LEGACY_NAME
PROJECT_NAME
PROJECT_IS_ACTIVE
ARTIFACT_TYPE_NAME
CUSTOM_PROPERTY_TYPE_NAME
CUSTOM_PROPERTY_LIST_NAME
DEPENDENT_CUSTOM_PROPERTY_ID
PROJECT_TEMPLATE_ID

Document Statuses¶

DOCUMENT_STATUS_ID
PROJECT_TEMPLATE_ID
NAME
POSITION
IS_ACTIVE
IS_OPEN_STATUS
IS_DEFAULT
PROJECT_TEMPLATE_NAME

Document Types¶

DOCUMENT_TYPE_ID
PROJECT_TEMPLATE_ID
DOCUMENT_WORKFLOW_ID
NAME
DESCRIPTION
IS_ACTIVE
IS_DEFAULT
PROJECT_TEMPLATE_NAME

Events¶

EVENT_TYPE_ID
EVENT_TIME_UTC
EVENT_TIME
EVENT_CATEGORY
EVENT_SEQUENCE
EVENT_OCCURRENCE
EVENT_CODE
EVENT_DETAIL_CODE
MESSAGE
APPLICATION_PATH
APPLICATION_VIRTUAL_PATH
MACHINE_NAME
REQUEST_URL
EXCEPTION_TYPE
DETAILS
EVENT_TYPE_NAME

History Change-Sets¶

CHANGESET_ID
USER_ID
ARTIFACT_TYPE_ID
ARTIFACT_ID
CHANGE_DATE
CHANGETYPE_ID
PROJECT_ID
REVERT_ID
ARTIFACT_DESC
CHANGETYPE_NAME
USER_NAME
ARTIFACT_TYPE_NAME
SIGNATURE_HASH
MEANING

History Details¶

FIELD_NAME
OLD_VALUE
FIELD_CAPTION
NEW_VALUE
OLD_VALUE_INT
OLD_VALUE_DATE
NEW_VALUE_INT
NEW_VALUE_DATE
CHANGESET_ID
FIELD_ID
CUSTOM_PROPERTY_ID
ARTIFACT_ID
USER_ID
ARTIFACT_TYPE_ID
CHANGE_DATE
CHANGER_NAME
CHANGE_NAME
CHANGETYPE_ID

Incidents¶

INCIDENT_ID
PROJECT_ID
PRIORITY_ID
SEVERITY_ID
INCIDENT_STATUS_ID
INCIDENT_TYPE_ID
OPENER_ID
OWNER_ID
DESCRIPTION
CREATION_DATE
CLOSED_DATE
LAST_UPDATE_DATE
DETECTED_RELEASE_ID
RESOLVED_RELEASE_ID
START_DATE
COMPLETION_PERCENT
ESTIMATED_EFFORT
ACTUAL_EFFORT
REMAINING_EFFORT
PROJECTED_EFFORT
IS_DELETED
VERIFIED_RELEASE_ID
PRIORITY_NAME
PRIORITY_COLOR
SEVERITY_NAME
SEVERITY_COLOR
INCIDENT_STATUS_NAME
INCIDENT_TYPE_NAME
OPENER_NAME
OWNER_NAME
DETECTED_RELEASE_VERSION_NUMBER
RESOLVED_RELEASE_VERSION_NUMBER
VERIFIED_RELEASE_VERSION_NUMBER
PROJECT_GROUP_ID
PROJECT_NAME
CUST_01...
CUST_99
NAME
IS_ATTACHMENTS
COMPONENT_IDS
INCIDENT_STATUS_IS_OPEN_STATUS
PROJECT_IS_ACTIVE
INCIDENT_TYPE_IS_ISSUE
INCIDENT_TYPE_IS_RISK
CONCURRENCY_DATE
RANK
END_DATE
DETECTED_BUILD_ID
RESOLVED_BUILD_ID
DETECTED_BUILD_NAME
RESOLVED_BUILD_NAME

Incident Priorities¶

PRIORITY_ID
PROJECT_TEMPLATE_ID
NAME
COLOR
IS_ACTIVE
SCORE
PROJECT_TEMPLATE_NAME

Incident Severities¶

SEVERITY_ID
PROJECT_TEMPLATE_ID
NAME
COLOR
IS_ACTIVE
SCORE
PROJECT_TEMPLATE_NAME

Incident Statuses¶

INCIDENT_STATUS_ID
PROJECT_TEMPLATE_ID
NAME
IS_ACTIVE
IS_OPEN_STATUS
IS_DEFAULT
PROJECT_TEMPLATE_NAME

Incident Types¶

INCIDENT_TYPE_ID
PROJECT_TEMPLATE_ID
WORKFLOW_ID
NAME
IS_ACTIVE
IS_ISSUE
IS_DEFAULT
PROJECT_TEMPLATE_NAME

Portfolios¶

PORTFOLIO_ID
NAME
DESCRIPTION
IS_ACTIVE
START_DATE
END_DATE
PERCENT_COMPLETE
REQUIREMENT_COUNT

Projects (Products)¶

PROJECT_ID
PROJECT_GROUP_ID
NAME
DESCRIPTION
CREATION_DATE
WEBSITE
WORKING_HOURS
WORKING_DAYS
NON_WORKING_HOURS
TASK_DEFAULT_EFFORT
PROJECT_GROUP_NAME
PROJECT_GROUP_DESCRIPTION
IS_ACTIVE
IS_TIME_TRACK_INCIDENTS
IS_TIME_TRACK_TASKS
IS_EFFORT_INCIDENTS
IS_EFFORT_TASKS
IS_TASKS_AUTO_CREATE
REQ_DEFAULT_ESTIMATE
REQ_POINT_EFFORT
IS_REQ_STATUS_BY_TASKS
IS_REQ_STATUS_BY_TEST_CASES
IS_EFFORT_TEST_CASES
IS_REQ_STATUS_AUTO_PLANNED
PROJECT_TEMPLATE_ID
START_DATE
END_DATE
PERCENT_COMPLETE
REQUIREMENT_COUNT

Project Groups (Programs)¶

PROJECT_GROUP_ID
NAME
DESCRIPTION
WEBSITE
PROJECT_TEMPLATE_ID
IS_ACTIVE
IS_DEFAULT
PERCENT_COMPLETE
START_DATE
END_DATE
PORTFOLIO_ID
REQUIREMENT_COUNT

Project (Product) Membership¶

PROJECT_ID
USER_ID
PROJECT_ROLE_ID
PROJECT_NAME
PROJECT_ROLE_NAME
USER_NAME
FIRST_NAME
LAST_NAME
DEPARTMENT
IS_SYSTEM_ADMIN

Project Release Resources¶

PROJECT_ID
USER_ID
RELEASE_ID
INCIDENT_EFFORT
TASK_EFFORT

Releases¶

RELEASE_ID
PROJECT_ID
CREATOR_ID
NAME
VERSION_NUMBER
DESCRIPTION
INDENT_LEVEL
CREATION_DATE
LAST_UPDATE_DATE
START_DATE
END_DATE
RESOURCE_COUNT
DAYS_NON_WORKING
PLANNED_EFFORT
AVAILABLE_EFFORT
COUNT_BLOCKED
COUNT_CAUTION
COUNT_FAILED
COUNT_NOT_APPLICABLE
COUNT_NOT_RUN
COUNT_PASSED
TASK_COUNT
TASK_PERCENT_ON_TIME
TASK_PERCENT_LATE_FINISH
TASK_PERCENT_NOT_START
TASK_PERCENT_LATE_START
TASK_ESTIMATED_EFFORT
TASK_ACTUAL_EFFORT
TASK_PROJECTED_EFFORT
TASK_REMAINING_EFFORT
IS_DELETED
CREATOR_NAME
FULL_NAME
PROJECT_NAME
PROJECT_GROUP_ID
CUST_01...
CUST_99
RELEASE_TYPE_ID
RELEASE_STATUS_ID
OWNER_ID
IS_SUMMARY
IS_ATTACHMENTS
OWNER_NAME
RELEASE_TYPE_NAME
RELEASE_STATUS_NAME
CONCURRENCY_DATE
MILESTONE_ID
PERCENT_COMPLETE
PLANNED_POINTS
REQUIREMENT_POINTS
REQUIREMENT_COUNT

Release Test Case Mapping¶

RELEASE_ID
TEST_CASE_ID
RELEASE_NAME
RELEASE_VERSION_NUMBER
TEST_CASE_NAME
PROJECT_ID
PROJECT_NAME
RELEASE_TYPE_ID
RELEASE_TYPE_NAME
EXECUTION_STATUS_ID
EXECUTION_DATE
ACTUAL_DURATION

Requirements¶

REQUIREMENT_ID
AUTHOR_ID
OWNER_ID
RELEASE_ID
PROJECT_ID
IMPORTANCE_ID
NAME
CREATION_DATE
INDENT_LEVEL
DESCRIPTION
LAST_UPDATE_DATE
COVERAGE_COUNT_TOTAL
COVERAGE_COUNT_PASSED
COVERAGE_COUNT_FAILED
COVERAGE_COUNT_CAUTION
COVERAGE_COUNT_BLOCKED
TASK_COUNT
TASK_ESTIMATED_EFFORT
TASK_ACTUAL_EFFORT
TASK_PROJECTED_EFFORT
TASK_REMAINING_EFFORT
TASK_PERCENT_ON_TIME
TASK_PERCENT_LATE_FINISH
TASK_PERCENT_NOT_START
TASK_PERCENT_LATE_START
IS_DELETED
AUTHOR_NAME
OWNER_NAME
IMPORTANCE_NAME
RELEASE_VERSION_NUMBER
PROJECT_NAME
PROJECT_GROUP_ID
CUST_01...
CUST_99
REQUIREMENT_TYPE_ID
REQUIREMENT_STATUS_ID
COMPONENT_ID
IS_SUMMARY
IS_ATTACHMENTS
CONCURRENCY_DATE
REQUIREMENT_STATUS_NAME
REQUIREMENT_TYPE_NAME
COMPONENT_NAME
ESTIMATE_POINTS
ESTIMATED_EFFORT
RANK
THEME_ID
GOAL_ID
START_DATE
END_DATE
PERCENT_COMPLETE

Requirement Incidents¶

INCIDENT_ID
DETECTED_RELEASE_ID
IS_OPEN_STATUS

Requirement Steps¶

REQUIREMENT_ID
POSITION
DESCRIPTION
IS_DELETED
CREATION_DATE
LAST_UPDATE_DATE
CONCURRENCY_DATE
REQUIREMENT_NAME
REQUIREMENT_LAST_UPDATE_DATE
PROJECT_IS_ACTIVE
PROJECT_PROJECT_GROUP_ID
PROJECT_NAME

Requirement Test Case Coverage¶

REQUIREMENT_ID
TEST_CASE_ID
REQUIREMENT_NAME
TEST_CASE_NAME
PROJECT_ID
PROJECT_NAME

Requirement Test Step Coverage¶

TEST_STEP_ID
REQUIREMENT_NAME
POSITION
STEP_DESCRIPTION
EXPECTED_RESULT
SAMPLE_DATA
PROJECT_ID
PROJECT_NAME

Requirement Types¶

REQUIREMENT_TYPE_ID
REQUIREMENT_WORKFLOW_ID
PROJECT_TEMPLATE_ID
NAME
ICON
IS_ACTIVE
IS_STEPS
IS_DEFAULT
IS_KEY_TYPE
PROJECT_TEMPLATE_NAME

Risks¶

RISK_ID
RISK_IMPACT_ID
RISK_STATUS_ID
RISK_PROBABILITY_ID
RISK_TYPE_ID
PROJECT_ID
CREATOR_ID
OWNER_ID
PROJECT_GROUP_ID
RELEASE_ID
COMPONENT_ID
NAME
DESCRIPTION
IS_DELETED
CREATION_DATE
LAST_UPDATE_DATE
CONCURRENCY_DATE
REVIEW_DATE
GOAL_ID
CLOSED_DATE
IS_ATTACHMENTS
RISK_PROBABILITY_NAME
RISK_PROBABILITY_COLOR
RISK_PROBABILITY_SCORE
RISK_IMPACT_NAME
RISK_IMPACT_COLOR
RISK_IMPACT_SCORE
RISK_EXPOSURE
RISK_STATUS_NAME
RISK_STATUS_IS_OPEN
RISK_TYPE_NAME
CREATOR_NAME
OWNER_NAME
RELEASE_VERSION_NUMBER
RELEASE_NAME
COMPONENT_NAME
GOAL_NAME
PROJECT_IS_ACTIVE
PROJECT_PROJECT_GROUP_ID
PROJECT_NAME
CUST_01...
CUST_99

Risk Impacts¶

RISK_IMPACT_ID
PROJECT_TEMPLATE_ID
NAME
COLOR
IS_ACTIVE
POSITION
SCORE
PROJECT_TEMPLATE_NAME

Risk Mitigations¶

RISK_ID
POSITION
DESCRIPTION
IS_DELETED
CREATION_DATE
LAST_UPDATE_DATE
CONCURRENCY_DATE
IS_ACTIVE
REVIEW_DATE
RISK_NAME
RISK_REVIEW_DATE
PROJECT_IS_ACTIVE
PROJECT_PROJECT_GROUP_ID
PROJECT_NAME

Risk Probabilities¶

RISK_PROBABILITY_ID
PROJECT_TEMPLATE_ID
NAME
COLOR
IS_ACTIVE
POSITION
SCORE
PROJECT_TEMPLATE_NAME

Risk Statuses¶

RISK_STATUS_ID
NAME
IS_ACTIVE
IS_DEFAULT
IS_OPEN
POSITION
PROJECT_TEMPLATE_ID
PROJECT_TEMPLATE_NAME

Risk Types¶

RISK_TYPE_ID
NAME
IS_ACTIVE
IS_DEFAULT
PROJECT_TEMPLATE_ID
RISK_WORKFLOW_ID
PROJECT_TEMPLATE_NAME

Tasks¶

TASK_ID
TASK_STATUS_ID
PROJECT_ID
REQUIREMENT_ID
RELEASE_ID
CREATOR_ID
OWNER_ID
TASK_PRIORITY_ID
NAME
DESCRIPTION
CREATION_DATE
LAST_UPDATE_DATE
START_DATE
END_DATE
COMPLETION_PERCENT
ESTIMATED_EFFORT
ACTUAL_EFFORT
PROJECTED_EFFORT
REMAINING_EFFORT
IS_DELETED
TASK_STATUS_NAME
OWNER_NAME
CREATOR_NAME
TASK_PRIORITY_NAME
PROJECT_NAME
PROJECT_GROUP_ID
RELEASE_VERSION_NUMBER
CUST_01...
CUST_99
TASK_TYPE_ID
TASK_FOLDER_ID
IS_ATTACHMENTS
CONCURRENCY_DATE
REQUIREMENT_NAME
TASK_TYPE_NAME
COMPONENT_ID
COMPONENT_NAME
RISK_ID

Task Priorities¶

TASK_PRIORITY_ID
PROJECT_TEMPLATE_ID
NAME
IS_ACTIVE
COLOR
SCORE
PROJECT_TEMPLATE_NAME

Task Types¶

TASK_TYPE_ID
PROJECT_TEMPLATE_ID
TASK_WORKFLOW_ID
NAME
POSITION
IS_ACTIVE
IS_DEFAULT
IS_PULL_REQUEST PROJECT_TEMPLATE_NAME

Test Cases¶

TEST_CASE_ID
EXECUTION_STATUS_ID
TEST_CASE_PRIORITY_ID
PROJECT_ID
AUTHOR_ID
NAME
OWNER_ID
DESCRIPTION
EXECUTION_DATE
CREATION_DATE
LAST_UPDATE_DATE
AUTOMATION_ENGINE_ID
AUTOMATION_ATTACHMENT_ID
ESTIMATED_DURATION
IS_DELETED
EXECUTION_STATUS_NAME
TEST_CASE_PRIORITY_NAME
AUTHOR_NAME
OWNER_NAME
AUTOMATION_ENGINE_NAME
PROJECT_NAME
PROJECT_GROUP_ID
CUST_01...
CUST_99
CONCURRENCY_DATE
TEST_CASE_STATUS_ID
TEST_CASE_TYPE_ID
TEST_CASE_FOLDER_ID
IS_ATTACHMENTS
IS_TEST_STEPS
ACTUAL_DURATION
TEST_CASE_STATUS_NAME
TEST_CASE_TYPE_NAME
COMPONENT_IDS
IS_SUSPECT

Test Case Folders¶

TEST_CASE_FOLDER_ID
PARENT_TEST_CASE_FOLDER_ID
PROJECT_ID
NAME
DESCRIPTION
EXECUTION_DATE
LAST_UPDATE_DATE
ESTIMATED_DURATION
ACTUAL_DURATION
COUNT_PASSED
COUNT_FAILED
COUNT_BLOCKED
COUNT_CAUTION
COUNT_NOT_RUN
COUNT_NOT_APPLICABLE
PROJECT_NAME
PROJECT_GROUP_ID

Test Case Incidents¶

INCIDENT_ID
DETECTED_RELEASE_ID
RESOLVED_RELEASE_ID
VERIFIED_RELEASE_ID
IS_OPEN_STATUS

Test Case Types¶

TEST_CASE_TYPE_ID
PROJECT_TEMPLATE_ID
TEST_CASE_WORKFLOW_ID
NAME
IS_ACTIVE
POSITION
IS_DEFAULT
IS_EXPLORATORY
IS_BDD
PROJECT_TEMPLATE_NAME

Test Configuration Entries¶

TEST_CONFIGURATION_SET_ID
POSITION
TEST_CONFIGURATION_SET_NAME
IS_TEST_CONFIGURATION_SET_ACTIVE
CUSTOM_PROPERTY_VALUE_ID
TEST_CASE_PARAMETER_NAME
TEST_CASE_PARAMETER_VALUE
PROJECT_NAME
PROJECT_GROUP_ID

Test Configuration Sets¶

TEST_CONFIGURATION_SET_ID
PROJECT_ID
NAME
DESCRIPTION
IS_ACTIVE
IS_DELETED
CREATION_DATE
LAST_UPDATED_DATE
CONCURRENCY_DATE
PROJECT_NAME
PROJECT_GROUP_ID

Test Runs¶

TEST_RUN_ID
TEST_CASE_ID
NAME
DESCRIPTION
ESTIMATED_DURATION
ACTUAL_DURATION
TEST_RUN_TYPE_ID
TESTER_ID
EXECUTION_STATUS_ID
START_DATE
END_DATE
RUNNER_NAME
RUNNER_TEST_NAME
RUNNER_ASSERT_COUNT
RUNNER_MESSAGE
RUNNER_STACK_TRACE
EXECUTION_STATUS_NAME
TESTER_NAME
TEST_RUNS_PENDING_ID
RELEASE_ID
TEST_SET_ID
TEST_SET_TEST_CASE_ID
RELEASE_NAME
RELEASE_VERSION_NUMBER
TEST_SET_NAME
TEST_RUN_TYPE_NAME
AUTOMATION_HOST_ID
AUTOMATION_HOST_NAME
AUTOMATION_ENGINE_ID
BUILD_ID
BUILD_NAME
TEST_RUN_FORMAT_ID
PROJECT_NAME
PROJECT_GROUP_ID
CUST_01...
CUST_99
IS_ATTACHMENTS
IS_DELETED
CONCURRENCY_DATE
PROJECT_ID
CHANGESET_ID
TEST_CONFIGURATION_ID

Test Run Incidents¶

INCIDENT_ID
DETECTED_RELEASE_ID
RESOLVED_RELEASE_ID
VERIFIED_RELEASE_ID
IS_OPEN_STATUS

Test Run Steps¶

TEST_RUN_STEP_ID
EXECUTION_STATUS_ID
TEST_CASE_ID
TEST_STEP_ID
TEST_RUN_ID
DESCRIPTION
POSITION
EXPECTED_RESULT
SAMPLE_DATA
ACTUAL_RESULT
EXECUTION_STATUS_NAME
TEST_CASE_NAME
PROJECT_ID
PROJECT_NAME
PROJECT_GROUP_ID
START_DATE
END_DATE
ACTUAL_DURATION

Test Sets¶

TEST_SET_ID
PROJECT_ID
RELEASE_ID
TEST_SET_STATUS_ID
CREATOR_ID
OWNER_ID
AUTOMATION_HOST_ID
TEST_RUN_TYPE_ID
RECURRENCE_ID
NAME
DESCRIPTION
CREATION_DATE
PLANNED_DATE
LAST_UPDATE_DATE
IS_DELETED
CONCURRENCY_DATE
RELEASE_VERSION_NUMBER
PROJECT_NAME
TEST_CASE_COUNT
TEST_SET_STATUS_NAME
CREATOR_NAME
OWNER_NAME
PROJECT_ACTIVE_YN
AUTOMATION_HOST_NAME
TEST_RUN_TYPE_NAME
RECURRENCE_NAME
PROJECT_GROUP_ID
CUST_01...
CUST_99
TEST_SET_FOLDER_ID
IS_ATTACHMENTS
BUILD_EXECUTE_TIME_INTERVAL
ESTIMATED_DURATION
ACTUAL_DURATION
COUNT_PASSED
COUNT_FAILED
COUNT_CAUTION
COUNT_BLOCKED
COUNT_NOT_RUN
COUNT_NOT_APPLICABLE
EXECUTION_DATE
IS_DYNAMIC
DYNAMIC_QUERY
IS_AUTO_SCHEDULED
TEST_CONFIGURATION_SET_ID

Test Set Folders¶

TEST_SET_FOLDER_ID
PROJECT_ID
PARENT_TEST_SET_FOLDER_ID
NAME
DESCRIPTION
CREATION_DATE
LAST_UPDATE_DATE
EXECUTION_DATE
ESTIMATED_DURATION
ACTUAL_DURATION
COUNT_PASSED
COUNT_FAILED
COUNT_CAUTION
COUNT_BLOCKED
COUNT_NOT_RUN
COUNT_NOT_APPLICABLE
PROJECT_NAME
PROJECT_GROUP_ID

Test Set Incidents¶

INCIDENT_ID
DETECTED_RELEASE_ID
RESOLVED_RELEASE_ID
VERIFIED_RELEASE_ID
IS_OPEN_STATUS

Test Set Test Cases¶

TEST_SET_TEST_CASE_ID
TEST_SET_ID
TEST_CASE_ID
OWNER_ID
POSITION
TEST_SET_NAME
TEST_CASE_NAME
OWNER_NAME
PROJECT_ID
PROJECT_NAME
PLANNED_DATE
IS_SETUP_TEARDOWN

Test Steps¶

TEST_STEP_ID
TEST_CASE_ID
EXECUTION_STATUS_ID
DESCRIPTION
LINKED_TEST_CASE_ID
POSITION
EXPECTED_RESULT
SAMPLE_DATA
LAST_UPDATE_DATE
IS_DELETED
EXECUTION_STATUS_NAME
TEST_CASE_NAME
PROJECT_ID
PROJECT_NAME
PROJECT_GROUP_ID
CUST_01...
CUST_99
IS_ATTACHMENTS
CONCURRENCY_DATE
PRECONDITION

Users¶

USER_NAME
EMAIL_ADDRESS
IS_ACTIVE
CREATION_DATE
LDAP_DN
FIRST_NAME
LAST_NAME
MIDDLE_INITIAL
DEPARTMENT
LAST_UPDATE_DATE
TIMEZONE
LAST_OPENED_PROJECT_ID
IS_APPROVED
LAST_LOGIN_DATE
LAST_ACTIVITY_DATE