# ProjectVersionsByIdOrKey: JIRA Cloud Project Components by ID or Key - Catalog: `JIRA` - Schema: `Core` - Primary Keys: `id` - Label: Project Components by ID or Key - Select JIRA Cloud API URL: `/project/{projectIdOrKey}/version` - Insert JIRA Cloud API URL: `/project/{projectIdOrKey}/version` - Update JIRA Cloud API URL: `/project/{projectIdOrKey}/version` - Delete JIRA Cloud API URL: `/project/{projectIdOrKey}/version` - 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 `ProjectVersionsByIdOrKey` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `archived` | `boolean` | | ☐ | Indicates that the version is archived. | | `description` | `string` | | ☐ | The description of the version. | | `id` | `string` | | ☐ | The ID of the version. | | `moveUnfixedIssuesTo` | `string` | | ☐ | The URL of the self link to the version to which all unfixed issues are moved when a version is released. | | `name` | `string` | | ☐ | The unique name of the version. | | `overdue` | `boolean` | | ☐ | Indicates that the version is overdue. | | `projectId` | `int64` | | ☐ | The ID of the project to which this version is attached. | | `released` | `boolean` | | ☐ | Indicates that the version is released. If the version is released a request to release again is ignored | | `releaseDate` | `datetime` | | ☐ | The release date of the version. | | `self` | `string` | | ☐ | The URL of the version. | | `startDate` | `datetime` | | ☐ | The start date of the version. | | `userReleaseDate` | `datetime` | | ☐ | The date on which work on this version is expected to finish. | | `userStartDate` | `datetime` | | ☐ | The date on which work on this version is expected to start. |