Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

Logistics Execution > Setup > Constraints > Constraints

Constraints, at their very core, are user-defined queries that can be applied to a number of objects within the program.

You can use constraints to filter and prohibit the pairing and assignment of assets, workers, positions, and orders during activity template creation and activity execution.

Constraints can also be used to ensure that a logistics order has the required data necessary to execute an activity under an operation.

Note

Be cautious regarding the use of multiple constraints over large lists of assets. While it is possible to create very complicated scenarios of interrelated constraints, performance challenges may come into play if large amounts of data are also being constrained.


Currently, any number of constraints may be applied to:

  • Logistics Types
  • Activity Masters
  • Activity Templates
  • Logistics Addresses
  • Item Classifications

Similar to logistics type attributes, constraints follow a hierarchy, and the parent type's constraints are applied to the child type.

Header Section

FIELDDESCRIPTION
ValidityIdentifies whether the constraint is valid.
Constraint IDName of the constraint.
DescriptionDescription of what the constraint accomplishes.
Constraint Type

Defines which logistics type is being constrained against and therefore limits which tables are selected within the related constraint query: 

  • Asset
  • Worker
  • Position
  • Logistics Order
  • Handling Unit
  • Logistics Line
Logistics Type

Defines which logistics type is being constrained.

Note

Constraint Type + Logistics Type = evaluated object

Constraint Restriction

Controls whether a constraint failure stops the attempted process or a warning is issued.

The process to stop/warn is configured in the sections below.

Expression Section

This section functions as the logic behind the constraint. 


Set up a constraint expression to restrict and filter data against the selected logistics type.

Each new line within this section represents another clause in the expression. Multi-lined constraints are joined by the conjunctions AND or OR.

The rules and order of operations for crafting an expression mirrors that of SQL or a generic AX query build. Unlike AX build queries, constraints allow the use of unions, enabling you to create complex statements otherwise unavailable in AX.

Note

When creating a constraint, the operator of the first line should be WHERE. For all succeeding lines, AND or OR should be selected, depending on the query logic. AND requires both statements to return as true while OR only requires one statement or the other to return as true.



Grouping

Use grouping to create complex union queries, similar to SQL.

Grouping is visually expressed through parentheses.

Example

Some shipments require refrigeration (e.g., perishable food) and often require extra visibility to ensure safe transit.

The constraint might require either a Reefer trailer (i.e., refrigerator) or an asset with both a refrigerator and temperature control mechanism. The written logic would be written as:

WHERE Asset Description == Reefer OR (Refrigerator == Yes AND Temperature Controlled == Yes)


Operations Section

This section displays a list of operations that use the constraint.

Used By Section

This section displays constrained logistics types.


  • No labels