Excel Add-In for Jira Service Management

Build 24.0.9062

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062