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.