I’m creating a process for reprinting credit card signature slips. This means I need to print a slip per payment.
Current Print Template
[LAYOUT]
<T>Receipt
<L00>Date:{DOCUMENT DATE}
<L00>Time:{DOCUMENT TIME}
<L00>{DESCRIPTION}
<F>-
<F>
{REPORT SQL DETAILS:SELECT
jsonData.[pdauth_code]
,jsonData.[pdCardHolderName]
,jsonData.[pdCardBrand]
,[Amount]
,[Date]
FROM [Payments] p
CROSS APPLY OPENJSON(p.[PaymentData])
-- this WITH portion allows explicit definition of the schema JSON Keys for output
-- and gives references to the columns/fields above in the SELECT portion
-- we can also use these as filters in the WHERE clause below
WITH (
pdTransactionID varchar(1000) '$.TransactionID'
,pdauth_code varchar(1000) '$.auth_code'
,pdCardHolderName varchar(1000) '$.CardHolderName'
,pdCardBrand varchar(1000) '$.CardBrand'
) jsonData
WHERE 1=1
AND [PaymentData]!=''
AND [ID]='@1'
ORDER BY [Date]
;$KEY
:F.Date
,F.pdauth_code
,F.pdCardHolderName
,F.pdCardBrand
,F.Amount::
<L00>PID\: $KEY
<L00>DATE\: {0}
<L00>AUTH\: {1}
<L00>NAME\: {2}
<L00>CARD\: {3}
<L00>AMOUNT\: {4}}
Automation Command Rule
{REPORT SQL DETAILS:SELECT [Id] FROM [Payments] p WHERE [TicketId]=@1;{TICKET ID}:F.Id::$KEY={0},}
Value Looped Rule
