We're working on a few different things and need to completely delete all filters, and all dashboards (and their gadget population of data, so we don't end up with a bunch of stacktraces in the log).
As I understand it, I have to:
I have this query to pull up all dashboards in JIRA 6.4.12:
select username, pagename, fav_count, id
order by Username
And this query to pull up all filters in JIRA 6.4.12:
select filtername, authorname, fav_count, id
But how do I en masse remove all of them from JIRA? As in, delete.
There is no good way. The only way to do it en masse is also the most dangerous, which would be deleting directly from the database. Unless an engineer from Atlassian or one of their "Partners" could give you the necessary queries to make sure that all references were removed from all of the necessary tables, I certainly wouldn't recommend doing it. From past experience, there are just too many places that those references can hide, which can end up causing more problems.
The safest method, is probably the slowest and most intensive, is to delete everything through the UI, one at a time, but you would still have to ensure to delete in the proper order. Deleting through the UI, usually, ensures that all of the references get removed properly, but even then that's not always the case.
I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...
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