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

[nilesh.shah]

Hello Team, 

Thank you for your response. I will play around with this automation. 

Meanwhile, could you please help me is there any possibility to check whether how many ticket were created in morning, in afternoon and in night as shift wise? 

Best Regards,

Nilesh Shah

[Vedant Kulkarni_Trundl]

@nilesh.shah , you can use the JQL something like this created > startOfDay() and created < "2022/011/25 8:00" . Create filters based on your shifts and use in gadgets such as Two Dimensional Filter or Created vs Resolved or even Recently Created Chart

[nilesh.shah]

Hello @Vedant Kulkarni_Trundl /Team, 

as per your query i am trying to create a query for ShiftWise (Morning, afternoon, night) but it's not working. 

;

the requirement is How many ticket were created in morning shift ( for e.x. between 4:30am to 1 pm) afternoon 12:30 pm to 9:00 pm or 1:30 to 10:00 pm and 8:30 pm to 5:00 am)

Can you please advise. 

project = PS AND issuetype = Support AND status in (Closed, "In Progress", New, Resolved, "Waiting for customer") AND created >= -30d OR created > startOfDay() and created < "2022/11/25 8:00" AND assignee in (6090142bd3538000685bd3f2, 6154266807ac3c0068bc23b7, 609bf3afc8c05a0069a9cd7b, 62c3f908ce5a604dbfb417ea, 61ef24f85a0988006b245090, 607c62211417e2006aa04816)

How do i set the timing (for example 8 hours) ?

Best Regards,

Nilesh Shah

[nilesh.shah]

Helllo @Vedant Kulkarni_Trundl /Team, 

I am trying to create a dashboard with shiftwise data. We had tried but unable to set the timing for shift wise. 

The requirement is how many tickets were created between 4:30 am to 1:00 pm and how many tickets were created between 12:30 pm to 9:00 pm and how many tickets were created between 8:30 pm to 5:00 am. 

We had tried below script but how do we set the timing by hour (Shiftwise). 

project = PS AND issuetype = Support AND status in (Closed, "In Progress", New, Resolved, "Waiting for customer") AND created >= -30d OR created > startOfDay() and created < "2022/11/25 8:00" AND assignee in (************, ***********, *******) 

Looking forward to hearing from you soon.

[nilesh.shah]

Hello @Vedant Kulkarni_Trundl ,Team,


I am just following up to check if you got some time to have a look at this request.

Best Regards,

Nilesh Shah

[Vedant Kulkarni_Trundl]

@nilesh.shah provide the date with the timestamp and create three filters separately

created >= "2022/11/28 04:30" and created <= "2022/11/28 12:30"

created >= "2022/11/28 12:30" and created <= "2022/11/28 20:30"

created >= "2022/11/28 20:30" and created <= "2022/11/28 04:30"

[nilesh.shah]

@Vedant Kulkarni_Trundl 

suppose i use created >= "2022/11/28 04:30" and created <= "2022/11/28 12:30"

and create three filters separately, I need to amend the changes every month in jql ? 

Also, if i create using your query then it's not giving actual correct data for shift wise.  

For ex. I tried with project = XYZ AND issuetype = Support AND created >= "2022/11/01 04:30" AND created <= "2022/11/30 13:00" AND assignee in (**, **, ***) it's giving me afternoon ticket data count instead of morning ticket data count

[nilesh.shah]

@Vedant Kulkarni_Trundl and Team,

Any thoughts ? 

[Vedant Kulkarni_Trundl]

@nilesh.shah , please try with created >= -30d and created >= startOfDay(3h) and created <= startOfDay(12h)

modify as per your shift and also check the system time if you are not getting the correct results.

May I know, which Jira flavor are you using? Jira Software/ Service Management /Work Management?

[nilesh.shah]

How do i calculte the timing @Vedant Kulkarni_Trundl ? 

I have checked the system time and it's correct. 

We are using service management. This query doesn't show the accurate data. 

would it be possible for you to have short meeting?  so, that i can explain what we are trying to accomplish here.