Regression with 3.7.1 about parameter content

 Hi,

I use in a query a parameter $P{CLSH} wich is got at execution time from a single select list Input Control.

One of the possible content of this parameter is :

substr(lib_nom_lie,1,decode(instr(lib_nom_lie,'('),0,length(lib_nom_lie)+1,instr(lib_nom_lie,'('))-1)

(that allows me to change the grouping level of the query by playing with the part of the field "lib_nom_lie" taken into account)

I use it in the query as follows :

select $P!{CLSH} .........

Till now no problem : this was working fine.

Since the 3.7.1 Jasperserver release, when I select the parameter input of the list corresponding to the value listed above, nothing happens : no error, but I remain on the parameter window. If I select another value for the parameter in the list, all is OK. If I test my query with this value outside Jasperserver on the same database (with sqldevelopper) , all is working well with the right results.

I tried to change the value by deleting the single quotes inside the parameter :

"substr(lib_nom_lie,1,decode(instr(lib_nom_lie,(),0,length(lib_nom_lie)+1,instr(lib_nom_lie,())-1)"

Of course this is crazy from sql point of view but if I click on "OK", then jasperserver launches my query and I get an "SQL execution error" that is normal according to my modification.

So, it seems that something has changed with the new release of Jasperserver in the parsing of the input parameters ( introduction of cascading input controls??).

Can anybody help me to fix this point : how to escape the single quotes in a parameter in Jasper. I tried with antislash. I tried also to put "\\Q')'\\E (found in the net). But nothing worked.

Thanks for any suggestion

Gaby