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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.