It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Issues I worked Today

sangram Ghatge Apr 23, 2014

Hi All,

I need a Jira Query where I can get all the issues on which I worked today. I need this from a Testers perspective. This will help me to analyse No of issues on which I worked today and what kind of work I have done today.

E.g. Issues I commented today, Issues I created today, Issues for which I changed status today. In short I need a query for "any issue updated by me today".

Thanks in Advance!!

3 answers

1 accepted

0 votes
Answer accepted
Andris Grīnbergs Apr 23, 2014

I would suggest to add Activity Stream gadget to your dashboard and specify your own username.

sangram Ghatge Apr 23, 2014

Hi Andris,

Thanks for the help. This Works good.

Actually I am prefererng a Query where I can get the Issue list and can export it.

But if nothing other works I think its good enough. Many Thanks for this.

0 votes
Felipe Kraemer Atlassian Team Apr 23, 2014

Hi Sangram,

I am wondering if this Advanced Query could help you:

updated >= startOfDay() AND participants = <your_username>

This is not ideal, though, because although you're a participant of the issue, it doesn't mean it was you who updated the issue in that specific day. Maybe you've updated in the issue in previous days. A participant is someone who created the issue, commented on it, updated anything in the issue, voted on it, or is watching it.

I don't think there is a query that matches exactly what you need.

Kind regards,
Felipe Kraemer
Atlassian Support

sangram Ghatge Apr 23, 2014

Hi Felipe,

Thanks for the help but this query also gives issues If I have worked on them in past and someone else has worked on it today.

e.g I have commentened 2 days back, so I am participent in that issue and someone other has commented it on today then its updated today. So such issues are also displayed in this query.

0 votes
Pablo Beltran Nov 21, 2015

SQL for JIRA is able to refine the Felipe's JQL query:


 

issue in sql("
select distinct i.key
from issueworklogs w inner join issues i on w.issueid = i.id
where i.jql='updated &gt;= stardOfDay() and participants = currentUser()'
")

 

 

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Posted in United States

Topic Tuesday: Agile

Another week, another Topic Tuesday!  Agile has been on my mind a lot lately because I've seen good implementations and bad implementations, but now as a Jira admin it matters more to me whether...

17 views 0 0
View post

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you