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!

Auto Submit On Page Load

555851Mar 1 2007 — edited Jul 10 2007
Hi All!

I use a Tabular Form, where I made myself some kind of Filter for the table
to have a better overview!

The problem is I always have to press the button ,,Submit" that the table is shown, now I want to have a solution that the table is shown automatically when I load the page!

I found some examples in the forum but they don't work without failure!
I tried for example to write in the OnLoad Page HTML Body Attribute
the command onLoad="doSubmit('Go')" but then the page is loaded again and again! Is there a possibility to execute this process only once?

examples for my filters (The 3 Filters are used as Select Lists with Submit) :

where upper(TABLENAME) like '%' || upper(:FILTER_TABLENAME) || '%'
AND upper(KEYVALUE) like '%' || upper(:FILTER_KEYVALUE) || '%'
AND DATE_INSERTED_PDW >= to_date(:FILTER_DATE_INSERTED_PDW,'DD.MM.YYYY')

Is there any possibility to realize it?

Thanks,

Matthew
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2007
Added on Mar 1 2007
4 comments
1,935 views