Forums

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

Trying to create a query to find all the tickets I have touched

Mykle Mortenson
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 18, 2020

I have already created the query below but I am also trying to find tickets I have added labels and/or components. Is this possible?

issueFunction in commented("by XXXX") OR status changed by (XXXX) OR worklogAuthor = XXXX OR assignee was in (XXXX) OR reporter was in (XXXX) OR fixVersion changed by (XXXX) ORDER BY created ASC

2 answers

0 votes
KAGITHALA BABU ANVESH
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.
December 18, 2020

what if an issues was assigned to 3 different people and if the task was completed by the last person it was assigned to you. on that time you will not get these issues. may be add this too

Mykle Mortenson
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
December 18, 2020

Yes, that is the issue I am running into. Many tickets I "touched" by adding labels/components and assigning but since I didn't make a comment and there was no status change, it is not captured in my query.

Daniel Ebers
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.
December 25, 2020

You are right. There are question to accomplish such from time to time in Community.
It is always "working towards the goal" but I think you are close to what you are looking for.

For the change in Assignees (Issues you assigned to a different individual) it think the following could work:

assignee changed by currentuser() after -8d

You can change the duration to look at as usual.

0 votes
Guilhem Dupuy
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.
December 18, 2020

Hi Mykle, 

Yes, you can do it by adding this to you query :

labels IS NOT Empty OR component IS NOT empty

 

Let me know if it helped,

Guilhem

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events