As each LOV is configured it should be validated to ensure the construction is correct.
Click the 'Validate' button to initiate this check:
The 'Validate Messages' page will display any SQL errors first. The SQL statement will also be outputted into the results page, allowing for simple copy and paste into your SQL development tool if required.
Example of Successful Validation
Example of Unsuccessful Validation
Click the button under the LOV Tab to view the SQL results.
Note- Records will be truncated in this form if too many rows are returned.