search

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

JQL search on `jira_issue` table is case sensitive while the JIRA API is not #85

Closed ashubham closed 10 months ago

ashubham commented 1 year ago

Describe the bug When I do this query: select * from jira_issue where status='Open' limit 10 it works.

But when I do: select * from jira_issue where status='open' limit 10 it returns 0 results.

The lower case open should still return the same results as JIRA JQL is case insensitive. I tried it by calling the rest/api/2/search JIRA api directly and it works as expected, but not via steampipe.

Steampipe version (steampipe -v) v0.20.9

Plugin version (steampipe plugin list) v0.10.1

To reproduce Do a lower case search on any JIRA field: select * from jira_issue where status='open' limit 10 for example, to see 0 results.

Expected behavior The above query should return results including open tickets.

ParthaI commented 1 year ago

@ashubham, I appreciate your engagement with Steampipe and for bringing this matter to our attention. In response to the issue, we have submitted a preliminary Pull Request to address it. Would you be able to assist us by testing this PR? You can do so by checking out the issue-85 branch.

Here's how you can test the code changes:

  1. Clone the repository: git clone https://github.com/turbot/steampipe-plugin-jira.git
  2. Navigate to the steampipe-plugin-jira directory: cd steampipe-plugin-jira
  3. Checkout to branch git checkout issue-85
  4. Run the make command.
  5. Proceed to run your query.

We would greatly appreciate it if you could provide us with your feedback based on your testing experience.

Thank you!

github-actions[bot] commented 11 months ago

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 30 days.