Inside APEX it’s possible to specify ‘Page Items to Submit’:
- Within the action of the type ‘Execute PL/SQL-code’ of a dynamic action.
- Within a region of the type ‘Interactive report’ or ‘Classic Report’.
The listed page items will be submitted to the server and thus available to use within your ‘PL/SQL-code’ or ‘Source’.
Error: JSON.parse: unexpected character
Uncaught SyntaxError: Unexpected token < apex_4_1.min.js:16
Sometimes you want to call a page-proces, but do need to make a compleet refresh of the page by making a request.
In my case I made a simple master-detail screen with Tabs (Thank you Richard). In the tabs there are reports with a delete button for each row. For the delete operation I did not want refresh the complete page, but only wanted to call the page-proces I had written for the delete-operation and only wanted to refresh the report-region affected.
This is wat i did:
- I made a normal report and added an icon for the delete operation. The icon for the delete operation is the id-column in the report (PRODUCT_VERWIJZING_ID) and has the follwoing column link properties:
- link text: <img src=”#IMAGE_PREFIX#del.gif” alt=”">
- target: URL
After some testing en struggling with the Apex-tree item I decided to look for an alternative for an expanding and collapsable html-list.
Because of the integration with Jquery in apex, i obviously looked for an apex plug-in and found a really ease one.
The plug-in is written by Milaju and the source and documentation can be found at:
You can find a demo at:
How to integrate:
- Download the source-file from http://www.milaju.com/post/simple-jquery-expandcollapse-unordered-lists
- Extract the zip-file
- Go to Shared Components – Static files
- Upload the files “jquery.collapse.js” and “jquery.easing.js”. You do not need to upload the file “jquery.js”, because it’s already available within Apex
- Go to the page where you want to make the list
- Put in the region source:
- Make a new report region which makes the list-output as shown under. (the most important thing is to give the first ul-element the id “collapser” and keep the structure of the elements UL en LI the same)
- And voilà! The list is done! Easy, not?!