Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Where can I find time to first response/ time to resolution in HH:MM format in the database ? I

mmahmed
mmahmed December 30, 2019

I have joined customfield and customfieldvalue table to get SLA's for different issues from database.

But the Textvalue is in JSON format not the simple HH:MM format. Do i have to code the sql for JSON to display HH:MM format is that information resides in any table ?

Answer
Watch
Like Be the first to like this
533 views

1 answer

0 votes
Gonchik Tsymzhitov
Gonchik Tsymzhitov
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
August 6, 2020

Hi!

Used that snippet

https://gist.github.com/bertwagner/c29b805024be7156fc3253fac6956c26

Reply

Suggest an answer

Log in or Sign up to answer
Jira Service Desk
Jira Service Management
TAGS
AUG Leaders

Atlassian Community Events

    See all events