RELEASES
- Last Updated: July 2, 2025
- 1 minute read
- DataDirect Connectors
- JDBC
- Aha! 6.0
- Documentation
Endpoint
<hostname>/api/v1/releases
Columns
The RELEASES table contains the following columns. Columns marked with an asterisk comprise the primary key.
| Column Name | Data Type |
|---|---|
| ID* | BigInt |
| COMMENTS_COUNT | Integer |
| CREATED_AT | Timestamp(9) |
| CREATED_BY_USER_AVATAR_URL | VarChar(174) |
| CREATED_BY_USER_CREATED_AT | Timestamp(9) |
| CREATED_BY_USER_EMAIL | VarChar(64) |
| CREATED_BY_USER_ID | BigInt |
| CREATED_BY_USER_NAME | VarChar(64) |
| CREATED_BY_USER_UPDATED_AT | Timestamp(9) |
| DEVELOPMENT_STARTED_ON | Date |
| EXTERNAL_DATE_RESOLUTION | VarChar(64) |
| EXTERNAL_RELEASE_DATE | Date |
| EXTERNAL_RELEASE_DATE_DESCRIPTION | VarChar(64) |
| KEY | VarChar(64) |
| MASTER_RELEASE | Boolean |
| NAME | VarChar(64) |
| ORIGINAL_ESTIMATE | VarChar(64) |
| OWNER_AVATAR_URL | VarChar(174) |
| OWNER_CREATED_AT | Timestamp(9) |
| OWNER_EMAIL | VarChar(64) |
| OWNER_ID | BigInt |
| OWNER_NAME | VarChar(64) |
| OWNER_UPDATED_AT | Timestamp(9) |
| PARENT_CREATED_AT | Timestamp(9) |
| PARENT_ID | BigInt |
| PARENT_NAME | VarChar(64) |
| PARENT_REFERENCE_NUM | VarChar(64) |
| PARENT_RELEASE_DATE | Date |
| PARENT_RESOURCE | VarChar(82) |
| PARENT_START_DATE | Date |
| PARENT_URL | VarChar(82) |
| PARKING_LOT | Boolean |
| POSITION | Integer |
| PRODUCT_ID | BigInt |
| PROGRESS | Integer |
| PROGRESS_SOURCE | VarChar(64) |
| PROJECT_CREATED_AT | Timestamp(9) |
| PROJECT_ID | BigInt |
| PROJECT_NAME | VarChar(64) |
| PROJECT_PRODUCT_LINE | Boolean |
| PROJECT_REFERENCE_PREFIX | VarChar(64) |
| RELEASE_DATE | Date |
| RELEASED | Boolean |
| REMAINING_ESTIMATE | Double |
| RESOURCE | VarChar(90) |
| START_DATE | Date |
| THEME_BODY | VarChar(232) |
| THEME_CREATED_AT | Timestamp(9) |
| THEME_ID | BigInt |
| UPDATED_AT | Timestamp(9) |
| URL | VarChar(82) |
| WORK_DONE | Double |
| WORK_UNITS | Integer |
| WORKFLOW_STATUS_COLOR | VarChar(64) |
| WORKFLOW_STATUS_COMPLETE | Boolean |
| WORKFLOW_STATUS_ID | BigInt |
| WORKFLOW_STATUS_NAME | VarChar(64) |
| WORKFLOW_STATUS_POSITION | Integer |