ProjectVersions

Query,create, modify and delete the available Versions of a project in Jira.

Table Specific Information

Select

The connector uses the Jira API to process some of the filters. The connector processes other filters within the connector. For example, the following queries are processed server side:

Retrieve the versions for all projects:

SELECT * FROM ProjectVersions

You can also filter by the Id, ProjectKey, or ProjectId. For example:

SELECT * FROM ProjectVersions WHERE Id = 10022

Using ProjectId:

SELECT * FROM ProjectVersions WHERE ProjectId = 10022

Using ProjectKey:

SELECT * FROM ProjectVersions WHERE ProjectKey = 'QMTH'

Insert

Create a new version to be used throughout the project. The Name and either ProjectId or ProjectKey columns are required.

INSERT INTO ProjectVersions (ProjectId, Name, Description, ReleaseDate, StartDate) VALUES ('10000', 'HR Component', 'Example version description', '2018-04-04', '2018-02-02')

Update

Make changes to a project version, specifying the Id column of the version to modify.

UPDATE ProjectVersions SET Released = 'true' WHERE Id = 10065

Delete

Remove a version of the project by specifying the Id column.

DELETE FROM ProjectVersions WHERE Id = 10065

Columns


Name	Type	ReadOnly	References	SupportedOperators	Platform	Description
Id [KEY]	Integer	True		=	Common	The Id of the version.
ProjectId	Integer	False	Projects.Id	=,IN	Common	The selected project's id.
ProjectKey	String	False		=,IN	Common	The selected project's key.
Name	String	False			Common	The name of the version.
Description	String	False			Common	The description of the version.
Released	Boolean	False			Common	Whether the version has been released.
ReleaseDate	Date	False			Common	Release date of the version.
StartDate	Date	False			Common	Optional start date of the version.
UserStartDate	Date	False			Common	The date on which work on this version is expected to start.
UserReleaseDate	Date	False			Common	The date on which work on this version is expected to finish.
Overdue	Boolean	True			Common	Whether the version is overdue for release.
Archived	Boolean	False			Common	Whether the version has been archived. When a new version is created, this field is always set to False.