Hi All,
APEX 4.2, XE 11.2
I have a custom editable IR, and need to add a couple of popup LOV columns...
Ive looked for any alternatives, including the autocomplete JQuery Autocomplete, unfortunately I must be able to select from a list (of about 5000 codes and descriptions...)
So. I'm trying to call and use the LOV package wwv_flow_utilities.gen_popup_list directly... (whether I should be using this directly is of course another topic..)) I've taken the source from another page with a standard tabular form, and created a named LOV which it references.
Its all working as an LOV field in my interactive report, and pops up and selects correctly, populates the display field. and I have custom update process that updates correctly..
All good.. except.... it won't display the list of values unless Ive first loaded the original page with the tabular form and other standard LOV on it.. It pops up nicely, but the popup is blank.. Once Ive loaded the tab form page once, my LOV on my editable form displays the list of values and works fine for the duration of my session...
My assumption is that the tabular form must be initialising something that is missing from my page with the Interactive report... (or some kind of security or checksum that Im somehow missing)... Ive looked at the page source, and cannot see anything obvious. Ive a naggin feeling that it must have something to do with security.. There is nothing different about the page with the tabular form.. When I compare the URLs for each popup, they are identical except for the page number..
For reference, my customised function is:
function genList_sup(vHidden_ID,vDisplay_ID)
{
w = open("wwv_flow_utilities.gen_popup_list" +
"?p_filter=" +
"&p_name=" + escape('f02') +
"&p_element_index=" + escape ('1') +
"&p_hidden_elem_name=" + escape('f01') +
"&p_elem_id=" + escape(vDisplay_ID) +
"&p_hidden_elem_id=" + escape(vHidden_ID) +
"&p_form_index=" + escape('0') +
"&p_max_elements=" + escape('') +
"&p_escape_html=" + escape('') +
"&p_ok_to_query=" + escape('YES') +
"&p_flow_id=" + $v('pFlowId') +
"&p_page_id=" + $v('pFlowStepId') +
"&p_session_id=" + $v('pInstance') +
"&p_eval_value=" + escape('') +
"&p_return_key=YES" +
"&p_translation=" + escape('NO') +
"&p_lov=" +
"&p_lov_checksum=" +
"&p_item_id=" + escape('-1063158750') +
"&p_column_id=" + escape (''),
"winLov",
"Scrollbars=1,resizable=1,width=400,height=450");
if (w.opener == null)
w.opener = self;
w.focus();
}
Anyone any clues, it would be usefull.. (or if anyone can point me at an alternative LOV that I could use in a Editable IR, that would also be useful...
Cheers
Richard