Oracle APEX Dynamic Action Plugin - Amandanita

Dynamic Action Plugin to Merge data from a query into a docx Template. based on doxtemplater

About

This plugin is client side renderer, it send data to client side where it use docxtemplater to generate the document based on template.

Enhancement

Based on AmandaDocxPrinter, the following enhancements were done :

• more secure query handling (data are sent to client side js instead of query it self).
• query parameter without submiting page
• generate from query type json (one column type clob containing json) or rows

Features

• template from static files
• parameters
• query type ( json )
• query type ( rows )
• generate template 0 from query
• use 21c/23c server side MLE modules rendering (schema independent plugin) .
• template from db.

Demo Application

• The Demo Application is at (https://apex.oracle.com/pls/apex/r/hachemi/amandanita)
• Credentials: demo/password123

Credit

• Oracle apex team [apex.oracle.com]
• AmandaDocxPrinter [https://github.com/aldocano29/AmandaDocxPrinter]
• DocxTemplater javascript library by Edgar Hipp [https://github.com/open-xml-templating/docxtemplater]
• stefandobre [https://github.com/stefandobre/apex-mle-demo]
• Daniel Hochleitner[https://github.com/Dani3lSun/apex-plugin-templates]