Lookup Windows
Lookup Windows Overview
Many windows in the Ditat TMS will give you the option to either type in data Id's manually or use the navigator field Search button to open a lookup window. This lookup window allows users to search through all existing records using different parameters. Users also have the option of using the Quick Search option that opens a new window with records that contain the entered characters.
You can perform a Quick Search by pressing ENTER when the cursor is inside the lookup text field. This will open a window like the one below.
This window will display all the records that contain the entered characters.
You can edit the filter criteria and click the ENTER button to search for records that include text specified.
The matched text will be displayed in bold.
Pressing the DOWN key will move the cursor to the grid.
The field you are searching through can be changed using the drop-down menu.
You can navigate through the matching records with the UP and DOWN arrow keys and select a record by clicking the ENTER key.
These two icons are used to designate that you can use the Search functionality for that blank:
Icon | Description |
 | The lighthouse icon indicates search functionality throughout Ditat TMS |
 | The looking glass icon indicates search functionality within records. |
The lighthouse icon indicates a Navigator field. Navigator fields can be used in 3 different ways:
Type in the exact name and use Tab on the keyboard to Add a new record or to open an existing one.
Type in part of the name and use Enter to do a filtered search.
Click on the Lighthouse icon to open the Lookup window to search for the record.
Lookup Window Toolbar
Additional filters can be added using the Plus sign or removed using the X symbol. You may also combine search filters for better results.
Button | Description |
Cancel & Exit | Does not enter the entry you have selected from the lookup results into the data entry form. Closes the lookup window. |
OK | After you have selected an entry from the lookup results, pressing this button will enter its Id into the space of the data entry form. |
Refresh | Refreshes the records in the lookup results based on the entered parameters. To learn more about entering parameters, read below. |
Reset Filter | Use this button to reset all search filters to the default starting position. |
Export | Exports the records in the lookup results to a .csv file on your computer. |
Lookup Windows will remember your customized searches and save them for the next use. If you want to clear these out, you can either delete manually or click the Reset Filter button to start fresh
Using Parameters to Search
The lookup window gives you many options by which it can sort the lookup results.
Select what you are looking for from the drop-down menu. If you select all, the space to the right of the parameter will disappear.
Enter the characters for which you are searching into the space to the right of the parameter.
You can sort your lookup results using multiple different parameters.
Click the Refresh button to see the results of the lookup parameters you entered.
Example
In the image above, you can choose the Ends With sorting algorithm for the VIN Parameter. If you write '8', all the Trucks with a VIN ending in '8' will show up in the lookup results after you click the Refresh button.