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:

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

List of Distance Transit Time Overrides (Employees)