Missing JQL Query in Jira Cloud in Excel

[Nicholas Ren]

Hi Community, 

I'm trying to query the status of tickets in Excel but I can't seem to find the JQL query for some of my statuses.

In my project, I have 'Discovery' as a status but as you can see, I do not have the JQL query for it.

How do I resolve this?

[Alex Koxaras -Relational- · Accepted solution]

Ηι @Nicholas Ren 

The "Discovery" you are referring to, might as well be a column name and not a status. You have to go to board settings -> columns and see which status(es) correspond to that specific column. Most likely, there isn't such a status.

[Nicholas Ren]

Hi @Alex Koxaras -Relational- 

I've actually checked again and its there.

Discovery wasn't part of the list of suggested queries but when I typed Discovery, it came up.

A bit strange how it didn't appear in suggested queries.

Thanks,