Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,361,677
Community Members
 
Community Events
168
Community Groups

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

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. 

1 answer

0 votes

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?

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

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.

Suggest an answer

Log in or Sign up to answer