JDBC Driver for Bitbucket

Build 24.0.9062

Issues

Issues in a repository's Issue Tracker.

Table Specific Information

Select

The 本製品 uses the Bitbucket API to process WHERE clause conditions built with the below columns. Filtering on other columns is processed client-side within the 本製品.

  • Id
  • Title
  • ReporterUUID
  • AssigneeUUID
  • CreatedOn
  • UpdatedOn
  • State
  • Kind
  • Priority
  • MilestoneName
  • ComponentName
  • Votes

The 本製品 uses the Bitbucket API to process ORDER BY clause conditions built with the below columns. Sorting on other columns is processed client-side within the 本製品.

  • Id
  • Title
  • ReporterUUID
  • AssigneeUUID
  • CreatedOn
  • UpdatedOn
  • State
  • Kind
  • Priority
  • MilestoneName
  • ComponentName
  • Votes
  • ContentRaw

For example, the following query is processed server side:

SELECT * FROM Issues WHERE ContentRaw LIKE 'The%'

Insert

At minimum, the Title field must be specified to create a new issue comment. Optionally, the AssigneeUUID, State, Kind, Priority, MilestoneName, ComponentName, and ContentRaw fields can also be specified.

The authenticated user is used as the issue's reporter.

A sample INSERT is included below:

INSERT INTO Issues (Title) VALUES ('Authentication Bug')

Update

A sample UPDATE is included below:
UPDATE Issues SET ContentRaw='problem' WHERE Id=2

Delete

A sample DELETE is included below:
DELETE FROM Issues WHERE Id=2

Columns

Name Type ReadOnly References Description
Id [KEY] Int True

Id of the issue.

Title String False

Name of the issue.

ReporterUUID String True

The reporter of the issue's account uuid.

ReporterName String True

The reporter of the issue's account display name.

AssigneeUUID String False

The account uuid of the person to which the issue is assigned.

AssigneeName String True

The account display name of the person to which the issue is assigned.

CreatedOn Datetime True

When the issue was created.

UpdatedOn Datetime True

When the issue was updated.

EditedOn Datetime True

When the issue was edited.

State String False

State of the issue. Valid values: submitted, new, open, resolved, on hold, invalid, duplicate, wontfix, closed.

Kind String False

Kind of issue. Valid values: bug, enhancement, proposal, task.

Priority String False

Priority of the issue. Valid values: trivial, minor, major, critical, blocker.

MilestoneName String False

The name of the milestone that relates to the issue.

ComponentName String False

The name of the component that relates to the issue.

Votes Int True

Number of votes on the issue.

ContentRaw String False

The text as it was typed by a user.

ContentMarkup String True

The type of markup language in which the raw content will be interpreted.

ContentHTML String True

The issue's content rendered as HTML.

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