Use Multi-Selection when Searching for DTTOs

Each distance / transit time override (DTTO) in Transportation Manager will refer to two locations. The DTTO could be used when the distance and/or transit time from Location 1 to Location 2 is required as well as when the distance / transit time from Location 2 to Location 1 is required.

When multiple values are specified for one of the Location ID fields on the Search for Distance / Transit Time Overrides page and no value is provided for the other Location ID field, the query will return entries where Location 1 in the DTTO table is equal to any of the multiple values specified and Location 2 equal to any value; the query will also return entries with Location 2 in the DTTO table equal to any of the multiple values specified and Location 1 equal to any value.

When multiple values are specified in both Location ID fields on the search page, the query will return entries with Location 1 in the table equal to one of the values in the first group and Location 2 in the table equal to one of the values in the second group, and entries with Location 2 equal to one of the values in the first group and Location 1 equal to one of the values in the second group.

For example, if Location A, B is the first Location ID field and Location C, D are supplied for the second Location ID field, the system will return the following overrides, if they exist:

  • A-C
  • A-D
  • B-C
  • B-D
  • C-A
  • C-B
  • D-A
  • D-B

The system will not interpret the input as a request for (A, C) as a pair and (B, D) as a pair based on a value’s position in the input.

The same approach will apply to Country, State/Province, and City.

This behavior will not be impacted by the value of global setting “Distinct Distances and Transit Times by Direction” flag in the global settings.

See Also