Introduction

Learn to configure look up list

Last published at: October 5th, 2023

Looks up data feature provides an area within FlowWright to configure a lookup list or data list that can be used within other parts of the application. These lists can be used on form drop-down controls, or event to store information such as usernames and passwords.

Navigate to Create - Lookup Data page. Lookup data can be maintained using the following UI. 

 

Create Lookup Data

Select Actions - Create menu option. 

The required fields for input are rendered in a popup window. Provide the unique category name. Provide the description test. Provide the value. Provide the filter value. Click on CREATE to confirm the action. 

The lookup data is listed in the Categories tree in a sort order. 

To add more values to this lookup list, select the list row item and click on Actions - Create menu option. 

Provide the description test. Provide the value. Provide the filter value. Click on CREATE to confirm the action. 

The lookup list is updated with the new value. 

Here's another way to add values to lookup list. Select the Categories tree and right-click to view options to ADD

 

Edit Lookup Data

Select the lookup list row item. Click on Actions - Edit menu option. 

The lookup list details are rendered in a popup window. Provide the necessary changes. Click on UPDATE to confirm the action. 

 

Remove Lookup Data

Select the lookup list row item. Click on Actions - Remove menu option. 

Select OK to confirm the action. The lookup list value is removed. 

 

Bulk add Lookup Data

Select Actions - Bulk Add menu option. 

Provide the values comma separated on new lines. Click on CREATE to confirm the action. 

The lookup list is bulk added and an alert notification confirms the changes.  

 

Sort Lookup Data

Select lookup data category. Click on Sort by - sort menu option. 

Here, the list is sorted by value. An alert notification confirms the changes. 

 

Export Lookup Data

Select lookup data category. Click on Export - XML menu option.  The values can be exported out as XML and imported back as XML.  Select an existing lookup data from the table and select menu item “Export - XML” to get a file containing the XML for the list values. Likewise, the user can export/download the lookup data as SQL insert file by clicking on the “Export - SQL” menu item as shown below.

 

Import Lookup Data

Select lookup data category. Click on Import - XML menu option. The values which are exported out as XML can be imported back as XML.  Select an existing lookup data XML file from the local folder table and import.