I need to revisit all of the issues I have worked on subsequent to a given date. Although I can see how to search for issues where I am the reproter or assignee, I also need to look for the following additional criteria
It's not clear to me how I can use JQL to specify the last two criteria. Can anyone help?
For the first one could you use the "WAS" operator - http://confluence.atlassian.com/display/JIRA/Advanced+Searching#AdvancedSearching-WAS, e.g. (Assignee WAS "Dan Horne" OR Reporter WAS "Dan Horne") BEFORE <DATE> ?
Andrew, but can't this possibly return back issues that weren't actually completed by the WAS assignee? For example, what if an issues was assigned to 3 different people and you are querying for the first person but in reality the task was completed by the last person it was assigned to?
the first answer is easy:
JQL-Query: assignee was username
the second question can only be answered with the participant field of the toolkit plugin. There you will be automatically added to the participants field if you enter a comment.
I tried the below SQL query and it gives data of all the issues and all the assignees that were ever assigned to an issue. Any change in the assignee for any issue is captured by below query:
p.pkey +'-'+cast(ji.issuenum as varchar(max)) as 'Issue Key',
(select first_name + ' ' +last_name from cwd_user where [user_name]=ASSIGNEE) as 'Current Assignee',
cast(ci.OLDSTRING as nvarchar(max)) as 'Old Assignee',
cast(ci.NEWSTRING as nvarchar(max)) as 'New Assignee'
join project p on p.id = ji.PROJECT
join changegroup cg on cg.issueid = ji.id
join changeitem ci on ci.groupid = cg.id and FIELD = 'assignee'
Anyone looking for the query would find this useful : )
your answers helped me a lot - I did not know about WAS and this can be a life saver :-)
My 2c on Dan's original question - since I use that too - for something like today tasks or in a few days back, I usually go to my profile page and look for the Activity Stream.
I know, this is not very elaborated or beautiful as a query - but it is very useful when you need to report your activities or check who is working - even when they are not the assignee...
Thank you all for the answers that helped me a lot!
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