Hello I'm doind report using Pentaho Report Designer 9.30.-428 and making Queries diretly to a MariaDB database . Most of the querie resolves corrctly but when I try a subquery that returns a TEXT field, the PRD interpret it as CLOB and it show a serie of Hexadecimal numbers instead of o the text.
I tried changing the results by using SQL commands like CAST and CONVERT but no matter what, the results always returns as CLOB and in that weird format.
Do you know how can I solve this problem?