- Removing - Next / Previous from PV List

Removing - Next / Previous from Possible Values List

If you have a long list of choices resulting from your possible values (PV) operation, you may see the choices "— Next –-" and "— Previous –-" (added automatically by WOW). If you want to eliminate those choices, increase the Row Count value in the Advanced section of your possible values operation. For example, if your Row Count is set to 25 and the total number of choices returned from your PV operation is 35, increase the Row Count to a value larger than 35. WOW does not implement the NEXT and PREVIOUS scrolling.

PV Multiple Selects

There may be times when an end user wants to select multiple items from a drop down pick list. This can easily be accomplished using the SQL IN function.

The SQL IN function helps reduce the need to use multiple OR conditions.

The syntax for the IN function is:

This SQL statement will return the records where column1 is value1, value2..., or value_n. The IN function can be used in any valid SQL statement - select, insert, update, or delete. To produce a drop down (PV list), use the WOW “?” function in combination with the IN function to produce multiple selects available via hitting CTRL key to multi select.

Example:

SELECT * FROM PJDATA.EMPLOYEE WHERE WORKDEPT IN ?

This will select employees from multiple departments. As shown in the screens below, you must first create the SQL operation:

SELECT columns FROM tables

WHERE column1 in (value1, value2, .... value_n);

Now, when running the application, a user can click on the drop down and hold the CTRL key down to select multiple departments:

Returned results are shown here:

You can see the two different selected work departments rendered. If you want to change the size of the Possible Values box that is rendered, you can do that by changing the Display Height in the Field Descriptor here:

Notice that the display component is set to *Default, and NOT *Text Area. Possible values cannot be assign to a text area. Now, the user has a larger drop down box to select from: