Issues in a repository's Issue Tracker.

Table Specific Information

Select

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

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

The server 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 server.

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