ahmad.kassyd

Adding properties to parameters always fails. And the property is added to the report itself not the parameter

By "a list of ($field $operator $value) expressions" I mean that there are more than one expression for example "( x = "a" and y <=10) or z is null" and so on. The second thing, values in expressions are not all strings, some are binary data, some are numbers, etc. Also, your solution will make my reports vulnerable to sql injection. Thanks a lot for your time.

What I am trying to achieve is add a dynamically created criteria to the report query. The user designs the criteria using a GUI, she can add a list of ($field $operator $value) expressions. What would be the best way to achieve this? I do not want to change the report design by adding the new parameters and changing the query. What I need is to pass a parameter with the criteria; and then provide the positional parameters to the JDBC statement. Of course there is the problem of finding what are the indices of my parameters; but we will cross that bridge when we come to it. Thanks

You could use this utility class https://sourceforge.net/projects/jaspermirror/files/

I modified your code a little bit to fit the same purpose. I am posting it here in hope it might help someone. (http://jaspermirror.sourceforge.net/)