Order by priority

Deleted user February 14, 2022

Hi Everyone,

How this query should look like if I would like to show the priority in the order from highest to lowest on my dashboard?

project in (STONEX) AND issuetype = Bug AND status in (Accepted, Backlog, "In Analysis", "In Progress", "In QA", "In Review", Ready, "Ready for Internal QA", "Ready for QA", Reported) AND priority in (Highest, High, Medium, Low, Lowest) AND "Customer[Select List (multiple choices)]" in ("Spectratech (Quicksilver)", Stone) ORDER BY cf[10249] ASC, created DESC

Many thanks,

Natalie

1 answer

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 14, 2022

The only bit you need worry about here is the "order by".  Change it to include the priority, so

order by priority desc

for a simple priority only sort, or probably

ORDER BY priority desc, cf[10249] ASC, created DESC

for your query.

Bear in mind that the dashboard gadget needs to be one that recognises and uses a sort order in a filter.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events