Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Display of all open tickets under a single status in a gadget

mesons March 4, 2020

Hello,

is there a way to query to summarize of all open tickets in one?

Open tickets include tickets like, open, ready for support, in progress etc.

Thanks in advance!

2 answers

0 votes
kimiya majd
Contributor
March 4, 2020

Hi

yes. there is 

you can write :

project = " " AND status in ("Open", "In Progress","ready for support")

0 votes
Jack Brickey
Community Champion
March 4, 2020

The best way to do this is to leverage the resolution field. However, this assumes that you always set the resolution when moving an issue into any Done Category status.

JQL - resolution is empty

if the above resolution assumption is invalid then you will need to do something like below and specify every Done status...

JQL - status not in (Done, Closed, Resolved...)

mesons March 4, 2020

The background to my question is that I wanna present this summary in a gadget.

My goal is to present the status of all tickets in 2 lines like:

open: includes tickets like ready for support, in progress, waiting for customer, ...

closed: is clear

Jack Brickey
Community Champion
March 4, 2020

Depending on how you want to present the data you may wish to look at the two dimensional gadget or possibly a pie chart. 

mesons March 4, 2020

More specifically, I wanna use this summary in rolling window monthly gadget.

line 1: summarizing of all open tickets under a single status - is it possible?

line 2: all closed tickets - that's clear.

Jack Brickey
Community Champion
March 4, 2020

I am not familiar with that gadget. It isn’t part of my default gadgets. I am guessing it is an addon. If so I would reach out to the vendor support.

mesons March 4, 2020

Can you generally tell me whether it is possible to group all open tickets (ready for support, in progress, remote access, waiting for customer, ...) under one status? If yes - then how?

Jack Brickey
Community Champion
March 4, 2020

you can't group them under one "Status" as they are separate statuses. However, you can certainly create a filter that results in all issues in multiple statuses. You might even consider using the following....

statusCategory != Done

that would give you every status except those that are in the Done status category.

if you can point me to documentation about this gadget I might be able to assist further. Again, i would recommend the 2-D gadget as I expect you could organize the table by status category (To Do, In Progress, Done). In that view the To Do and In Progress represent anything not Done.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events