Jira Automation Rule to get all comments for all issues on a project that occurred in the last day?

[Cash Coyne]

I need an Automation Rule in Jira Cloud to get all comments for all issues on a project that occurred in the last day.

I can see how to get all comments for one issue, but not how to get all comments that occurred in the last day.

Anyone have any suggestions on that?

[Trudy Claspill]

Hello @Cash Coyne 

Jira does not have a native function to search for issues (or comments) based on the date the comment was made. There are third party apps that extends JQL capabilities for that.

Do you have or are you willing to consider a third party app to extend JQL capabilities for this?

Otherwise I think the only way to do this would be to retrieve all the issues based on their last Updated timestamp, then for each one search through their comments to find if any were made in the last day.

[Cash Coyne]

I anticipated that I'd have to search thru the comments to examine the date, but I couldn't figure out how to do that, so that's where I'm stuck.

[Trudy Claspill]

I haven't quite figured it out either.

I tried using a Schedule trigger to retrieve the issues, and then a For Each to step through the comments and print their creation dates. I thought this would step through the comments of each issue, printing out the creation dates for the comments of each issue in one log entry, the the comment creation dates for the next issue in another log entry and so on, but it printed all the comment creation dates in one log entry.

[Med FutureXAI]

@Cash Coyne  @Trudy Claspill   Have you solved this problem?

[Trudy Claspill]

@Med FutureXAI 

I stopped trying to figure out a solution many, many months ago.

[Med FutureXAI]

What is the solution for this?

[Trudy Claspill]

I don't have a solution. As I said, I stopped trying to figure it out.

[Cash Coyne]

@Med FutureXAIunfortunately, I have not come up with a solution