You have a report with two parameters:
USER_PARAMETER: string for prompt
INTERNAL_PARAMETER: string without prompt; with default expression "where name = $${USER_PARAMETER}"
The query text is:
select * from people $P!{INTERNAL_PARAMETER}
This runs fine.
But when you click the query's Read Fields button, it transforms $${USER_PARAMETER} to $param_USER_PARAMETER instead of send $P{USER_PARAMETER} to the query executer that will transform it to a question mark, causing a SQL error. This transformation is done in AInterpreter.java.
Recommended Comments