How can I query issues in which I commented?

philippos April 1, 2015

I want to query JIRA issues in which:

  • I commented after 1-MAR 

I use the following JQL query which is not what I want.

project = MyProject AND Participants = MyUser AND updated >= "2015/03/01" 

My query querries:

  • Issues updated after 1-MAR 
  • In the list of participants I was included

This is not correct since I may have commented 1 year ago and the issue was updated on 10-MAR.

What I need is a query where MY comment was between 1-MAR and 30-MAR.

Thanks

P.S. Note that I cannot install plug-ins, I need a JQL query.

4 answers

1 accepted

2 votes
Answer accepted
Silviu Burcea
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.
April 1, 2015

I just had another look in the JQL documentation and this is not possible without using a plugin.

Udo Brand
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.
April 2, 2015

Correct, without a plugin this is not possible

2 votes
SanaS
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.
April 1, 2015
Silviu Burcea
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.
April 2, 2015

P.S. Note that I cannot install plug-ins, I need a JQL query.

1 vote
John Bayne
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.
April 1, 2015

Agreed.

The participants field created with the JIRA Toolkit Plugin is a help with this while not being a full solution.

Silviu Burcea
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.
April 2, 2015

P.S. Note that I cannot install plug-ins, I need a JQL query.

0 votes
philippos April 2, 2015

Actually I can use the query you proposed! issueFunction is an available in to our system. Many thanks

Suggest an answer

Log in or Sign up to answer