ProjectVersions

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

テーブル固有の情報

Select

本製品はJira API を使用して一部のフィルタを処理します。本製品は他のフィルタを本製品内で処理します。例えば、次のクエリはサーバー側で処理されます。

すべてのプロジェクトのバージョンを取得：

SELECT * FROM ProjectVersions

Id、ProjectKey、またはProjectId でフィルタをかけることもできます。次に例を示します。

SELECT * FROM ProjectVersions WHERE Id = 10022

ProjectId の使用：

SELECT * FROM ProjectVersions WHERE ProjectId = 10022

ProjectKey の使用：

SELECT * FROM ProjectVersions WHERE ProjectKey = 'QMTH'

Insert

プロジェクト全体で使用する新しいバージョンを作成します。Name と、ProjectId またはProjectKey いずれかのカラムが必須です。

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

Update

変更するバージョンのId カラムを指定して、プロジェクトバージョンを変更します。

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

Delete

Id カラムを指定して、プロジェクトのバージョンを削除します。

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.