topic Re: Ignore filter set expression not working in App Development

None

Udoborendy — Fri, 15 Nov 2024 21:01:09 GMT

bgerchikov — Wed, 27 Mar 2024 00:43:35 GMT

Hi,

First, make sure date_dt, $(vMinDate) and $(vMaxDate) have exactly the same format. Preferably numeric.

Second, make sure variables $(vMinDate) and $(vMaxDate) have values.

Third, try to use '~' instead of double quotes in set expression.

Hope, it would help.

JonnyPoole — Wed, 27 Mar 2024 02:53:36 GMT

Make sure your expression works without the PROMO_CODE modifer.

IE: Count({<date_dt={">=$(vMinDate)<=$(vMaxDate)"}>} Distinct playnow_id)

..if that work as you expect try using an empty = after the field name:

Count({<PROMO_CODE=,date_dt={">=$(vMinDate)<=$(vMaxDate)"}>} Distinct playnow_id)

..PROMO_CODE= is syntax that should ignore any PROMO_CODE selection just like as if it wasn't selected.

bgerchikov — Wed, 27 Mar 2024 17:59:48 GMT

Jonny,

'=' sign to ignore field selection is optional. So, original syntaxis is correct.

Thanks!