Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

'No Client update from Support team past 3 days' jQuery required

Edited

‘No Client update from Support team past 3 days’ I would expect jQuery for the  below logic

  1. No Update on Incidents / Service Request
  2. No Update on Change Requests

 

For both you should check OPEN client tickets with status not equal to WAITING FOR CUSTOMER not equal to RESOLVED without any external updates past 3 days.

 

Is this possible?

3 answers

1 accepted

2 votes
Answer accepted

Hi @kotha Eswar rao,

If I understand your question correctly, you should be able to retrieve those tickets using the following JQL filter:

Issuetype in (Incident, "Change Request", "Service Request") AND
Resolution = Unresolved AND Status != "Waiting for Customer" AND Updated <= -3d

 Hope this helps!

Thanks @Walter Buggenhout _ACA IT_ for providing the J query , But the issue here the above query will show the tickets which were not updated <=-3 days and also i need the external comments not updated to customer for past 3 days

 

The above query is showing the combination of tickets with internal /external comments not updated for past 3 days

is there any query specifically for the external comments not updated for past 3 days?

 

Regards

Eshwar

Hi @kotha Eswar rao ,

Comments all end up in the same comments field and Jira out of the box does not support searching for who commented.

However, I think the following workaround will suit your needs: Automation allows you to transition an issue between Waiting for Support and Waiting for Customer statuses based on who comments (Automation lets you check if the comment was entered by an agent or a customer and also if the comment was public or private). If you make sure your issue transitions to an internal status when a customer comments, and back to the customer in the other scenario, the query I shared above will always show you the issues that are sitting around for more than 3 days waiting for support.

Like kotha Eswar rao likes this

Hi @kotha Eswar rao ,

An article about how to do it with our app can help. Chek it out here.

0 votes
Gaurav Community Leader Nov 09, 2021

Hello @kotha Eswar rao 

For identifying the external comment, there is a smart value available. Checking if the smart value '{{comment.internal}}' is false would help identify the external comments.

Hello @Gaurav 

I am receiving the error while adding the above function ( {{comment.internal}}) in J Query

could you please assist further

Below is updated query i am using to find the external comments not updated for 3 days

 

updatedDate<= "-3d" AND type in (Incident, "Service Request") AND status not in ("Waiting for customer", Resolved, Closed, Declined) AND {{comment.internal}}

 

 

Regards

Eshwar

Gaurav Community Leader Nov 09, 2021

Hello @kotha Eswar rao 

As this is a smart value, I have not used it in JQLs but in Automation. I would suggest you please try it as ('{{comment.internal}}' is 'false').

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Jira Service Management

JSM Jira Automation: How to Send SLA Breached Notifications

Hi Everyone, In   this tutorial,  we will show you how you can monitor an SLA, and send notifications before or after the SLA has been breached.   SLA Threshold Trigger The SLA t...

655 views 5 12
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