Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Reset Interactive Report before next search

SandijsMar 2 2011 — edited Mar 2 2011
Hi,

I need to automatically reset Interactive Report before new search is executed. Is it possible in Apex 4.01 version?
In my case IR search should work like regular google search where only one filter at a time is applied.

I found out that filters can not be removed from private reports with APEX_UTIL.IR_CLEAR so I decided to call gReport.reset() from JavaScript and after that submit new search. I created text item P6_SEARCH_TEXT and button wich calls javascript function Search:
function Search ()
{
$('#apexir_SEARCH').val($x('P6_SEARCH_TEXT').value);
gReport.search('SEARCH');
};
This works like regular IR search.

When I add greport.reset() call to Search function, my search form stops working.
function Search ()
{
gReport.reset();
$('#apexir_SEARCH').val($x('P6_SEARCH_TEXT').value);
gReport.search('SEARCH');
};
What am I missing?

Comments

Herald ten Dam
Hi,

welcome.

The user who made the index, does it have the role CTXAPP? Otherwise you need to grant this role to the user. 
grant CTXAPP to your_user;
Otherwise you need explicitly grant execute rights of the package CTX_DOC to this user.
The owner of the package is CTXSYS. 
grant execute on ctxsys.ctx_doc to your_user;
If there are still problems, it will be better to post in the TEXT forum.

Herald ten Dam
htendam.wordpress.com
776964
Unfortunately, that doesn't seem to work either:

grant execute on ctxsys.ctx_doc to sysadm
*
FOUT in regel 1:
.ORA-04042: procedure, function, package, or package body does not exist

Thanks for your reply. I will continue this in the right forum.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 30 2011
Added on Mar 2 2011
#apex-discussions
4 comments
3,295 views