Please find my requirement below.
Currently we have restricted our users to query the Jira report only for 1000 records. But we have requirement from many users to leverave it for unlimited report generation.
So we come up with idea to setup dedicated Jira for reporting alone ( test jira Instances).
My question here is :
Can we create DB view from current prod DB and use it in another Jira instances rather than clone the production DB every time and make sync and re-indexing every time to run and access report alone.
Please avise whether this would be possible. Please also provide if you have any other suggestion.
check this documents it will help you to generate reports in jira
some commercial plugins are there
You can do this, with caveats. I think you've actually spotted most of them, but I'll go over what you'll need to do step by step:
This is possibly quite a lot of work for little reward though. The demand to bypass the 1000 limit implies your users aren't actually reporting, they're just doing data dumps and whacking it into some other system to mash the data into shape.
A far far better approach would be to go to your users and ask them why they think they need to do this. EVERY time I've done this, we've found out that they simply haven't looked for reports that Jira can do for them without any downloading, or that they don't really know what they are doing, or that they only need summaries of statistics (which are not that obvious in Jira, but can be extracted with a little thought and zero load). On the few times those don't cover it, it's not that difficult to write something in Jira that can do the work far more quickly.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
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