Complex queries with function calls shows error in Query editor dialog : Jasper 5.6.0 in Jaspersoft studio
Posted on August 10, 2014 at 10:32pm
I am using the latestJaspersoft 5.6.0 studio. I have reports with complex queries involving function calls joinswith + symbol etc.
So when I am putting such queries in the query editor dialog it shows errors. The Language selected is SQL. I tried setting the language as PL/SQL also. But still it gives errors. Earlier I was working with ireport 4.0 and the queries used to work fine.
Please give feedback
Posted on August 11, 2014 at 11:19am
Just use SQL editor for the database you're using (e.g. SQL Plus) to check SQL syntax.
If you encounter an error with Studio, just create a bug report at Tracker to get the Studio fixed. Until it gets fixed, just ignore the error messages.
That's what I do.