Discussions

More than 1 logical expression in Data Directive

Phil Allen
Phil Allen Posts: 3 Green Ribbon
edited May 2, 2022 6:14AM in Responsys

Hi,

I am using Data Directive to join to an Array and a Supp Table together.

I have two join conditions:

  1. ARRAY.ID = SuppSOURCE.ID
  2. SuppSOURCE.DATE = today

where today is an assigned var:

  • <#assign today = .now?date?iso_utc >

<#filter ID = array.id && DATE = today >

For completeness, I have shown the filter condition above. The error thrown is:

Expecting a boolean (true/false) expression here Expression array.id does not evaluate to true/false it is an instance of freemarker.template.SimpleNumber

If I have one of either filter expression it works. It doesn't seem to accept both.


Any ideas?

Post edited by OIT Integration User on