# ProjectStatusesByIdOrKey: JIRA Cloud Project Statuses by ID or Key - Catalog: `JIRA` - Schema: `Core` - Primary Keys: `id` - Label: Project Statuses by ID or Key - Select JIRA Cloud API URL: `/project/{projectIdOrKey}/statuses` - Insert JIRA Cloud API URL: `/project/{projectIdOrKey}/statuses` - Update JIRA Cloud API URL: `/project/{projectIdOrKey}/statuses` - Delete JIRA Cloud API URL: `/project/{projectIdOrKey}/statuses` - Field Selection Method: NotRequired This is a read-only table function. The JIRA Cloud API may not support changing the data or the Invantive SQL driver for JIRA Cloud does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the JIRA Cloud API. ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `projectIdOrKey` | `string` | ☑ | | | ## Columns of Table Function The columns of the table function `ProjectStatusesByIdOrKey` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `id` | `string` | | ☐ | The ID of the issue type. | | `name` | `string` | | ☐ | The name of the issue type. | | `self` | `string` | | ☐ | The URL of the issue type's status details. | | `statuses` | `string` | | ☐ | List of status details for the issue type. | | `subtask` | `boolean` | | ☐ | Indicates whether this issue type represents subtasks. |