Order by priority

[natalia.kozik]

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

[Nic Brough -Adaptavist-]

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.