Endpoint Read Comments

Name

get_comments

Description

No description available

Related Tables

Comments

Parameters

Output Columns

Input Columns

Examples

SSIS

Use Jira Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

This Endpoint belongs to the Comments table, therefore it is better to use it, instead of accessing the endpoint directly:

API Source - Jira

Read and write Jira data effortlessly. Track, manage, and automate issues, projects, worklogs, and comments — almost no coding required.

Jira

Comments

Optional Parameters
Fields	id,key
Issue Key(s) or Ids - Comma Separated (PRJA-10,PRJA-13)

API Destination

This Endpoint belongs to the Comments table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to read comments:

API Destination - Jira

Read and write Jira data effortlessly. Track, manage, and automate issues, projects, worklogs, and comments — almost no coding required.

Jira

Comments

Select, Lookup

Optional Parameters
Fields	id,key
Issue Key(s) or Ids - Comma Separated (PRJA-10,PRJA-13)

ODBC application

Use these SQL queries in your ODBC application data source:

Read comments for all issues

<p>Gets every comment across all issues. Use this when you need a flat list of all comments. To limit by issue, use the following examples that filter by issue ID or Key, or by JQL.</p>

SELECT * FROM Comments

Read comments for an issue by Key

<p>Gets all comments for a single issue identified by its key (e.g. CS-1).</p>

SELECT * FROM Comments WITH(Key='CS-1')

Read comments for issues by JQL

<p>Gets all comments for issues that match a JQL expression. The connector first finds issues with the given JQL, then returns comments for those issues. Use the same JQL syntax as in the “Read issues using JQL query” example.</p>

SELECT * FROM Comments WITH (Jql='status IN (Done, Closed) AND created > -5d' )

Read comments for an issue by ID or Key

<p>Gets all comments for one issue. Identify the issue by <code>IssueId</code> in the <code>WHERE</code> clause or by <code>Key</code> in <code>WITH</code>.</p>

SELECT * FROM Comments Where IssueId=10003 --OR WITH(Key='10003')

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Read comments for all issues

<p>Gets every comment across all issues. Use this when you need a flat list of all comments. To limit by issue, use the following examples that filter by issue ID or Key, or by JQL.</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Comments';

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];

Read comments for an issue by Key

<p>Gets all comments for a single issue identified by its key (e.g. CS-1).</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Comments WITH(Key=''CS-1'')';

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];

Read comments for issues by JQL

<p>Gets all comments for issues that match a JQL expression. The connector first finds issues with the given JQL, then returns comments for those issues. Use the same JQL syntax as in the “Read issues using JQL query” example.</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Comments WITH (Jql=''status IN (Done, Closed) AND created > -5d'' )';

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];

Read comments for an issue by ID or Key

<p>Gets all comments for one issue. Identify the issue by <code>IssueId</code> in the <code>WHERE</code> clause or by <code>Key</code> in <code>WITH</code>.</p>

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Comments Where IssueId=10003 --OR WITH(Key=''10003'')';

EXEC (@MyQuery) AT [LS_TO_JIRA_IN_GATEWAY];