# IssueTransitionsByIdOrKey - Catalog: `JIRA` - Schema: `Core` - Primary Keys: `id` - Select JIRA Cloud API URL: `/issue/{issueIdOrKey}/transitions` - Insert JIRA Cloud API URL: `/issue/{issueIdOrKey}/transitions` - Update JIRA Cloud API URL: `/issue/{issueIdOrKey}/transitions` - Delete JIRA Cloud API URL: `/issue/{issueIdOrKey}/transitions` - Field Selection Method: NotRequired - Base Path: `transitions[*]` 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 | |---|:---:|:---:|:---:|---| | `issueIdOrKey` | `string` | ☑ | | The ID or key to be retrieved. | ## Columns of Table Function The columns of the table function `IssueTransitionsByIdOrKey` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `hasScreen` | `boolean` | | ☐ | Whether there is a screen associated with the issue transition. | | `id` | `string` | | ☐ | The ID of the issue transition. Required when specifying a transition to undertake. | | `isConditional` | `boolean` | | ☐ | Whether the issue has to meet criteria before the issue transition is applied. | | `isGlobal` | `boolean` | | ☐ | Whether the issue transition is global, that is, the transition is applied to issues regardless of their status. | | `isInitial` | `boolean` | | ☐ | Whether this is the initial issue transition for the workflow. | | `name` | `string` | | ☐ | The name of the issue transition. | | `to_description` | `string` | | ☐ | Description. | | `to_iconUrl` | `string` | | ☐ | Icon URL. | | `to_id` | `string` | | ☐ | ID. | | `to_name` | `string` | | ☐ | Name. | | `to_statusCategory_colorName` | `string` | | ☐ | Name of color. | | `to_statusCategory_id` | `string` | | ☐ | ID. | | `to_statusCategory_key` | `string` | | ☐ | Key. | | `to_statusCategory_name` | `string` | | ☐ | Name. |