Trying to get a new filter to track any tickets I edit in any field within the last 26 hours

Question

I am wanting to locate any ticket I modify or edit within the last 26 hours. Whether I alter status, comment on someone else's ticket or create any new ones.

Currently I have the following:

project in (XYZ, ABC, ETC) AND (assignee = currentUser() AND updatedDate >= -26h) OR (updatedDate >= -26h AND Comment ~ "\"text\"" AND issuefunction in commented("by me.myself")) OR (reporter = currentuser() AND created >= 26h)

Right now it doesn't track comments or new tickets created but it's not returning any errors.

Trudy P Claspill · Answer

Hello @Andrew Kayle ,

Your post is tagged for Jira Cloud. Can you confirm for me that you are using Jira Cloud vs. Jira Server/Data Center? If you are using Jira Cloud your URL will be something like

https://<yourCompany>.atlassian.net

If your URL is something else, then you are using Jira Server or Data Center.

Are you executed the filter in the Filters > Advanced Issue Search screen or in the Apps > ScriptRunner Enhanced Search screen? According to this ScriptRunner advanced searching features can't be used in the built-in search screen.

I am not finding "commented" as a JQL keyword or function available from Adpatavist ScriptRunner for Jira Cloud though it was available in the version for Jira Server/Data Center.

Once I have confirmation about the hosting type of your Jira instance we can dig into this more.

Andrew Kayle · Answer

Thanks, fixed the missing -

I will believe it was added by Adaptavist but can confirm it works as I can use it on it's own. It's just not returning any results combined with a timeframe

Trudy P Claspill · Answer

Hello @Andrew Kayle

Welcome to the community.

Your last OR clause is intended to get the tickets you created in the past 26 hours, but you have forgotten to put the minus sign in front of the 26h criteria. So it is trying to find issues created 26 hours from now, which is of course impossible.

In your second clause you are using "issuefunction" which is not a native capability. Which app has been added to your Jira instance to provide issuefunction?