We are using JIRA with MSSQL database.
I have the task to use BI at the issue details. The problem is that I cannot create an mssql query where I can get every detail on a ticket.
Do you have any ideas/experience, mssql query code to get the following query result?
issue ID, issue key, summary, priority, resolution [usual issuedetails],project, project category, WORKFLOW, workflowscheme.
Any help woulbd much appreciated!
Best: Peter Cselotei
I would not recommend connecting directly to the database for this purpose. Atlassian changes the database schema regularly with each release, so there is a good chance the SQL that works today will not work at some point in the future once you upgrade. Other reasons why it's not a good idea to connect to the database directly:
These are some of the high points, but there are many other reasons why connecting directly to the DB is a bad idea. The Jira REST APIs are the right tools for the job and allow you to easily do what you are looking for. Atlassian even publishes an example of exactly what you are trying to do. Since you know the JQL that you want, you can simply run that identical query in a REST call and pull the data out that you're after, then post process it to pump it in to the system doing the data analysis.
One word of warning on the REST API, though. None of the Atlassian apps have any sort of protection against abuse built in to their APIs. You should query at sensible intervals and pull only the data that you need in order to minimize the performance impact on the system. For example, if you only want to see what changed since the last query, don't pull out 1000 issues and parse them outside of Jira. Use JQL to provoke Jira to respond with the issues that have changed since the last query run. I hope that helps.
...PermissionsStartOnly=true User=www-data Group=www-data ExecStart=/opt/jira/bin/startup.sh ExecStop=/opt/jira/bin/shutdown.sh TimeoutStartSec=120 TimeoutStopSec=600 PrivateTmp=true [Install] WantedBy...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs