I am looking for the time a bill was printed in the database, I can not seem to find it.
I am able to fine the time an order started, time of payment and the end of the order time.
I have searched around and came across the below link. However, this shows the bill printed time in the report, which leads me to believe the value is stored somewhere.
I would appreciate any help, direction or indication as to where I could look for this information.
There is no column for bill print date.
Here are some ideas:
- Set a ticket state or ticket tag when pill is printed
- use ticket log
I went with your idea
I have come across another query and unsure as to whether I can ask it here since it relates to the the ticket log suggestion or if I should post another topic.
I have the below JSON in the TicketLog column, however, I don’t know what format the date is in and I can’t seem to find any documentation on how the date is stored in the JSON.
Any ideas or links I can look at?
The DateTime format is timestamp with offset.
There’s is an action “Display Ticket Log” that you can use in a rule triggered by an automation command from a button on the ticket screen and it will show the ticket log.
1617611952126 (milliseconds from 01 Jan 1970) translates to 5 April 2021 08:39:12 GMT or 5 April 2021 10:39:12 your local time (the +0200 is the offset - so +2 hours from GMT).
You can also write reports on ticket log data.