An issue's priority defines its importance in relation to other issues, so it helps users to determine which issues should be tackled first. Jira comes with a set of default priorities, which you can modify or add to. You can also choose different priorities for your projects.
List issues with high priority
selectid as issue_no,description as issue_description,assignee_display_name as assigned_tofromjira_issuewherepriority = 'High';
Count of issues per priority
selectp.name as priority,count(i.id) as issue_countfromjira_priority as pleft join jira_issue as i on i.priority = p.namegroup by p.name;
Details of the issue priority.
|description||text||The description of the issue priority.|
|icon_url||text||The URL of the icon for the issue priority.|
|id||text||The ID of the issue priority.|
|name||text||The name of the issue priority.|
|self||text||The URL of the issue priority.|
|status_color||text||The color used to indicate the issue priority.|
|title||text||Title of the resource.|