JQL Jira Risk Search
All risk assessment data are available in both read-only Jira risk custom fields and issue entity property.
1. JQL risk issue custom fields
The solution creates Jira issue risk custom fields at installation. Risk assessment are then written to those custom fields and are JQL searchable. Please see below some examples and find more information on all the risk custom fields (here)
JQL | Comments |
|---|---|
"Risk severity" is not EMPTY | All issues with risk assessment including Unspecified |
"Risk severity" = highest | All issues with inherent severity HIGHEST |
"Risk impact" = medium | All issues with inherent impact MEDIUM |
"Risk probability" = remote | All issues with inherent probability Remote |
"Risk severity (residual)" = low | Residual risk severity highest is LOW |
2. JQL risk issue entity property
Risk assessment are also saved in the Jira issue in something called Jira entity property. Entity property is issue meta data and see below an example JQL picture, entity property data structure and how it is searchable with Jira JQL expressions.
Risk Property | Type | Value |
|---|---|---|
| date | Risk created date. If a risk is assigned to an existing Jira issue the created date is the assign date and not the issue created date |
| string | The name of the person creating a risk or assigning a risk to an existing Jira issue |
| date | Risk update date |
| string | The name of the person last updating the risk |
| string | Unspecified, LOW, MEDIUM, HIGH, HIGHEST (default risk matrix) |
| number | 0-4 (low to high) |
| number | risk score |
| string | Unspecified, Negligible, Minor, Medium, High, Severe (default risk matrix) |
| number | 0-5 (low to high) |
| string | Unspecified, Rare, Unlikely, Possible, Likely, Almost certain (default risk matrix) |
| number | 0-5 (low to high) |
| string | Unspecified, LOW, MEDIUM, HIGH, HIGHEST (default risk matrix) |
| number | 0-4 (low to high) |
| number | residual risk score |
| string | Unspecified, Negligible, Minor, Medium, High, Severe (default risk matrix) |
| number | 0-5 (low to high) |
| string | Unspecified, Rare, Unlikely, Possible, Likely, Almost certain (default risk matrix) |
| number | 0-5 (low to high) |
Important: Please note that that the impact, probability and severity text is fully configurable in each risk register risk matrix.
Examples
JQL | Comments |
|---|---|
issueRiskCreated >= -30d | All risks created last 30 days |
issueRiskCreated >= "2025-01-01" AND issueRiskCreated < "2025-12-31" | All risks created in 2025 |
issueRiskCreatedBy = "Tom Smith" | All risks created by Tom Smith |
issueRiskUpdated >= -30d | All risks updated last 30 days |
issueRiskUpdatedBy = "Linda Davis" | All risks updated by Linda Davis |
issueRiskSeverity is not EMPTY | All Issues with a risk including Unspecified Severity |
issueRiskSeverity = HIGHEST | All Issues with HIGHEST Severity |
issueRiskSeverityValue = 4 | All Issues with HIGEST Severity using value |
issueRiskSeverityResidual is EMPTY | All Issues not having a residual risk |
issueRiskScore >= 10 | All Issues with score higher or equal to 10 |