net.sf.jasperreports.engine.JRException: com.mongodb.util.JSONParseException:

Hello,

I am getting when executing following mongo query

{
collectionName : 'transformed_col',
findQuery : {
'app_code' : '$P!{p_application_name}',
'run_date' : (new SimpleDateFormat("yyyy-MM-dd").format(org.apache.commons.lang.time.DateUtils.addDays($P{p_report_date},-0))) + "T00:00:00"
}
}

Here
app_code is string
run_date format is "2018-05-01T00:00:00"

When adding single quote (') for rundate it excutes but does not return data.

e.g.
{
collectionName : 'transformed_col',
findQuery : {
'app_code' : '$P!{p_application_name}',
'run_date' : '(new SimpleDateFormat("yyyy-MM-dd").format(org.apache.commons.lang.time.DateUtils.addDays($P{p_report_date},-0))) + "T00:00:00"'
}
}


Thanks for the help in advance.

bittutqk's picture
Joined: Dec 14 2012 - 11:33am
Last seen: 3 years 9 months ago

0 Answers:

No answers yet
Feedback