Jira Database table which have SLA HOLIDAY Calender details

[Prashant Chaurasia]

Hi ,

We have a requirement to create a Jira Report which should calculate and show "#Business days in Open status" of a particular issues.
To calculate business days we need the information about Jira database tables which have the information about HOLIDAY calendar setup for the particular projects.
Kindly help and provide the database tables along with query to which should show Holiday information for a project and let me know if you need further info on this.

Thanks in advance.

Regards,

Prashant

[Mariana_Pryshliak_Saasjet · Accepted solution]

Hello @Prashant Chaurasia 

As an alternative, you can try Time between Statuses.  You should set up a calendar and get ready generated data about  Business days in Open status. 

 Just choose an "Open" status as Start\ Stop conditions for a timer and that's all. 

I hope it helps

Best regards, Mariana

[Gökçe Gürsel {Appfire}]

Hi @Prashant Chaurasia ,

You can check out the Service Desk API here: https://docs.atlassian.com/jira-servicedesk/4.4.2/

Best,

Gökçe