35.9 POPUP_FROM_QUERY Function
This function generates an HTML popup select list from a query. Like other available functions in the APEX_ITEM
package, the POPUP_FROM_QUERY
function is designed to generate forms with F01
to F50
form array elements.
Syntax
APEX_ITEM.POPUP_FROM_QUERY (
p_idx IN NUMBER,
p_value IN VARCHAR2 DEFAULT NULL,
p_lov_query 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;
Parameters
Table 35-9 POPUP_FROM_QUERY Parameters
Parameter | Description |
---|---|
p_idx |
Form element name. For example, 1 equals F01 and 2 equals F02 . Typically, p_idx is a constant for a given column.
|
p_value |
Form element current value. This value should be one of the values in the p_lov_query parameter.
|
p_lov_query |
SQL query that is expected to select two columns (a display column and a return column). For example:
|
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.
Range of values is |
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 |
ID attribute of the form element. |
p_item_label |
Invisible label created for the item. |
Example
The following example demonstrates a sample query the generates a popup select list from the emp
table.
SELECT APEX_ITEM.POPUP_FROM_QUERY (1,deptno,'SELECT dname, deptno FROM dept') dt
FROM emp
Parent topic: APEX_ITEM (Legacy)