How to map or relate AO_54307E_VIEWPORTFORM to jiraissue table using sql? Edited

I am trying to find the request type and I found it in table AO_54307E_VIEWPORTFORM (eg: password reset, application error). I need to know that count of issues in each request type.. To count the number of issues i am trying to use jiraissue table. I tried a lot of different queries in SQL but I am not getting the correct answer.

Could somebody please let me know how to connect or relate AO_54307E_VIEWPORTFORM and jiraissue table??

1 answer

0 votes

Don't.  SQL is the single worst way to try to report on Jira data.  Please, form a query and do it via the Jira UI or REST calls.

What report are you trying to generate here?

The thing is I am trying to develop reports on Jira Data in power BI. The only thing I am doing is extracting the required data from SQL Server and trying to develop reports in power BI. so I cannot use any other form of query or REST API.  Could you please give me solution via SQL?

Nope.  Can't do it.  There is no direct relationship in SQL.  You need to read the form to work out what is on it, then parse the queries building it to work out what issues are there.

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Feb 15, 2018 in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

1,035 views 6 18
Read article

Atlassian User Groups

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!

Find my local user group

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

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot