Hey all
I cant seem to find it and completely forgot about it.
Is there a {SETTING:IsClosed} or something similar for the ticket?
Hey all
I cant seem to find it and completely forgot about it.
Is there a {SETTING:IsClosed} or something similar for the ticket?
No this is part of the ticket table it is a column. It is not a setting. That said I think we have a printer tag for it I do not remember it off hand.
No idea, I looked at Printer tags and cant find anything on the forum but for some reason I think Ive seen it somewhere at some point.
I decided to just use SQL query.
Since its stored as Bit in the database, the query will return True
or False
.
{REPORT SQL DETAILS:SELECT IsClosed FROM Tickets T WHERE t.Id={TICKET ID}:F.IsClosed::{0}}
Basically what I am doing really, is just print final invoice when everything is settled - remaining total is 0 but IsClosed=False. And so it doesn’t print it every time you close any paid ticket.