Lookup List General Parameters
ATR CustomTools Lookup list creation begins with the general parameters setup. The general parameters are used to determine the lookup list name, data source type, and the list type.
| Name | Specifies the name of the Lookup List. |
| User specified | The values of the lookup list are defined manually by the user. |
| Database | The values of the lookup list are retrieved from an SQL database or from another valid external data source. |
| Custom |
Create a lookup list which is based on a custom data source. A custom data source used with a lookup
list is managed by ATR CustomTools add-in scripts. Because the Custom data source of a lookup
list is managed with an add-in script, the contents could be retrieved into the lookup list from almost
any kind of data source. The lookup list contents can be included in the add-in script itself, or
located in an external data vault read using the script.
NOTE:
ATR CustomTools Add-in scripts are managed with the ATR CustomTools Administration.
|
| Run | Click the Run button to generate a lookup list based on the Custom data source defined by the add-in script. |
| Simple | Creates a single column lookup list. The values of a simple lookup list can be defined manually or retrieved from an external database. |
| Key-value pairs |
Creates a lookup list having up to 15 columns. The values of a key-value pairs lookup list can be defined manually or retrieved from an external database. The key-value acts as an identifier for its related value. The key-value is a unique identifier for the selected value and it can be used, for example, in drawings to help production or different machines or systems which can only process or use numbers.
TIP:
The key-value itself can be retrieved into another custom property using an Editbox.
The custom property containing the key value can also be hidden to avoid unnecessary information.
|
| Hierarchical list |
Select this to create a hierarchical lookup list. The hierarchical lookup list could be based on user-defined values or values retrieved from an external data source. The main difference to the simple lookup list is that the hierarchical lookup list can contain multiple value levels. The value levels are in hierarchical order (parent nodes and their child nodes) and each level on the hierarchical lookup list could have up to 15 key values that can be linked to the desired Properties. In the Properties, the available items in the combobox type of properties using hierarchical lookup list depend on the selection of the previous property except the combobox property that is associated to the highest level of the hierarchical lookup list. |
| Check List |
Check List is used with CheckList Property which allows multiselection in a single Property Control. Similar to properties utilizing Hierarchical list, Check List can also be hierarchical i.e. parent control selection can control the selectables of a CheckList Property. |
| Hierarchical lists |
When using Hierarchical list in a Hierarchical Combo Property, the value separator is used to
contruct a full path to the selection. For example, if value separator is | and list content is -Parent --Child then the Property value of the Child -selection would will be Parent|Child. |
| Check Lists |
When using Check list in a Check List Property, the value separator is used to concatenate
multiple selections into single target property. For example: Value separator ; and list content -Sawing -Milling -Machining If both Milling and Machining (having the same target attribute) are checked, then the Property value would be Milling;Machining.
NOTE:
Order of concatenation is arbitrary and most internal features consider
Milling;Machining equal to Machining;Milling.
|
Video Links: Use the following links to watch instructive videos about the Lookup list options. All of the following videos are located in the ATR CustomTools YouTube channel. Video links open in a new tab, or if you are opening them from the ATR CustomTools offline helps, the video links open in your default internet browser.
| Video: Key-Value Pairs List | Create a lookup list based on the key-value pairs. |
| Video: Hierarchical Lookup List | Create a lookup list in which the values are defined in a hierarchical order and structure. |