Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL Syntax LastComment

Hi,

 

Would like to know the syntax for create an automatic rules that can switch ticket to closed with the lastComment

I've been create something like that :

status = "Waiting for customer"and LastComment (Auto) ~?

Don't really understant JQL Syntax if someone can help me

1 answer

1 accepted

1 vote
Answer accepted
Alexis Robert Community Leader Oct 28, 2020

Hi @Steven Borne , 

 

just to be sure that I understand what you want to do : this rule would copy the last comment and add it again to the issue, and closing it ?

 

Thanks, 

Alexis

Hi @Alexis Robert ,

First of all thanks for the reply.

What I want is a rule that automatically closes the ticket when they change status, like the ticket goes to "Waiting for customer" if no answear within 10 days, tickets will go to Closed states.

I have create something like this tell me what you think, don't rly know what mean ~ in JQL Syntax :(. (I'm actually rly bad in SQL)

Règle automat.png

Alexis Robert Community Leader Oct 29, 2020

Hi @Steven Borne ,

 

you can actually do this with Automation for Jira (it's an addon that's already included for free on every Cloud instance). The rule woulk look like this :

Screenshot 2020-10-29 at 10.29.26.png

 

Let me know if this helps,

 

--Alexis

@Alexis Robert

 

Thanks for the reply,

So they syntax "updated <= 3d" , mean that if no update of the ticket under 3 day the ticket will be closed ?

Alexis Robert Community Leader Oct 29, 2020

Hi, 

 

actually the correct JQL would be "updated <= -3d" to get tickets that have not been updated in the last 3 days.

Alexis Robert Community Leader Oct 29, 2020

You can also have a look at this article on JQL : https://www.twybee.com/blog/jql-reporting-dashboard/

Thank it's all good for me,

I juste have an another question.

Do you know if its possible to run a rules whitout the even "When".

Like all my tickets are under the states "Waiting xxx" without update under xxx will be moove to Closed states. In fact I would like to don't wait the states changement ...

 

Askrules.png

Alexis Robert Community Leader Oct 29, 2020

Hi, 

 

with automation for Jira you can choose a manual trigger, or have it triggered every day for example. This way it won't be based on your tickets status.

Like Steven Borne likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
FREE
PERMISSIONS LEVEL
Site Admin
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you