Dunning Wixard issue with - $[BOY_DUNNING_CARDCODE] Error
Hi,
I am trying to use an email condition in the Dunning Wizard to select different email drafts using the B1UP email condition.
When I reference $[BOY_DUNNING_CARDCODE], I receive an “unknown error”. I have tried multiple approaches but continue to encounter the same issue.
Please note that $[BOY_DUNNING_LETTERLEVEL] is working correctly and returns the expected values.
Below is the query I am currently using:
SELECT
CASE
WHEN OCRD."LangCode" = '22' AND $[BOY_DUNNING_LETTERLEVEL] = 1 THEN 'TEST1'
WHEN OCRD."LangCode" = '22' AND $[BOY_DUNNING_LETTERLEVEL] = 2 THEN 'TEST2'
WHEN OCRD."LangCode" = '22' AND $[BOY_DUNNING_LETTERLEVEL] = 3 THEN 'TEST3'
WHEN OCRD."LangCode" <> '22' AND $[BOY_DUNNING_LETTERLEVEL] = 1 THEN 'Level1'
WHEN OCRD."LangCode" <> '22' AND $[BOY_DUNNING_LETTERLEVEL] = 2 THEN 'Level2'
WHEN OCRD."LangCode" <> '22' AND $[BOY_DUNNING_LETTERLEVEL] = 3 THEN 'Level3'
END
FROM OCRD
WHERE OCRD."CardCode" = $[BOY_DUNNING_CARDCODE];
If I enclose $[BOY_DUNNING_CARDCODE] in single quotes, the variable is no longer resolved and the CardCode is not picked up.
Could you please advise what the issue might be and how $[BOY_DUNNING_CARDCODE] should be referenced correctly within a B1UP email condition?
0
Iniciar sesión para dejar un comentario.
Comentarios
0 comentarios