35.10 POPUPKEY_FROM_LOV Function
This function generates a popup key select list from a shared list of values (LOV). Similar to other available functions in the APEX_ITEM
package, the POPUPKEY_FROM_LOV
function is designed to generate forms with F01
to F50
form array elements.
Syntax
APEX_ITEM.POPUPKEY_FROM_LOV (
p_idx IN NUMBER,
p_value IN VARCHAR2 DEFAULT NULL,
p_lov_name IN VARCHAR2,
p_width IN VARCHAR2 DEFAULT NULL,
p_max_length IN VARCHAR2 DEFAULT NULL,
p_form_index IN VARCHAR2 DEFAULT '0',
p_escape_html IN VARCHAR2 DEFAULT NULL,
p_max_elements IN VARCHAR2 DEFAULT NULL,
p_attributes IN VARCHAR2 DEFAULT NULL,
p_ok_to_query IN VARCHAR2 DEFAULT 'YES',
p_item_id IN VARCHAR2 DEFAULT NULL,
p_item_label IN VARCHAR2 DEFAULT NULL )
RETURN VARCHAR2;
Although the text field associated with the popup displays in the first column in the LOV query, the actual value is specified in the second column in the query.
Parameters
Table 35-10 POPUPKEY_FROM_LOV Parameters
Parameter | Description |
---|---|
p_idx |
Identifies a form element name. For example, Because of the behavior of
|
p_value |
Indicates the current value. This value should be one of the values in the P_LOV_NAME parameter.
|
p_lov_name |
Identifies a named LOV used for this popup. |
p_width |
Width of the text box. |
p_max_length |
Maximum number of characters that can be entered in the text box. |
p_form_index |
HTML form on the page in which an item is contained. Defaults to 0 and rarely used. Only use this parameter when it is necessary to embed a custom form in your page template (such as a search field that posts to a different website). If this form comes before the |
p_escape_html |
Replacements for special characters that require an escaped equivalent.
This parameter is useful if you know your query returns invalid HTML. |
p_max_elements |
Limit on the number of rows that can be returned by your query. Limits the performance impact of user searches. By entering a value in this parameter, you force the user to search for a narrower set of results. |
p_attributes |
Additional HTML attributes to use for the form item. |
p_ok_to_query |
Range of values is YES and NO . If YES , a popup returns the first set of rows for the LOV. If NO , a search is initiated to return rows.
|
p_item_id |
HTML attribute ID for the <input> tag. |
p_item_label |
Invisible label created for the item. |
Example
The following example demonstrates how to generate a popup key select list from a shared list of values (LOV).
SELECT APEX_ITEM.POPUPKEY_FROM_LOV (1,deptno,'DEPT') dt
FROM emp
Parent topic: APEX_ITEM (Legacy)