Customize your Lists of Values

You may change the lists for some of the Lists of Values (LOV’s). This will enable you to limit the values appearing in the list. You may even create different views for different users operating in the same database.

Click on the ‘Customize LOVs’ button on the ribbon.

A Description and the Default view name will be displayed for each LOV:

You can enter custom view names into the ‘OVERRIDE’ column to limit the values that display for the user.

The view should be created as:

select *

from standard_lov

where new_conditions

If you specify a smaller number of columns or rename them, you run the risk of ‘invalid column’ type messages.

Another method is to use an in-line query. This is useful as there is no need to create a view in the database.

Here is an example for pa_projects. The brackets are important:

(select * from pa_projects where segment1 like ‘A%’)

This example will only allow projects whose numbers start with the letter A.

NOTE: Refer to the Product-specific Online Documentation on our website to see if a particular Wizard has this functionality. To request additional functionality, please contact us via the Company website https://more4apps.com/support/new-support-request