What issues have a I worked on?

[Dan Horne]

Hi

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

• I have ever been an assignee i.e. I do not have to be the current assignee
• I have ever been a comment author

It's not clear to me how I can use JQL to specify the last two criteria. Can anyone help?

Thanks

[Andrew Frayling · Accepted solution]

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.

[Dan Horne]

Thanks - I think this would work for me, but I don't seem to have the "WAS" function. Is it quite new? I'm using JIRA 4.2

[Jobin Kuruvilla [Adaptavist]]

WAS is available only from JIRA 4.4 - very good feature!

[Andrew Frayling]

Sorry, I checked 5.0, 4.4 and 4.3 which all have "WAS", but it's not in 4.2. I'll have another think to see if it's possible to do something similar in 4.2

[Umer Arif]

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?

[Thomas Schlegel]

Hi Dan,

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.

Best regards

Thomas

[Renjith Pillai]

May be your activity stream, (in your profile page) also helps to quickly find what all actions you have done.

[Eduardo E_ Wronowski]

Hello all, 

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!

Edu Wronowski

[Prasanth Mukundan]

assignee was username2bechecked

..should do the job 

[Neha Pal]

Hi,

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:

select distinct
p.pkey +'-'+cast(ji.issuenum as varchar(max)) as 'Issue Key',
ji.SUMMARY,
(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'
from
jiraissue ji
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 : )

[Jobin Kuruvilla [Adaptavist]]

Have a look at the Participants field in Toolkit plugin. Once the field is added, you can search based on it.

[Dan Horne]

Thanks - I think that this would work, but I dont seem to have the "WAS" operation. I'm usig Jira 4.2 - is it a new feature?