Oracle APEX Single Record Report or Review
Posted on 2011-03-21
I have an application which has a form where users submit accounts for review. It is working great and populates a table in my schema, but of course we need to have these accounts reviewed by my team. I am attempting to design a button that will pull a single random account that was submitted into a report/form (not sure which to use) so that my team can review them for errors and have an 'accept' or 'deny' button.
What would be the best method for designing such a review. The button would need to execute PL/SQL that would update the 'user id' column of the person clicking the button and thus "assigning the account to them" and display that single record in this report/form so that they can easily review it for approval. I have already written the SQL that will pull a random record from the table. The Accept or Reject buttons would insert a Y or N into the accepted column.
We are using Oracle 11g and Apex 3.2. I am just not the best at PL/SQL and not sure how to get such a button to launch this form.
On a separate note I have used JQuery and have seen the posts on how to create a form via JQuery but not sure how to bring in a random loan with by executing SQL.