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!
Hi
yes. there is
you can write :
project = " " AND status in ("Open", "In Progress","ready for support")
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...)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Depending on how you want to present the data you may wish to look at the two dimensional gadget or possibly a pie chart.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.