Jira StatusCategory does not work in History JQL statements

[Scott Superko]

This appears to be a bug reported on Jira Server, but it also applies to Jira Cloud.  I can write a JQL query on Status WAS "Under Consideration", but I am unable to write a JQL query on StatusCategory WAS "To Do".

I should be able to do the later because StatusCategory is part of history tracking.  Flagging this as a bug!

[Mikael Sandberg]

This is expected, if you look at the documentation for the WAS operator it states that it only support the fields Assignee, Fix Version, Priority, Reporter, Resolution, and Status. Status category is not a field on the issue, that is linked to the status.

[Stanley Duback]

Hey Scott

To add on to what Mikael posted,

When using statusCategory you are looking for the states of a status and not the status themselves.

You can use statusCategory to find "To Do/Grey Colored Statuses", "In Progress"/Blue Colored Statuses or "Done"/Green Colored statuses.

The following operators are not supported: ~ , !~ , > , >= , < , <=
IS , IS NOT, WAS , WAS IN , WAS NOT , WAS NOT IN , CHANGED

Here is the documentation for statusCategory in JQL

How to search using statusCategory() & statusCategoryChangeDate() function with JQL | Jira | Atlassian Documentation