- How to create: Possible Values

How to create

Possible Values Operation [PV]

Create a Possible Values [PV] Operation and set the Operation Type to Possible Values. Create the Operation Code similar to something like this:

SELECT DISTINCT column_1 FROM Schema.Table

UNION

SELECT DISTINCT column_2 FROM Schema.Table

UNION

SELECT DISTINCT column_3 FROM Schema.Table

For this example shown, it would look something like this:

SELECT DISTINCT firstname FROM pjdata.employee

UNION

SELECT DISTINCT lastname FROM pjdata.employee

UNION

SELECT DISTINCT job FROM pjdata.employee

UNION

SELECT DISTINCT workdept FROM pjdata.employee

Note: If using two separate Predictive Search textboxes as also shown, you would just use the first two columns in this Possible Values Operation and then create a second one using the 3rd and 4th columns for that Possible Values Operation.

Then once you Insert the [PV] Operation, set this [PV] Operation on the Derived FD that was created for the Predictive Search.

For more information on using UNION, please click here.