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 Sign up to answer
Community showcase
Published Aug 13, 2018 in Jira Service Desk

Jira Service Desk – Don’t be afraid, the journey begins with curiosity!

...be more productive while being fun to use at the same time. For some, getting started can be a bit intimidating. This is especially true if Jira Service Desk is your first exposure to Atlassian...

36,252 views 13 39
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