turbot / steampipe-plugin-jira

Use SQL to instantly query Jira. Open source CLI. No DB required.
https://hub.steampipe.io/plugins/turbot/jira
Apache License 2.0
22 stars 14 forks source link

Empty result for jira_issue_comment with id filters #137

Closed dcdamien closed 1 month ago

dcdamien commented 2 months ago

Describe the bug

I'm not able to get any comment by id or issue_id but referring to, for example, login_id works.

Steampipe version (steampipe -v)

Steampipe v0.23.3

Plugin version (steampipe plugin list)

+---------------------------------------------+---------+-------------+
| Installed                                   | Version | Connections |
+---------------------------------------------+---------+-------------+
| hub.steampipe.io/plugins/turbot/jira@latest | 0.15.0  | jira        |
+---------------------------------------------+---------+-------------+

To reproduce

  1. Find some random comment:
    > select * from jira_issue_comment limit 1;
    +--------------------------+--------+----------+----------------------------------------------------------------------+---------------+---------------------------+------------------------>
    | login_id                 | id     | issue_id | self                                                                 | body          | created                   | updated                >
    +--------------------------+--------+----------+----------------------------------------------------------------------+---------------+---------------------------+------------------------>
    | 5dee8dbc15a4b90e93bf896f | 200540 | 58412    | https://xxx.atlassian.net/rest/api/2/issue/58412/comment/200540 | h3. 1/07/2024 | 2024-08-29T21:46:17+02:00 | 2024-08-29T21:46:17+02:>
    +--------------------------+--------+----------+----------------------------------------------------------------------+---------------+---------------------------+------------------------>
  2. Try to find it by id or issue_id
> select * from jira_issue_comment where issue_id = '58412';
+----------+----+----------+------+------+---------+---------+------------+--------+---------------+-------+--------------------+--------+------+
| login_id | id | issue_id | self | body | created | updated | jsd_public | author | update_author | title | sp_connection_name | sp_ctx | _ctx |
+----------+----+----------+------+------+---------+---------+------------+--------+---------------+-------+--------------------+--------+------+
+----------+----+----------+------+------+---------+---------+------------+--------+---------------+-------+--------------------+--------+------+
> select * from jira_issue_comment where id = '200540';
+----------+----+----------+------+------+---------+---------+------------+--------+---------------+-------+--------------------+--------+------+
| login_id | id | issue_id | self | body | created | updated | jsd_public | author | update_author | title | sp_connection_name | sp_ctx | _ctx |
+----------+----+----------+------+------+---------+---------+------------+--------+---------------+-------+--------------------+--------+------+
+----------+----+----------+------+------+---------+---------+------------+--------+---------------+-------+--------------------+--------+------+

Expected behavior It should return comments by their ID or originating issue ID.