Hi,
can any one help me to query in SQL how many times a status is used? I want to know in how many workflows a status is used
Thank you
The 'Statuses' page already lists workflows associated with statuses Issues > Statuses '/secure/admin/ViewStatuses.jspa'
Not sure how it gets that because my understanding is that workflows in db are stored simply by their .xml descriptors. There shouldn't be any status:workflow mapping in there, just a table listing statuses, and a table listing workflows and their xml descriptors.
So I'd guess Jira perhaps builds and maintains a cache for this when it initializes the workflows - i.e. already processes them.
Either way you don't want to use SQL for it, because you would have to do string matching per each descriptor.
It looks like you're new here. Sign in or register to get started.
