For one Project dashboard, we have total 91 Applications, now when exporting this dashboard to PDF using 'Better PDF Exporter' plugin, only first 5 rows and then their total count is exporting to PDF. (this might be because as we are using free version)
Now, as per user requirement, if all the applications are not getting exported then they are expecting to see atleast the top 5 five applications with more no. of issues. Likewise, Application 'P' has 10 issues, 'Q' has '5', 'R' has '15' issues, 'S' has 16, 'T' has 12 issues, 'U' has 8, 'V' has 18 issues likethis...91 applications having 494 issues.
So now, user needs 5 applications (P,R,S,T,V) to appear in report having maximum no. of issues.
Can anyone help me with the query for the same please? I'm not a SQL expert. Thanks. Also, I need this query to be run on Application end-> Issues itself, not in DB as we need to have this saved as a dashboard filter
Thanks Derek for your response.
I'm using Two Dimensional filter gadget. Actually, the problem is data is correctly appearing as per the filter criteria but on exporting the dashboard out of 91 applications, only top 5 applications are appearing with the total count, rest all are getting removed. Not sure, why it is happening. That's why was looking for the query.
Snapshort from PDF Extract:
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events