ODBC Driver for Jira

Build 24.0.8963

ProjectComponents

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

Table Specific Information

Select

The driver uses the Jira API to process some of the filters. The driver processes other filters within the driver.

For example, the following queries are processed server side:

Retrieve the components of each project

SELECT * FROM ProjectComponents

You can also filter the components by their Id or the Project they are part of:

SELECT * FROM ProjectComponents WHERE Id = 10022 

Using ProjectId:

SELECT * FROM ProjectComponents WHERE ProjectId = 10027 

Using ProjectKey:

SELECT * FROM ProjectComponents WHERE ProjectKey = 'QMTH' 

Insert

Create a new Component for the project. The ProjectKey and Name columns are required.

INSERT INTO ProjectComponents (ProjectKey, Name, AssigneeType) VALUES ('COB', 'Testing Component', 'PROJECT_LEAD')

Update

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

UPDATE ProjectComponents SET LeadKey = 'newlead' WHERE Id = 10065

Delete

Remove a component of the project by specifying the Id.

DELETE FROM ProjectComponents WHERE Id = 10065

Columns

Name Type ReadOnly References SupportedOperators Platform Description
Id [KEY] Integer True = Common

The Id of the component.

ProjectId Integer True

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 component.

Description String False Common

The description of the component.

LeadDisplayName String True Common

The display name of the component's lead.

LeadKey String False Common

The key of the component's lead.

AssigneeType String False Common

The type of the component's default assignee.

The allowed values are PROJECT_DEFAULT, COMPONENT_LEAD, PROJECT_LEAD, UNASSIGNED.

AssigneeDisplayName String True Common

The display name of the component's default assignee.

AssigneeKey String True Common

The key of the component's default assignee.

IsAssigneeTypeValid Boolean True Common

Whether the assignee type is valid.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963