Custom values per order query

The Custom values per order query is 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

Filter

Description

Mandatory

Order

Filters on the Order ID. The Order ID can be found in the Classic screens when on 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

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 https://amsterdam.jira.com/wiki/spaces/MAN/pages/2445049868.

Example shown:

  • Settings: ShowBarCodeOnEveryRow=true;

  • Columns: Custom value display name