• Session Chats

Breadcrumb

Filter

Chat

TimestampEntered ByComment
07:59:32* Chaitanya KoratamaddiWelcome! Good Morning / Good Evening to All!
08:01:02* David PeakePlease don’t hesitate to ask question in the chat as we go through
08:05:58Jeffrey KempOne thing I've never quite got solved was trying to have a spinner show while other dynamic actions were executing; when I've tried it, the spinner wouldn't start until after the PL/SQL action had completed, even though the "show spinner" action appears first before the PL/SQL call. Any ideas what I'm doing wrong?
08:06:21Denis SavenkoWhy there's no `input` event amongst the standard events list for dynamic actions?
08:06:50Daxlaihow to debug our dynamic action
08:07:13* John SnydersGood point about input. It is a newer event. Should probably have this event.
08:09:29Prashanth RajuCan we also see a quick DEMO of debugging Dynamic Action for any issues?
08:10:45* David Peake@Daxlai and Prashanth - I will ask Anthony to demo debugging if he doesn’t cover as part of his demo
08:11:03Prashanth RajuSure. Thanks @David
08:11:25Alastairrequesting action level conditions
08:12:11Ross Henderson^
08:12:55* David Peake@Alastair - Can you provide an example of an action level condition and when you would use it
08:15:01Jeffrey Kemp"Create Opposite Action" is almost probably my #1 most favourite thing ever.
08:15:37KarenI like that one too ...
08:16:51Daxlaihow open this debuge windows
08:17:19Jeffrey KempChrome: F12
08:17:31* David Peake@Daxlai - Good question … there you go
08:17:34* John SnydersIt is a browser feature so could depend on browser. Often F12
08:17:41Scott Wesleyor ctrl-shift-J
08:17:58Prashanth RajuYes. or Mouse right click > Inspect element. Depends on browser
08:20:04Alastairi.e I always want to fire after a custom event, but only a specific action based on a hidden item value
08:21:48* David Peake@Alastair - I will ask Anthony during Q & A
08:22:04PaulIs it possible to add declarative dynamic actions to form elements created dynamically using the APEX_ITEM API?
08:22:08Alastair@David, cheers
08:22:29Scott WesleyPaul: Why? When we have server conditions/
08:22:35Shig HiuraThere's an option for a page item to use the Required template to show the red asterisk (*) next to the field label. Is there a way to dynamically change the template depending on a field's value selected (ie, radio button or dropdown list)? I have a case where the required fields differe depending on one of the fields.
08:23:02* John Snyders@paul yes just use a custom selector to identify the dynamic created element
08:23:22Eric Olson@Paul, Yes, if you use a jQuery selector as the Selection Type, identify the item by a class, and the scope is Dynamic.
08:23:31AlastairAlso, not sure if there are any more off the top of my head but any plans for future event types or actions?
08:23:55Scott WesleyPaul: Sorry, I misunderstood the question
08:24:16* David Peake@Shig - I will ask Anthony during Q & A
08:24:34Shig Hiura@David - Thanks!
08:24:35Paulno probs @scott, thanks @John, @Eric
08:25:03* David Peake@ Alastair - We are always looking at appropriate new events to add. For example in APEX 18.1 we added new touch events
08:25:25Scott Wesley18.2 also added inline dialog actions?
08:25:34LalitIs javascript ajax call is synchronous or asynchronous call ?
08:25:39Scott Wesleyopen/close, instead of openModal() ?
08:26:07Scott WesleyLalit: Depends on 'wait for result' setting, and your APEX version
08:26:08Eric OlsonWhat are some suggested best practices when writing your own Javascript for DAs? I've seen some people suggest namespacing all the custom functions? Static .js files or inline?
08:26:22* John Snyderssafeharbor hopefully yes for open/close modal region
08:27:04LalitThanks Scott
08:27:20Scott Wesleyoh, not available yet?
08:27:29pavulurivHow to display a user freindly error message from the PL/SQL dynamic action
08:28:15* David Peake@Eric - Great question for Anthony :)
08:28:24Santosh Killariconditional disable item's vAlue is not updating in the table when pressed the save button,. how can we avoid this??
08:29:32* David PeakeKeep the great questions coming … Have a nice list for Anthony already
08:34:44rohit.chaurasiaAs we are talking about the REST API. Is it possible to call google Map API by using APEX Rest API which ultimately returns the JSON file and then we can capture that data in the items on the APEX Page.
08:35:36* David Peake@Rohit - Plz ask your question on the APEX forum or Slack channel as related to REST APIs not Dynamic Actions
08:36:30PaulI've done it before but what's the best practive to detect the modal closing when the X has been pressed (rather than a close dialog process running) if we want to fire an action
08:36:38Paulpractice*
08:38:12* John Snyders@paul use jQuery UI dialog event custom event dialogclose
08:38:52Nicoleis there a way to run a validation on an item before the Dynamic Action fires? For instance, i had a button that had a DA to execute PL/SQL, but before the PL/SQL ran, I want to run the validation I have set on the item
08:40:08Paul@john, thanks, i have used that before but it doesn't seem to always work, I'll create an example and post it on the forum sometime
08:40:52* David Peake@Nicole - Dynamic Actions fire on the client and standard validations fir on the server. You could define a separate DA which fires a Confirm or Alert action but that won’t stop processing like a validation
08:41:29Eric Olson@Nicole, add the validation as the client side condition?
08:41:40Nicoleyes
08:42:06Nicolesorry, no, not as a condition
08:42:50Nicolei had a validation set on an item to run pl/sql to check the value in a table. i wanted that validation to run before the DA...but I saw DAs don't run a submit page which is when the validations actually run
08:44:45Denis SavenkoWhy to prefer dynamic actions to the standard JavaScript/jQuery hanfling of the events? Are there any other reasons besides declarativity?
08:44:55Denis Savenkohandling*
08:45:12Ross Henderson@Nicole Try having the DA run on request when you submit the page? I'm not sure if the validation would run first or not though.
08:45:28Prashanth RajuSometimes I get issues when I copy DA from one page to another. The functionality deos not work in my new page. Is this a Bad Practice?
08:45:28Nicole@Ross thank you
08:46:06* David Peake@Denis - Declarative and much easier for other developers to understand the functionality implemented
08:47:25Jeffrey Kemp@Denis - declarative is much more likely to work in all future versions of APEX; javascript code is more likely to become out of date or deprecated
08:47:30* David Peake@Denis - When you go from one release of APEX to a higher release then DAs will still work. No guarantee that your custom JS / AJAX will work
08:47:38Jeffrey Kempjinx
08:47:45Paulon the security, when I have a DA that updates a hidden item I often hit the "protected value" error, what are the dangers of just turning off the "Value protected" property on a hidden item?
08:48:49Ross HendersonWill there ever be a way to create a sort of "cascading DA"? Ie. If one DA true or false statement is met, another DA can use that to be triggered.
08:49:01Denis Savenko@Davd thx for the suggestions, actually I already came across a situation when my custom handling of `on page load` even stopped working once I upgraded form 5.1 to 18.1
08:49:04* David Peake@Paul will ask Anthony during Q & A
08:49:08Denis Savenko*David
08:49:59Paulthanks @David, @Ross's question above is a classic example, i chain DA's to update a hidden item then depending on the value of the hidden item fire a different DA
08:51:42* David Peake@Ross and Paul - Added to list of qu’s
08:52:33Jeffrey KempDelegated Event Handling - the Q was about making it application-wide (i.e. put it on page 0)
08:56:04PaulI've used apex.widget.waitPopup(); to show the wait spinner previously
08:57:55Prashanth RajuI use apex.message.showsuccessmessage
08:57:59rohit.chaurasiaI have a long running Javascript and after which plsql code runs. I have implemented waitpopup for this. but the screen hangs for the long time(when js runs) then waitpopup is shown for a sec and then plsql runs. I am actually looking for some solution so that when my JS is running i can show waitpopup on the screen. can dynamic action handle this?
08:58:07pavulurivthe APEX_MESSAGE API doesnot work in the Dynamic action
08:58:15Pete KI used apex_error from pl/sql packages to show errors - would that work from a DA?
08:58:33Pradyumnahow to warn user before closing or cancel a modal dialog for the unsaved data
08:58:42Jeffrey KempI usually put the error message in a hidden item on the page, then use it from a subsequent DA
08:58:43Eric OlsonThe hard part seems to be catching the error from the async PL/SQL action.
09:00:09Ross HendersonI'll look into Custom Events more then! Cheers for that guys.
09:04:21Monica GodoyThanks!
09:04:24Jeffrey KempThanks very much
09:04:31Paulthanks
09:04:31SukhrajThanks again guys for another useful session
09:04:31DharmendraThanks
09:04:33Prashanth RajuThanks a ton
09:04:40LalitThank you
09:04:41Natarajan SankaranThanks
09:04:46Alastaircya
09:04:47VinodhThanks
  • 1 - 94