Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » report-start only by pressing on go button, not by entering page (oracle xe 10g , apex 2.1)
report-start only by pressing on go button, not by entering page [message #510436] Mon, 06 June 2011 00:30 Go to next message
wucis
Messages: 60
Registered: March 2005
Member
I got a page where a long-running report is located. Normally, you would limit the report. But when I clikc now on the tab unlimited report starts immediately.
How can I change this behaviour, that the report only starts by pressing a specific go-button on the page ?
Re: report-start only by pressing on go button, not by entering page [message #510450 is a reply to message #510436] Mon, 06 June 2011 02:01 Go to previous messageGo to next message
c_stenersen
Messages: 255
Registered: August 2007
Senior Member
In the branch from your button you could specify a request (for instance GO). Then in the report attributes you can check this request in the condition for the report. (Condition type "Request = Expression1" and set expression1 to GO.)
Re: report-start only by pressing on go button, not by entering page [message #512082 is a reply to message #510450] Thu, 16 June 2011 19:30 Go to previous messageGo to next message
wucis
Messages: 60
Registered: March 2005
Member
Thats the way I remember it, but it does not work. By the way, the condition is for hiding/displaying the report. The report has not to be hidden, just automatically starting the long-running sql has to be prevented. The report/sql should start running if I push the button
Re: report-start only by pressing on go button, not by entering page [message #512129 is a reply to message #512082] Fri, 17 June 2011 02:20 Go to previous messageGo to next message
c_stenersen
Messages: 255
Registered: August 2007
Senior Member
What does "it does not work" mean? It's still shown? Which URL do you see in the address bar before you press go and what do you see afterwards? And what is in your condition? (Request = expression1, and the expression 1 set to GO? NB, no quotes around GO.)

Well, the easiest way to keep it from running is to hide it. Any messages you want to show to the user (and also your button) could be in a different region. If you really insist on showing the region even if the go button hasn't been pressed you could make it a dynamic query selecting from dual where 1=2 or something if the request isn't GO, and using your full query otherwise. But it's just over-complicating things in my opinion. And you would anyways get the no data found message in your report since it will always search, it just won't find anything.
Re: report-start only by pressing on go button, not by entering page [message #512484 is a reply to message #512129] Mon, 20 June 2011 11:30 Go to previous messageGo to next message
wucis
Messages: 60
Registered: March 2005
Member
it does not work, means, report is hidden, and by pressing the button, it does not appear.
Re: report-start only by pressing on go button, not by entering page [message #512487 is a reply to message #512484] Mon, 20 June 2011 12:13 Go to previous messageGo to next message
c_stenersen
Messages: 255
Registered: August 2007
Senior Member
c_stenersen wrote on Fri, 17 June 2011 09:20
Which URL do you see in the address bar before you press go and what do you see afterwards? And what is in your condition? (Request = expression1, and the expression 1 set to GO? NB, no quotes around GO.)
At least give the f?p=..... part
Re: report-start only by pressing on go button, not by entering page [message #512522 is a reply to message #512487] Mon, 20 June 2011 16:24 Go to previous messageGo to next message
wucis
Messages: 60
Registered: March 2005
Member
URL before: http://127.0.0.1:8008/apex/f?p=163:603:3640996117205179:::::
URL after : http://127.0.0.1:8008/apex/f?p=163:603:3640996117205179::NO:::

Request = expression1
and the expression 1 set to GO

There is also a branch with condition "when button pressed" GO
which has in the action part for page 603

I now added in same action part for request GO
and it seems to work ...
Was that my error ?


URL is now before: http://127.0.0.1:8008/apex/f?p=163:603:3640996117205179:::::
and after: http://127.0.0.1:8008/apex/f?p=163:603:3640996117205179:GO:NO:::
Re: report-start only by pressing on go button, not by entering page [message #512593 is a reply to message #512522] Tue, 21 June 2011 02:07 Go to previous message
c_stenersen
Messages: 255
Registered: August 2007
Senior Member
Yes the error was that you hadn't specified this request in the branch. If you look at the link now you can see that the fourth parameter in the url is GO. This is then what it checks in your condition. (The url syntax is f?p=APP:PAGE:SESSION:REQUEST:DEBUG:CLEAR CACHE:ITEM NAMES:ITEM VALUES:PRINTER FRIENDLY)
Previous Topic: used space
Next Topic: Help with pro SQL dump and Oracle Apex sql commands
Goto Forum:
  


Current Time: Tue Jun 02 00:45:53 CDT 2020