Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Using a VARS in a query activity filter

salvdangelo
Level 5
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
saikatk2447661
Correct answer by
Level 4
Level 4

Hi Salvatore,

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

Regards

Saikat

View solution in original post

2 Replies
Jean-Serge_Biro
Community Advisor
Community Advisor

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

saikatk2447661
Correct answer by
Level 4
Level 4

Hi Salvatore,

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

Regards

Saikat

View solution in original post