Expand my Community achievements bar.

SOLVED

Using a VARS in a query activity filter

Avatar

Level 5

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

1 Accepted Solution

Avatar

Correct answer by
Level 4

Hi Salvatore,

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

Regards

Saikat

View solution in original post

2 Replies

Avatar

Level 10

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

Avatar

Correct answer by
Level 4

Hi Salvatore,

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

Regards

Saikat