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