I am trying to create jira dashboard but required some jquery for following cases

nilesh.shah

Hello Team, 

I need your help to mitigate this request. 

The thing is I'm working on jira dashboard and required your help in jql syntax. 

How do i set the jql query in jira dashboard for following cases?

• First response time SLA breach
  
  =>Ticket resolution time with conditions such as:

• Not more than 4 hours
• Not more than 3 days
  
  =>SLA breach status notifications

• Notification through emails
• Notification through Slack
  
  
  =>A chart representing ticket conditions as per:

• Days open (new)
• Days after the latest comment
• Count of the latest comment

Vedant Kulkarni_Trundl

@nilesh.shah ,

First response time SLA breach

=>Ticket resolution time with conditions such as:

• Not more than 4 hours

• Not more than 3 days

you can use the SLA functions in filters such as "Time to first response" = breached()

=>SLA breach status notifications

• Notification through emails

• Notification through Slack

Form a JQL query like the above one and use it in the Automation Rule which satisfies the notification requirement. If you want custom email to be triggered then use Automation rules or else you can use email subscriptions for the filter which used the default Jira email template.

You may need the Slack admin's help to add Slack channel URLs in the Automation rules.

=>A chart representing ticket conditions as per:

• Days open (new)

• Days after the latest comment

• Count of the latest comment

JQL cannot perform calculations or manipulations, you need to play around with automation rules and embed smart rules in it. You might want to check this thread as well Solved: JQl for how many days since a ticket was created (atlassian.com)

You have a bunch of requirements, please test with the above solutions and come back here again with your inputs/issues.

 

Thanks