RequestComments
This resource represents request comments.
Select
The 本製品 will use the Jira Service Management API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.
- Id , Public AND Internalsupport the following operator: =.
SELECT * FROM RequestComments WHERE RequestID = '10001' AND Id = '10002' SELECT * FROM RequestComments WHERE RequestID = '10001' AND Public = 'true'
For Public AND Internal when specified as filters in the query it will tell the API if it should include Public/Internal columns in the response.
The following query will include both public and internal comments in the response:
SELECT * FROM RequestComments WHERE RequestId = '10001'The following query will include only internal comments in the response:
SELECT * FROM RequestComments WHERE RequestId = '10001' AND Public = falseThe following query will include all public comments but not the internal ones:
SELECT * FROM RequestComments WHERE RequestId = '10001' AND Internal = falseThe following query will include neither internal nor public comments in the response:
SELECT * FROM RequestComments WHERE RequestId = '10001' AND Internal = false AND Public = false
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | String | True |
The Id of the comment. |
RequestId [KEY] | String | True |
The Id of the request. |
RequestKey | String | True |
The Key of the request. |
Body | String | False |
The Body of the comment. |
Public | Boolean | True |
Shows if the comment is public or internal |
AuthorKey | String | True |
The key of the comment author. |
CreatedAt | String | True |
The datetime the comment was created. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Internal | Boolean |
Specifies whether to return internal comments or not. Default: true. |