ProjectVersions

Provides access to project version management. Supports querying, creating, updating, and deleting versions.

Table Specific Information

Select

The provider uses the Jira API to process some of the filters. The provider processes other filters within the provider. 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 unique identifier for the version within the project.
ProjectId	Integer	False	Projects.Id	=,IN	Common	The unique identifier of the project to which this version belongs.
ProjectKey	String	False		=,IN	Common	The key of the project associated with this version, used to reference the project in queries and URLs.
Name	String	False			Common	The name assigned to the version, often representing a milestone or release number such as '1.0.0' or 'Q4 2024'.
Description	String	False			Common	A textual description providing context or notes about what the version includes or represents.
Released	Boolean	False			Common	Indicates whether the version has been officially released. If the value is 'true', the version is considered complete and available.
ReleaseDate	Date	False			Common	The official release date of the version, typically used for scheduling and reporting purposes.
StartDate	Date	False			Common	The planned start date for work associated with this version. Optional and used mainly for roadmap planning.
UserStartDate	Date	False			Common	The user-defined date indicating when the work on this version is expected to begin. Used for manual planning.
UserReleaseDate	Date	False			Common	The user-defined date indicating when the work on this version is expected to end. Helps track expectations versus actuals.
Overdue	Boolean	True			Common	Indicates whether the version's release date has passed without being marked as released.
Archived	Boolean	False			Common	Indicates whether the version is archived. Archived versions are no longer active and are typically hidden from default views.