On the Value List on Database Window it is possible to select the data from a database to create a List to be used on ChronoScan.
Select Data Source
The Select Data Source button will open up the Database Navigator Window where you will be able to select where the desired data will be imported from.
After selecting the database where the data will be coming from select using those two menus the value field and the description field if you need a description.
On the Search Function panel the search function for the selected fields from the database will be sown. It will update every time the Value Field and the Description Field change and you can customize it further here. When using entities the following statement should be used for the suppliers list:
Select [CompanyID],[Name] from [chrono_Suppliers]
where (EntityID='%batch_Entity_id%' OR EntityID is null)
Using the selected source this panel will display a preview for the list to be created using the currently selected data. It will update when you click on the Test List button.
