Forms and Reports—Advanced - Beginning Oracle Application Express 4.2 - page 196

Figure 7-78. Adding a P200_STATUS_ID item

Enter Status for Label , and click Next . 5.

6. Accept the defaults on the next page, and click Next .

To set the LOV attributes, set Named LOV to P210_TICKETS_STATUS_ID , ensure that
Display Null Values is set to Ye s , enter - All Statuses - for Null Display Value ,
enter % for Null Return Value , and click Next (see Figure 7-79 ).

7.

Figure 7-79. Setting LOV attributes for new item P200_STATUS_ID

In the Default field, enter % , as shown in Figure 7-80 , and click Create Item .

8.