ProjectVersions

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

Table-Specific Information

SELECT

The connector uses the Jira API to process filters based on the Id, ProjectId, and ProjectKey columns. The connector processes all other filters client-side.

For example, the following queries are processed server-side:

SELECT * FROM ProjectVersions WHERE Id = 10022;
SELECT * FROM ProjectVersions WHERE ProjectId = 10022;
SELECT * FROM ProjectVersions WHERE ProjectKey = 'QMTH';

INSERT

Insert a version by specifying the Name and either the ProjectId or ProjectKey columns.

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

UPDATE

Update a version by specifying the Id column and the columns to update.

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

DELETE

Delete a version 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.