Hi All,
To meet requirements of the client, I had to manually create a page with a form instead of the interactive report for query purpose.
The client basically wants to see the values of around 70 fields all at once, which unfortunately the interactive report does not provide.
I am using APEX 5. Does not like the tabular report either.
I create a button called 'Query' on the form and want to populate the form fields with the first record when user presses query.
Question 1: How to link the query button with the sql query and map the data returned by the query to items on the form. In the button behavior, I see the action can be defined by Dynamic actions.
But I do not see the option in database action for "SQL query", which is not a surprise as the form is only meant for create/delete/update/insert.
I am thinking of executing the PL/SQL using the dynamic action but how to associate the data returned by the query to the items on the form.
Please advise how to achieve the functionality
The user will also see the 'Next' and 'Previous' button which allows them to traverse the records
Question 2: How to implement the Next and Previous functionality as well.
Thanks in advance.