JDBC Driver for Jira

Build 22.0.8462

Votes

Query the available Votes in JIRA.

Select

The driver will use the Jira APIs to process filters that refer to IssueId or IssueKey and one of them is required to retrieve results. The Jira APIs support only the equals (=) operator to filter on these columns.

The driver will execute filters other than the following client-side within itself. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

For example, the following queries are processed server side:

SELECT * FROM Votes WHERE IssueId=10100

SELECT * FROM Votes WHERE IssueKey='MKY-1'

Columns

Name Type References SupportedOperators Platform Description
Key [KEY] String Common The key of the vote.
Name String Common The name of the vote.
DisplayName String Common The display name of the vote.
Active Boolean Common Boolean indicating if the vote is active.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
IssueId String The issue Id of the vote.
IssueKey String The issue key of the vote.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462