07:59:32 | * Chaitanya Koratamaddi | Welcome! Good Morning / Good Evening to All! |
08:01:02 | * David Peake | Please don’t hesitate to ask question in the chat as we go through |
08:05:58 | Jeffrey Kemp | One 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:21 | Denis Savenko | Why there's no `input` event amongst the standard events list for dynamic actions? |
08:06:50 | Daxlai | how to debug our dynamic action |
08:07:13 | * John Snyders | Good point about input. It is a newer event. Should probably have this event. |
08:09:29 | Prashanth Raju | Can 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:03 | Prashanth Raju | Sure. Thanks @David |
08:11:25 | Alastair | requesting action level conditions |
08:12:11 | Ross 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:01 | Jeffrey Kemp | "Create Opposite Action" is almost probably my #1 most favourite thing ever. |
08:15:37 | Karen | I like that one too ... |
08:16:51 | Daxlai | how open this debuge windows |
08:17:19 | Jeffrey Kemp | Chrome: F12 |
08:17:31 | * David Peake | @Daxlai - Good question … there you go |
08:17:34 | * John Snyders | It is a browser feature so could depend on browser. Often F12 |
08:17:41 | Scott Wesley | or ctrl-shift-J |
08:17:58 | Prashanth Raju | Yes. or Mouse right click > Inspect element. Depends on browser |
08:20:04 | Alastair | i.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:04 | Paul | Is it possible to add declarative dynamic actions to form elements created dynamically using the APEX_ITEM API? |
08:22:08 | Alastair | @David, cheers |
08:22:29 | Scott Wesley | Paul: Why? When we have server conditions/ |
08:22:35 | Shig Hiura | There'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:22 | Eric 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:31 | Alastair | Also, not sure if there are any more off the top of my head but any plans for future event types or actions? |
08:23:55 | Scott Wesley | Paul: Sorry, I misunderstood the question |
08:24:16 | * David Peake | @Shig - I will ask Anthony during Q & A |
08:24:34 | Shig Hiura | @David - Thanks! |
08:24:35 | Paul | no 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:25 | Scott Wesley | 18.2 also added inline dialog actions? |
08:25:34 | Lalit | Is javascript ajax call is synchronous or asynchronous call ? |
08:25:39 | Scott Wesley | open/close, instead of openModal() ? |
08:26:07 | Scott Wesley | Lalit: Depends on 'wait for result' setting, and your APEX version |
08:26:08 | Eric Olson | What 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 Snyders | safeharbor hopefully yes for open/close modal region |
08:27:04 | Lalit | Thanks Scott |
08:27:20 | Scott Wesley | oh, not available yet? |
08:27:29 | pavuluriv | How 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:24 | Santosh Killari | conditional disable item's vAlue is not updating in the table when pressed the save button,. how can we avoid this?? |
08:29:32 | * David Peake | Keep the great questions coming … Have a nice list for Anthony already |
08:34:44 | rohit.chaurasia | As 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:30 | Paul | I'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:38 | Paul | practice* |
08:38:12 | * John Snyders | @paul use jQuery UI dialog event custom event dialogclose |
08:38:52 | Nicole | is 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:08 | Paul | @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:29 | Eric Olson | @Nicole, add the validation as the client side condition? |
08:41:40 | Nicole | yes |
08:42:06 | Nicole | sorry, no, not as a condition |
08:42:50 | Nicole | i 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:45 | Denis Savenko | Why to prefer dynamic actions to the standard JavaScript/jQuery hanfling of the events? Are there any other reasons besides declarativity? |
08:44:55 | Denis Savenko | handling* |
08:45:12 | Ross 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:28 | Prashanth Raju | Sometimes 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:28 | Nicole | @Ross thank you |
08:46:06 | * David Peake | @Denis - Declarative and much easier for other developers to understand the functionality implemented |
08:47:25 | Jeffrey 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:38 | Jeffrey Kemp | jinx |
08:47:45 | Paul | on 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:49 | Ross Henderson | Will 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:01 | Denis 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:08 | Denis Savenko | *David |
08:49:59 | Paul | thanks @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:33 | Jeffrey Kemp | Delegated Event Handling - the Q was about making it application-wide (i.e. put it on page 0) |
08:56:04 | Paul | I've used apex.widget.waitPopup(); to show the wait spinner previously |
08:57:55 | Prashanth Raju | I use apex.message.showsuccessmessage |
08:57:59 | rohit.chaurasia | I 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:07 | pavuluriv | the APEX_MESSAGE API doesnot work in the Dynamic action |
08:58:15 | Pete K | I used apex_error from pl/sql packages to show errors - would that work from a DA? |
08:58:33 | Pradyumna | how to warn user before closing or cancel a modal dialog for the unsaved data |
08:58:42 | Jeffrey Kemp | I usually put the error message in a hidden item on the page, then use it from a subsequent DA |
08:58:43 | Eric Olson | The hard part seems to be catching the error from the async PL/SQL action. |
09:00:09 | Ross Henderson | I'll look into Custom Events more then! Cheers for that guys. |
09:04:21 | Monica Godoy | Thanks! |
09:04:24 | Jeffrey Kemp | Thanks very much |
09:04:31 | Paul | thanks |
09:04:31 | Sukhraj | Thanks again guys for another useful session |
09:04:31 | Dharmendra | Thanks |
09:04:33 | Prashanth Raju | Thanks a ton |
09:04:40 | Lalit | Thank you |
09:04:41 | Natarajan Sankaran | Thanks |
09:04:46 | Alastair | cya |
09:04:47 | Vinodh | Thanks |