I have a dynamic action that is fired from an onclick on a column in an IR - the (serialised) action uses PL/SQL to build an Anychart XML and then opens a Jquery dialog (floating) window/region that renders the graph. (Apex 4.2..2.x)
In some cases it takes several seconds for the PL/SQL part to execute - which means no visual cues to the web user that the page is busy processing. Instead of hacking custom Jquery regions for spinner images and the like, I would rather stick to standard Apex functionality. So what would the proper way be to deal with this?
Any pointers/doc references will be appreciated. Thanks.
You could transfer the PL/SQL part in you DA to an "on demand process"and trigger that process from the java (jquery) part in your DA.
this would look something like this:
var lRequest = new htmldb_Get(null, $v('pFlowId'), 'APPLICATION_PROCESS=BUILD_ANYCHART_XML_PROCESS', $v('pFlowStepId'));
+If the question is answered please change it to answered and mark the appropriate post as correct/helpfull.+
Thanks. But on-demand processing makes thing a bit less transparent - the Apex app needs to be managed from a developer perspective by guys from our product management team and I want to make it as easy to understand as possible. Which I believe my current attempt is.
I've tried a CSS approach. Goes something like this: document.body.className='waiting';doAction();document.body.className=''; - where "waiting" sets the document cursor to waiting.
Thanks. Still does not work.
The wait effect (popup, wait cursor, etc) does not render - and I've tried a couple of method to provide a visual cue.
It as if the browser's GDI does not get a chance to refresh and display that wait effect, prior to doing the PL/SQL (Ajax) call.
Weird - that should work. When you run it from the browser's developer tools console - can you see it pop up?
Yes, everything works fine via console when called manually and individually.
Will play around some more with it..