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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.