We restrict SQL to start with "select" or "call" - can we also add "with" to this restriction as it doesn't pose a security threat and many customers have to add it. This should apply to both JSS SQL and Domain Derived Tables SQL.
Michael Bielkiewicz
| Components | JasperReports Server |
Look at this article: I had the same issue and I updated the security-config.properties
From
security.validation.sql.on=true
To
security.validation.sql.on=false
https://community.jaspersoft.com/forums/topic/54890-jasperserver-and-sql-query-using-with-as-clause/