Auto Submit On Page Load
555851Mar 1 2007 — edited Jul 10 2007Hi 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