Is there a workaround to exporting filters to include 'Status Category' field

[Deleted user]

We are in the process of creating views in Tableau that will reference Status Category.  I am unable use the export filter option as the Status Category in the filter doesn't appear in excel.  Does anyone else have this issue and is there a work around? I am on Cloud.

[Tanya Gordon]

Just from the top of my head, without testing or anything, I guess you could create a vlookup if you get a list of all statuses and their respective categories. Status Category is indeed not shown on the filter columns. I wouldn't worry about compatibility too much, because the status category is not changed frequently.

[Deleted user]

Maybe I didn't phrase my question correctly.  I know how to create excel Vlookups however it would be much simpler if I can just export my filter as it shows on the UI and have the respective 'Status Category' in the respective row/column.  Doing it that way requires maintaining any changes in JIRA in excel as well and that is what I am trying to prevent. When exporting a filter, I am unable to see the status category, it is blank.  Is there a way to show the category in my export?

[Tanya Gordon]

Well, another solution may be using a custom field and filling it with a scripted post function that you'll attach to all transitions (lots of work here). The code will read the current status of an issue and "calculate" the corresponding status category. 

The same can also be achieved via scripts listeners, which will save you the hustle of setting up the post functions on all transitions. But you have to be careful with the code to make sure it's not triggered too frequently. 

Both suggestions are valid if you have the script runner app.