This resource represents request comments.

Select

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

• 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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name	Type	Description
Internal	Boolean	Specifies whether to return internal comments or not. Default: true.