Sample Formulas - JQL

Query Match

Flag issues that match or do not match a given query.

IF(JQL{<JQL_QUERY>}, "✅ ", "❌")

Replace <JQL_QUERY> with your actual query. For example:

• IF(JQL{project="CLOUD"}, "✅ ", "❌") > Returns ✅ if the issue is in project “CLOUD”; returns ❌ if it is in another project.

Identify recently created issues

This example identifies issues created within the past 4 weeks.

IF JQL{created > "-4w"}:
  "scope creep"

To look at issues made more or less recently, update the "4w"; to display a different notification, change the "scope creep" text.