Fugerit

Ok thanks for the answer. was very helping. Only I cannot find a table where i can find the report metadata, is there any?

A typical line of logging in the ART_LOGS table is 2020-02-04 19:03:21 myuser report 192.168.1.1 1 0 0 htmlDataTable, myparam: myvalue The message in this case is : htmlDataTable, myparam: myvalue Is it possible to add to the message some other information (i'm especially interested in report id and data source). Thanks in advance.

Ok, Thanks a lot.

Thanks a lot for the help. I actually managed to make it work. This is what i added to groovy white list (I had default one) : com.zaxxer.hikari.pool.HikariProxyConnection com.zaxxer.hikari.pool.HikariProxyResultSet oracle.jdbc.driver.T4CConnection oracle.jdbc.driver.OracleResultSetImpl oracle.jdbc.driver.OracleResultSetMetaData oracle.sql.BLOB oracle.jdbc.driver.OracleBlobInputStream java.io.ByteArrayOutputStream org.fugerit.java.core.io.helper.StreamHelper groovy.sql.Sql Notice I used a helper...

Thanks a lot for spending time in posting this example. Actually after customizing query and ds name, i get an error while getting connection at line 9 : conn = DbConnections.getConnection("blob datasource name") The error is : java.lang.SecurityException: Unexpected type: class com.zaxxer.hikari.pool.HikariProxyConnection, value = HikariProxyConnection@373013506 wrapping oracle.jdbc.driver.T4CConnection@8b54bb6a at art.utils.GroovySandbox.filter(GroovySandbox.java:159) at org.kohsuke.groovy.sandbox.GroovyValueFilter.filterReturnValue(GroovyValueFilter.java:26)...

I'm using a data source on oracle 11, and i would like to always show a blob column containing a xml (i have no control on the DDL). Imagine we have table like : CREATE TABLE blob_data ( id NUMBER(19) ,content BLOB ); And the query is something like : SELECT contet FROM blob_data WHERE id = #id# (With oracle 11 there is no default function for converting blob bigger than maximum varchar2 size, 4000 character). Is it possibile, for instance using groovy, to convert the field content to a string? (maybe...

Thanks you very much for your answer

Good morning, I'm new to ART, but is it possibile to use one data base (connection) for configuration (ART schema) and one other for the actual queries? Thanks in advance.