Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Autocomplete search appearing but search not firing?

Rambo79Sep 14 2012 — edited Sep 17 2012
I am using the following in my interactive report to provide an autocomplete Jquery search fields

When typing in an item in the search boxes the autocomplete works find but for some reason it is not firing the search anymore? Any ideas on what I am missing with this? I have spent the week on it and it would be great to sign off the week with a working report!

Many Thanks


In the Javascript section of the page I am using

function srch2(pItem, pColumn) {
$.post('wwv_flow.show',
{"p_request" : 'APXWGT',
"p_widget_action" : 'FILTER',
"p_widget_action_mod" : 'ADD',
"p_widget_mod" : 'ACTION',
"p_widget_name" : 'worksheet',
"p_flow_id" : $v('pFlowId'),
"p_flow_step_id" : $v('pFlowStepId'),
"p_instance" : $v('pInstance'),
"x01" : $v('apexir_WORKSHEET_ID'),
"x02" : $v('apexir_REPORT_ID'),
"x03" : pColumn,
"f01" : ['COLUMN', pColumn, '=', $v(pItem), null, 'minutes']
},
function(data){
//when the filter has been successfully applied the report has to be refreshed
if(data=="true"){
gReport.pull();
};
}
);

//clear the item
$s(pItem,'');
};



$('#P4_AC').bind("result", function(){
//on selecting a value then fire the search function
srch2(this, 'INDSNAME');
});

// ac item P4_AC2
$('#P4_AC2').bind("result", function(){
srch2(this, 'INDFNAME');
});

// ac item YEARD
$('#YEARD').bind("result", function(){
srch2(this, 'NEWYEAR');
});
});
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 15 2012
Added on Sep 14 2012
6 comments
358 views