DocKey@ in SQL Direct Mail email-action

Completed

Daniel Schmidt - neumeierAG

• February 05, 2021 07:55

Hello,

I wanted to fetch the email-address in direct-mail of an email-action depending on some fields, which are filled in my documents, using a query like:
SQL: SELECT CASE..WHEN...THEN...ELSE...END...WHERE DocEntry = DocKey@

But when I´m using this statement I´m getting a syntax error near "@".
So I think the DocKey@ - Keyword isn´t translated in direct mail, which confused me, because in the mail-text I can use this Keyword without any problems.

I managed to get this working using $[$[Table].DocEntry] insted, but just wanted to know if it is planned to get this type of dynamic syntax working evrywhere.

 

Thanks for your feedback.

 

Vote

0

• 

  Rasmus Jensen

  • February 05, 2021 07:58

  Hi Daniel

  This is included in the upcoming B1UP 2021.02 release that is out next week :-) ... From the changelog: 

  - B1 Print and Delivery
  - Added option to use the DocKey@ keyword and other special keywords in the Direct Email Field [TFS48198]

  If you want to try the preview it is out here and now: https://download.boyum-it.com/b1up/preview/

   
• 

  Daniel Schmidt - neumeierAG

  • February 05, 2021 08:02

  Hi Rasmus,

  wow - that was quick.
  Thanks for the answer  - I really appreciate it!

  Have a nice weekend.

Please sign in to leave a comment.