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: =.

For example, the following query is processed server side:

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 = false

The following query will include all public comments but not the internal ones:

SELECT * FROM RequestComments WHERE RequestId = '10001' AND Internal = false

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