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 vote

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 Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published Mar 09, 2018 in Jira Service Desk

E.L. Fridge's take on education, Jira Service Desk, and creative Jira use cases

...word of mouth, so by 2016, we were working with several other entities on campus to implement Jira Service Desk . The Atlassian motto of “for every team” has really come true for us in this case. We...

1,164 views 2 14
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