JDBC Driver for Jira Service Desk

Build 22.0.8462

RequestComments

This resource represents request comments.

Select

The driver will use the Jira Service Desk API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.

  • Id and Public support 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'

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462