ODF Viewer is a region type plugin that allows you to display ODF files like spreadsheets(.ods) or documents(.odt) with a single sql query. It is based on JS Framework webodf.js (https://github.com/kogmbh/WebODF).
- Import plugin file "region_type_plugin_de_danielh_odfviewer.sql" from source directory into your application
- (Optional) Deploy the CSS/JS files from "server" directory on your webserver and change the "File Prefix" to webservers folder.
- SQL Query that returns a BLOB value and the filename as text
- Select the BLOB column (Content should be a ODF compatible file, all other kind of files doesn´t work)
- Select the filename column (should contain the whole filename incl. file ending)
- Error Text when filetype is not a ODF file
SELECT content, (BLOB)
filename (varchar2)
FROM file_table
WHERE id = :P10_FILE_ID