DocKey@ in SQL Direct Mail email-action Completed

Daniel Schmidt - neumeierAG

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.

 

Comments

2 comments

Date Votes
  • Comment author
    Rasmus Jensen

    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/

     

    0
  • Comment author
    Daniel Schmidt - neumeierAG

    Hi Rasmus,

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

    Have a nice weekend.

    0

Please sign in to leave a comment.