Define Value Lists

Define Value lists screen is used to define the value lists which retrieve data from the database and can be used for further transactions. The value list contains the logic to retrieve the data. The retrieved data can be used to populate. These value lists are used while defining flex table attributes.

You can also modify the existing value lists through this screen

To define or modify Value lists:

1. On the System Administration module, click Basic Configurations, and then click Value Lists .

2. Enter the valuelist code and description in respective fields.

3. Select the Data Type and Value list Type from the respective drop-downs.

4. If Query ResultSet is selected in the value list type then enter the query which should be executed in SQL query field. The query should contain the logic to retrieve data from the database.

5. If Discrete Values is selected in the value list type then enter the discrete values in the discrete values field .

6. Click the Save button to save the details.

7. To modify a value list , enter the name of the value list or click the Search Lookup against the ValueList Code field. The details appear in Lookup Search pop up window. Select the required ValueList code link from the Search Results list in Lookup Search pop up window. The details appear in the main window

8. Modify the required changes and click the save button to save the changed details.