Hi I was wondering whether it's possible via this add on to to a) save queries b) use these as the a data source within PowerBI. I have had a quick play with the add on and can build a qu...
After upgrading to JIRA 8.2, it became next to unusable due to long waits in processing queries which returned multiple issues (e.g. filter, project queue, etc.). We tracked it down to the SQL + JQL ...
Hi all, is it possible to save a SQL for Jira query as a filter, to be used with the Filter Results gadget in a Jira's dashboard? Thanks -- Enrico
I want to send some parameters like name of the project, and then show the table of results like it does when you save the query and show it into a gadget Thanks
Hi, I want to run sql queries on the tables cwd_user and cwd_user_attributes to retrieve users' last login dates as described here. To run the queries, I tried 3 different sql add-ons (using JIRA S...
We downloaded the add-on on our test instance but facing some issues. One of our requirement is to capture the version change date. Ex- If the release version ( start or end date) is changed, we wan...
Can I limit the JIRA users that can see and access this add-on, want to limit this to administrators and a few power users.
We have some projects with multiple custom fields that are not associated with every issue. I tried using left outer joins, however, the result is the same as an inner join. Does the db engine s...
Consider below scenario - I have field in story - "Field_1" I have created link - Outward Description > is parent of Inward Description > is child of Now, I want to sum up the valu...
Hi, Does anyone know if it's possible to create hourly automated exports to Excel containing data created by KintoSoft's SQL for Jira queries? So for example, each hour a new export is ge...
By Using SQL FOR JIRA I want to find the details of all issues of issutype name RTM in a project name ORBB which changed last week with following information 1) changed issues 2) what changes to ...
Hello, When trying to use "Export to SQL" or "Data Analysis" options from Export, after making a query, I get the error: Forbidden (403) Encountered a "403 - Forbidden" error while ...
I'm using your plugin to get the information I need, so far it's working great, but I need to edit values directly in the database, I will do so in a closed test environment, but how can I get the ac...
Copied to clipboard
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.