Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

Issue on my project with CRON Expression and JQPL

Hi all,

I have a problem with my project.

I need to create an automation that close the issue automaticly when the "Planned end date" has been passed. I give an example: "if the planned end date is 16/05/2021 6PM, the issue must closed tonight at 11.59PM."

Until now, tickets have been closed on the same day as the ticket was opened.

 

Can you help me?

BR,

2 answers

I add a screen with the automation.Automation.JPG

0 votes
John Funk Community Leader May 16, 2021

Hi Giuseppe - so what is not working with it now? 

Hi, the rule works only that the ticket closes on the day of creation and not the day set in the PLANNED END DATE field.

John Funk Community Leader May 16, 2021

Just remember that the date/time for the cron is UTC - so you might have to adjust the timing based on your time zone. 

Hi,

yes, what happens is that the ticket closes on the day of opening and not when the "Planned End Date" occurs.

Do you have any other suggestions?

John Funk Community Leader May 17, 2021

What time zone are you located in? 

And at what time would you like the rule to fire local time? 

Hi, the Time zone is CET.

I would like to fire the rule at 23.59 local time (not every day but on the day reported in the  Customer Field Planned End Date).

BR,

John Funk Community Leader May 17, 2021

So, is custom field 10081 the planned end date?

John Funk Community Leader May 17, 2021

So it runs a one minute to midnight tonight - but it would process tickets for today? Or tomorrow? Or yesterday? 

Hi,

I would like to set the rule that the ticket must close automatically at 11.59 pm on the day set in the custom field "Planned end time".

The set rule now closes the ticket on the same day as the ticket is created.

BR,

John Funk Community Leader May 21, 2021

Ah, now that I think about it, I believe it is your query. try doing the Planned end date as < now()

Hi, can you give me the correct syntax? Just to make no mistake.

BR,

John Funk Community Leader May 21, 2021

Just update exactly what you have already except change out

> startOfDay()  

with 

< now()

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Service Management

JSM June Challenge #2: Share how your business teams became ITSM rockstars

For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...

248 views 7 7
Read article

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