4 Replies Latest reply on Mar 2, 2011 3:38 PM by Sandijs

Reset Interactive Report before next search

Sandijs Mar 2, 2011 1:18 PM

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?

1. Re: Reset Interactive Report before next search

vee Mar 2, 2011 2:12 PM (in response to Sandijs)
I think the report refresh call( gReport.reset() ) is an asynchronous process.

So the code
function Search () { gReport.reset(); $('#apexir_SEARCH').val($x('P6_SEARCH_TEXT').value); gReport.search('SEARCH'); };
is probably not going to work as you would expect it to.
Its possible that the second and especially the third line is running before the region refreshes and this causing your page to get stuck.
1 person found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Reset Interactive Report before next search

Sandijs Mar 2, 2011 2:39 PM (in response to vee)

Yes, it looks like greport.reset is asynchronous.
Is there other way to get desired result?
Like Show 0 Likes(0)

Actions
3. Re: Reset Interactive Report before next search

vee Mar 2, 2011 3:30 PM (in response to Sandijs)
Got as far as this
$('#apexir_REPORT').one('apexafterrefresh',function() { alert('after refresh'); $('#apexir_SEARCH').val($x('P6_SEARCH_TEXT').value); /* gReport.search('SEARCH'); */ }); gReport.reset();
When I uncomment the search request, it clears the field and does a refresh as though nothing was searched, so that needs to be figured.
See if you can take it forward from here.
1 person found this helpful
Like Show 0 Likes(0)

Actions
4. Re: Reset Interactive Report before next search

Sandijs Mar 2, 2011 3:38 PM (in response to vee)

Thank you for your input! I will let you know if I will succeed!
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.