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!!
I would suggest to add Activity Stream gadget to your dashboard and specify your own username.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 >= stardOfDay() and participants = currentUser()' ")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.