As I can see on the tabular form's fields I can't perform dynamic actions. What I want is to have a select list item when at the event Change it changes the values for all the records in that report. For example if I have 40 records in that tabular form and I change the value from "Open" to "Close to the field called Status, I want to see that change (Status value from "Open" to Close") reflected in all the rows of that tabular form. Is that make sense?
Thank you, Bernardo.
There are several ways to accomplish what you want.
- You can create a PL/SQL procedure to handle an update on all rows based on the value of your changed column value. I once wrote a blog post that might help you with that:
The first option is more secure since it's handled by the database, the second one is simpler and can instandly set all the entire column for all displayed rows, without the need to refresh your tabular form, or your entire page. For a secure working you should however have some validation at the database end. Also I think it is not possible to set the values for rows that are not displayed, that again would require some PL/SQL for handling.
If you need any help setting up the dynamic action, please put up an example on apex.oracle.com.
Thank you Vincent. I think that I'm going to need help to set up the dynamic action. Can I have your email to create the user for you on apex.oracle.com?
can you please check out my post and help me out
Thanks & Regards,