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!
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:
Kind regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.