{ORDER ID} works in [ORDERS] not in [ORDER TAGS]

V5 Question
1

This maybe is just one of those things that can’t be solved, but I was wondering if anyone can give me some tips on how I could achieve what I am looking for…

Consider the following template (with many bits removed)

[LAYOUT]
<C>Dive shop
{ORDERS}
<C>Thanks, bye.

[ORDERS]
<L>{PRODUCT NAME} ={ORDER ID} with {REPORT ORDER DETAILS:OT.Equipment:O.Id={ORDER ID}}
{ORDER TAGS}

[ORDER TAGS]
<L> * {ORDER TAG NAME} ={ORDER ID} ({REPORT ORDER DETAILS:OT.Equipment:O.Id={ORDER ID}})

The output from this that I am expecting is:
I know the repeating of just one order tag seems weird, this is not ultimately what I am going for, but I to achieve my end goal, I at least need this to work first

Dive shop
Playa del Carmen =123 with full
 * Extra tank =123 (full)
 * Small fins =123 (full)
 * Wants to see shark =123 (full)
Thanks, bye

However what I actually see is:

Dive shop
Playa del Carmen =123 with full
 * Extra tank =123 ()
 * Small fins =123 ()
 * Wants to see shark =123 ()
Thanks, bye

So as you can see the report tag works correctly in the [ORDERS] section, but not in the [ORDER TAGS] section (even though the {ORDER ID} tag does work correctly here). Interestingly if I hard code an order ID in to the REPORT tag then it does return the expected data. So I am wondering if the problem is just the way in which the {ORDER ID} tag is parsed inside the {REPORT} tag inside the {ORDER TAGS} inside the {ORDERS} (there are a lot of “insides” there and I am wondering if that could be the issue?

2

It’s not meant to work in Order tags section.

3

OK. I guess I will have to do everything in JS

4

You can always use REPORT SQL DETAILS tag with some JSON if your using latest SQL Express

7

Yep, that’s essentially what I am doing within the JS… I just prefer to lock a bunch of that code away in a {CALL:} rather than the ticket template getting a little messy.

I have finished what I was trying to do now…
Essentially I have two ticket tag groups “Equipment” and “Equipment discounts”… The Equipment tag charges our customers for equipment rental and makes sure that we have specific pieces of equipment reserved for them. “Equipment discounts” refunds the charge for the equipment, but doesn’t affect the equipment reservation logic.

Instead of showing:

Equipment                  15.00
Repeat customer discount  -15.00

I just wanted to show the equipment line once, with a strikethrough if the equipmen has been discounted.

I couldn’t work out how to do this inside {ORDER TAGS} because when processing the tag for Equipment, I wouldn’t have the ability to read the value of any associated Equipment discount.

The end result it this, which I think looks nice:
image