Ticket Id from Ticket Number - What am I missing

V5 Question
1

Trying to get ticket ID for a load ticket action is a clean tidy report but cant get it right.
Ticket ID 1058 is ticket number 14…

Tried;
{REPORT TICKET DETAILS:T.Id:(T.TicketNumber=14)}
{REPORT TICKET DETAILS:T.Id:T.TicketNumber=14}
and a few others but cant get it to work.

2

Where are you using that? What event?

3

Currently testing in reports template but will be on numberpad entered from scanning barcode of ticket number on receipt.

4

So why not just put Ticket Id on receipt Barcode instead?

5

Because ticket id not available untill ticket closing :slight_smile:

6

Or ticket save. So your printing before close?

7

And on print bill?? :-/

8

Could put save ticket action just before the print command in that rule.

9

is save same as submit? will it send to kitchen?

10

No worries, will use a script :slight_smile:

function getTicketId(inputTicketNumber) {
	var ticketIdQry = "SELECT [Id] FROM [Tickets] WHERE [TicketNumber] = '"+inputTicketNumber+"'";
	var ticketIdLookup = sql.Query(ticketIdQry).First;
	return ticketIdLookup;
}
11

No its not. It does write to database but its not triggering the rules that sent to kitchen.

1 Like
12

So cancel still works?

13

No it would not. Its hard to tell what your doing. So your printing tickets… but you might cancel an order even if its printed? Wouldnt you only want to print for submitted?

14

Its for a system for claiming unused loyalty points, there will be a barcode on the receipt and using ticket id obviously gives an error on printing if not saved/submitted and didnt want to create a second template.