Report field for Ticket State Value

V5 Question
1

Is there a field for Ticket State Value in {REPORT TICKET DETAILS}?

It’s not mentioned anywhere, and I’ve tried TSV but doesn’t work.

I’m storing a time as the state value as HH:mm:ss (like 20:23:51) as what I’m doing I need to know the time the state changed but not as straightforward as just the duration / minutes I can get from Ticket State Duration TSD. I also want to have the exact time including seconds as I’m using the value elsewhere for a timer.

2

We don’t have unfortunately. I can add for next update.

3

Ok thanks. I need to get something working just now so will just do the report in SQL. Thankfully I’m using SQL Express 2017 so have JSON support to extract the state data :slight_smile: