JQL of reporter commented

[Marzi Goodarzian]

Hi

I want to see issues list that more than four weeks, the reporter has not made any comment, or the reporter has not done anything in his issue (may be assignee has comment in this  4 weeks)

I used this JQL but has error:

"updated <= -4w and  issueFunction in commented ( inGroups (x,y,z))

x,y,z are groups of project member(reporters of project are  in these groups).

Is there a function for comment made by reporter?

thanks

[Marzi Goodarzian]

Hi

I use JCT Group Member Last Comment field, this show last reporter comment and Date of comment(in a field), but I want to use "commentDate" of this field.

How can this be done?

thanks

JCT Group Member Last Comment field shown below:

[Manon Soubies-Camy]

Hello @Marzi Goodarzian,

Since you're using Jira Service Desk, I guess reporters usually are customers. If so, you could try the following JQL (I can't try it out right now so maybe you'll have to make some adjustments):

issueFunction in lastComment("inrole Customers before -4d")

To get the date of the last reporter comment, I can't think of anything else than a dedicated custom field (scripted field/listener).

Hope this helps!

- Manon

[Marzi Goodarzian]

Hi

thanks @Manon Soubies-Camy

You understood the meaning of my order.

this JQL is right for  Last comment, so as this gives information of last comment and

dont get my target.

:(

[Alana Fernando]

hi @Marzi Goodarzian,

Try below JQL. From Advance search you can get the ticket list that relevant to below query. 

issueFunction in commented("before -4w by <user name>")

issueFunction in commented("before -4w by alana")

Reference: 

Script JQL Functions :Comments

hope this helps  😊 

[Marzi Goodarzian]

Hi

thanks @Alana Fernando

your jql is correct about one reporter, but I want to get for all reporters, a comprehensive report from last comment date of reporters in a project.

Better to say:

last commented date of reporters in a project.

thanks

[Alana Fernando]

Sorry @Marzi Goodarzian,

to the best of my knowledge I am not sure it is possible to extract issues that has comments by Reporter. Still you can search for user groups and roles though. 

[Marzi Goodarzian]

Hi

How can I get last commented date of reporter??

Thanks for the guidance.