I'm trying to execute a query on nms:broadLogRcp table with a filter @eventDate AFTER $(vars/lastDate)where vars.lastDate is a global variable set in JS code in this way:
vars.lastDate = getOption("lastDateOption");with lastDateOption -> DateTime type
The issue is that I always get 0 results from this query
You are able to understand how can I solve?
I believed that the problem was the DATE format, but I use a similar filter with a Integer number and I still get no resultsI'm sure that in both the cases the filter shoud give N>0 results
Thanks in advance,
Use $(vars/@lastDate) instead of $(vars/lastDate).
Exact, it is a date format type issue.
Otherwise use the formatDate or other JS methods to convert to date. But if it is in the Query activity wizard, use the ToDateTime in the Expression editor :