Comments on issues in a repository's Issue Tracker.

Table Specific Information

Select

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

• Id
• CreatedOn
• UpdatedOn
• UserUUID
• IssueId

The add-in 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 add-in.

• Id
• CreatedOn
• UpdatedOn
• ContentRaw
• UserUUID

For example, the following query is processed server side:

SELECT * FROM IssueComments WHERE IssueId=6 AND Id=66668011

Insert

The ContentRaw and IssueId fields must be specified to create a new issue comment.

A sample INSERT is included below:

INSERT INTO IssueComments (ContentRaw, IssueId) VALUES ('new comment', 4)

Update

Only the ContentRaw can be modified.

A sample UPDATE is included below:

UPDATE IssueComments SET ContentRaw='newcontent' WHERE ContentRaw='abcd'

Delete

A sample DELETE is included below:

DELETE FROM IssueComments WHERE ContentRaw='newcontent'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Int	True		Id of the issue comment.
CreatedOn	Datetime	True		When the comment was created.
UpdatedOn	Datetime	True		When the comment was updated.
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.
UserUUID	String	True		The account uuid of the person who made the comment.
UserName	String	True		The account display name of the person who made the comment.
IssueId [KEY]	Int	True		The id of the issue to which the comment is attached.