Problem with parameters in jasperserver CE 3.7.0

[dodi84]

Hi all,

i have a problem and i need help with input contol in jasperserver CE 3.7.0 .. it replaces the parameters with '?' in the query... so the report does not display..

i used to work with jasperserver 3.5.0 and it was working just fine.

have any idea about this? please i really need some help

here is the query i use:

SELECT count('Record ID') as 'NumberOfRecords' , STATUS , Priority
FROM table
WHERE STATUS LIKE concat('%', $P{get_status},'%') AND 'Record Type' LIKE concat('%', $P{get_recordtype},'%') AND Priority LIKE concat('%', $P{get_priority},'%')
GROUP BY STATUS

and this is what i have in the log :

SELECT count('Record ID') as 'NumberOfRecords' , STATUS , Priority
FROM table
WHERE STATUS LIKE concat('%', ?,'%') AND 'Record Type' LIKE concat('%', ?,'%') AND Priority LIKE concat('%', ?,'%')
GROUP BY STATUS

thank a lot

[tmatyashovsky]

Hi,

 

Jasper server passed real data for the input parameters instead of ? signs. So that's not the problem.

 

Please check once more query, input parameters and fact that data exist in the db.

 

Best regards,

Taras Matyashovsky