IssueComments
Comments on 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
- CreatedOn
- UpdatedOn
- UserUUID
- IssueId
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
- 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. |