- Using SQL IN To Select Multiple Values

In cases where multiple selection values are desired, the SQL IN predicate can be used. SQL IN clause allows

specification of multiple values for filtering as shown here. http://www.w3schools.com/sql/sql_in.asp

For example, if I want to be able to select employees from set MULTIPLE work departments, I would code an SQL as follows

SELECT * FROM PJDATA.EMPLOYEE WHERE WORKDEPT IN ('D21', 'A00', 'B14')

However, if you want to dynamically select employees from multiple work departments, follow these steps:

1) Create an operation to prompt the user to select an employee Work Department:

SELECT * FROM PJDATA.EMPLOYEE WHERE WORKDEPT IN ?

2) Create a PV operation to create a drop-down list for your Work Department field for user to select from:

Run the application and open the FD manager on the WORKDEPT field:

In the Possible Value setting, set the PV operation to the previous operation "Work Departments" and update.

Now running the Employees in Work Department operation, the user is prompted with a drop down list:

Within this list, users can hold down the "shift" key and select multiple values as shown here - A00 and A01:

For more information on multi-value selector, visit this page in WOW Builders Guide.