The Custom values per order query list custom values used in a defined single order.
The Custom values per order query are typically generated in the order as an Order report. Generating the report manually is not recommended, use the Order filter with OrderID to ensure the correct order is generated.
Contents
Filters
|
Filter |
Description |
Mandatory |
|---|---|---|
|
Order |
Filters on the Order ID. The Order ID can be found in the Classic screens when on the Order page, in the browser address bar after ‘Orderid=’, e.g. |
YES |
Data provider settings
There are no data provider settings for this query.
Columns
|
Name |
Description |
Example |
|---|---|---|
|
Custom code |
Custom property (code) name. See 'Name' field in Custom values (Administration). |
DeIcing CAT |
|
Custom code remarks |
Custom value remarks. See 'Remarks' field in Custom values (Administration). |
CAT 2 |
|
Custom value |
Current custom value in order set for the custom property. See 'Value' field in Custom values (Administration). |
2 |
|
Custom value display name |
Display name for the current set custom value. Format: Custom code | Custom Value |
DeIcing CAT | 2 |
|
Order ID |
Order’s unique ID in GUID format. |
269f2e77-fcef-4653-99b6-495a717c15f0 |
|
QRCode |
Allows generating a QR code using data from other columns, see How to add a QR code to a report. Example shown:
|
Comments
0 comments
Please sign in to leave a comment.