Use function SQL with temporal param in jaspersoft studio

[Remi13]

Hello,

I want to know if is possible to use the function of postgreSQL?

in studio, I don’t see my SQL functions, no problem to see tables and views...

I use a lot of functions to generate lists with time parameters like: buyers('start_date', 'date_end', 'id_product') I don’t find how to use these functions in reports...

 

Thanks for your help!

[danoldenkampgmail.com]

Are you calling the function first or mid query?

Are you getting a SQL validator error?

Set SQL validation off on the Jasper server.

     WEB-INFclassesesapisecurity-config.properties

     security.validation.sql.on=false

(note that this will also allow update / delete queries, but see if this fixes the issue)