nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Find comments added on specific date by specific user

Peter McAndrew

Hi there,

I'm trying to create a filter in JIRA Cloud which would return a list of issues where user x has added a comment on a specific date.

I've tried using market place apps but they don't seem to offer any solutions, the latest one I've tried is scriptrunner enhanced search.

This is my query : commentedby = 'user x' and commentedon = '2021-07-23'

The result I get it all issues with a comment added on 23rd July and user x has commented (at any point in the past)

The result I want is only those issues where user x has commented on 23rd July.

Would be great to hear any suggestions about how to achieve this!

Accepted answers

All comments

Uday Kiran Bhaviri

I think you can try the following JQL, if you have ScriptRunner installed... because here I have used issueFunction

issueFunction in commented("on 2021-07-23 by userid")

Girish_Shenoy

complete details is available at URL https://scriptrunner.adaptavist.com/4.1.3.9/jira/jql-functions.html#_hascomments

Vikrant Yadav

Hi @Peter McAndrew This is not possible via standard jira. But with the help of plug-ins like Script Runnner and JQL Search Extensions for Jira.. you will be able to do this.

for script runner :-

commentedOn (‘2021-07-23’) AND commentedBy = ‘jsmith’

https://scriptrunner-docs.connect.adaptavist.com/jiracloud/jql-aliases.html

for jql search extension :-

commentedOnDate = now() AND commentedByUser = “Vikrant Yadav”

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/3375124

Thanks

Peter McAndrew

This doesn't work for me, I get an error

Function 'commented' does not exist

I believe this is because that function doesn't exist for the Cloud version of script runner?

Peter McAndrew

I think these docs are for the DC or server version? I get 'Function 'commented' does not exist'

I tried this query:

issueFunction in commented("after -4w by jbloggs")

Uday Kiran Bhaviri

oh okay then we can use the below one

commentedOn = '2021-07-23' AND commentedBy = 'userid'

Girish_Shenoy

@Peter McAndrew

the expression works only if you have scriptrunner add-on. see the image below.

Vikrant Yadav

@Peter McAndrew kindly use below query :-

commentedOn (‘2021-07-23’) AND commentedBy = ‘jsmith’

Peter McAndrew

Thanks @Vikrant Yadav but this is the query i'm already using and it doesn't return what im looking for:

issues where jsmith has commented on 23rd July

instead it returns issues that recieved a comment on 23rd July and where jsmith has commented on any day.

Vikrant Yadav

Hi @Peter McAndrew If you recently installed ScriptRunner, FIrst you have do the initial synchronization on the JQL Keywords Sync page found in the Add-ons Administration section of Jira. Once Sync is complete then search for issues.

KIndly check this document :- https://scriptrunner-docs.connect.adaptavist.com/jiracloud/jql-aliases.html

JQL Search.PNG

Kate Kabir

Hi @Peter McAndrew

Thank you for your question.

In regards to your enquiry, the keywords work is commentedBy returns issues a user has commented on and commentedOn returns issues where a comment was added on a certain date and the returned value that you are seeing is as expected. This is how the keywords work in the cloud environment.

At the moment, we do not have a way to search just for issues commented by a specific user in a timeframe yet.

Furthermore, the documentation link mentioned by other users is for Server. You may kindly refer here for the ScriptRunner Enhanced Search for Cloud documentation.

I hope this helps.

Thank you, Peter

Kind Regards

Kate

Peter McAndrew

Thanks Kate, the answer is helpful and I appreciate the support you gave on the ticket I opened with Scriptrunner support.

I'm still hoping that someone else in the community will have another idea about how to achieve the result I'm after even if you don't support it in your cloud app yet!

Peter

Labutte Jerome Mackenzee

I'm facing the same issue, did anyone got a solution?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud