Embed a JQL inside an expr formula

Deepti Sharma October 14, 2021

I would like to embed a jql query which looks up issues with status unchanged >14 days and use it in Jira Structure formula column, inside an if conditional statement to display NOK if the status hasn´t changed for > 14 days and OK otherwise.

Can someone suggest a suitable query please!

1 answer

1 accepted

0 votes
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 14, 2021

Hi @Deepti Sharma -- Welcome to the Atlassian Community!

Please try this JQL for that, replacing your project name and perhaps adjusting the statusCategory check, as needed:

project = myProject AND NOT status CHANGED AFTER -14d AND statusCategory IN ("In Progress")

To learn more about such queries, please review this documentation:

https://support.atlassian.com/jira-software-cloud/docs/use-advanced-search-with-jira-query-language-jql/

Kind regards,
Bill

Deepti Sharma October 14, 2021

Thank you Bill Sheboy!

Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer