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

[bittutqk]

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.