Monitor resolved tickets for updates.

I currently use JIRA for call center ticketing. We resolve issues but sometimes the customer sends in an email after the ticket is resolved. I need to monitor tickets for this so we do not miss an issue. I am currently using an advance search to locate these tickets, but the script seems in affective. I wonder if anyone might have a better script I can use or know why the script I use does not pull every ticket that has been updated after being resolved. 

 

My script:

project = CUSTOMER AND issueFunction in dateCompare("", "resolutionDate < lastCommented") ORDER BY updated DESC

 

So I am looking at my project, and then asking for a comparison between the resolution date and the last commented time, and a sort after that. I know I am missing something or that a better or different way exists to find all the tickets that get updated after we resolve them.

 

Any ideas and help is much appreciated.

Thanks.

1 answer

1 accepted

Hi Jason,

I've seen cases where in JQL function if you don't type the field name absolutely the same it won't work fine - even the capitalization. I have a similar example that works for me.

One additional note: Each time a comment is posted or any other change the "updated" date is being changed and for me this is more robust way to detect changes that lastCommented.

Cheers,

Peter T

Peter,

Dude, thank you! Changing to "updated" is exactly what i needed. I have been hitting my head on this for a while now.

 

Much appreciated,

 

  • Jason

Glad to be helpful. If you hit anymore issues write here or in case you don't get quick response at support@botronsoft.com, we are quite experienced with call center setup for JIRA.

Cheers,
Peter

Suggest an answer

Log in or Join to answer
Community showcase
Emilee Spencer
Published 8 hours ago in Marketplace Apps

Marketplace Spotlight: DeepAffects

Hello Atlassian Community! My name is Emilee, and I’m a Product Marketing Manager for the Marketplace team. Starting with this post, I'm kicking off a monthly series of Spotlights to highlight Ma...

30 views 0 3
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot