Embed a JQL inside an expr formula

Deepti Sharma_dw34v0

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!

Bill Sheboy

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