SELECT * from APEX_MAIL_LOG ORDER BY LAST_UPDATED_ON DESC;
SELECT * from APEX_MAIL_QUEUE ORDER BY LAST_UPDATED_ON DESC;
In the last post I showed how easily you can enable an Interactive Grid for editing, however what if you want to only allow the user to edit certain rows?
Lets imagine a scenario – given the standard EMP table, I should only be able to change the salary of Employees who report to me (i.e. I can’t change the salary of an employee if they report to someone else).
So, let’s create an Interactive Grid with the following query –
Now, for the purposes of this example, given the hierarchy of the EMP table –
I’m going to “pretend” to be BLAKE – since BLAKE is the manager of 5 people.
If you look at the properties of the Interactive Grid you’ll see the “Allowed Row Operations Column” setting, this allows us to define a column in the query which will be used to define whether I can Update…
View original post 125 more words