Using a VARS in a query activity filter

Avatar

Avatar

salvdangelo

Avatar

salvdangelo

salvdangelo

20-12-2017

Hi,

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

Query su VARS.JPG


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 results
I'm sure that in both the cases the filter shoud give N>0 results

Thanks in advance,

Salvatore

Jean-Serge Biron

Adhiyan

@nkur

kirti.rawat

Adobe Campaign

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

saikatk2447661

Avatar

saikatk2447661

saikatk2447661

27-12-2017

Hi Salvatore,

Use $(vars/@lastDate) instead of $(vars/lastDate).

Regards

Saikat

Answers (1)

Answers (1)

Avatar

Avatar

Jean-Serge_Biro

MVP

Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
MVP

21-12-2017

Hi Salvatore,

Exact, it is a date format type issue.

Firstly, try to force your variable to have date or datetime format (either in Javascript in the variable declaration, or in the Worfklow properties, Variables tab.

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 :

1377965_pastedImage_0.png

Regards
JS