Personalization Block delivery issue

[Luca_Lattarini]

Hello guys, I am trying to use the personalization block mentioned below but I am facing an issue during deliverying . If I execute the preview I have no issue. Any idea?

var article = xtk.queryDef.create(<queryDef schema="xxx:ArticleCatalog" operation="select">                                            <select>                                             <node expr={"@articleName"}/>                                             <node expr={"@articleDesc"}/>                                             <node expr={"@articlePageURL"}/>                                             <node expr={"@articleURL"}/>                                            </select>                                                                                    </queryDef>).ExecuteQuery()                                                 var articleName=article[0].@articleName 

[Marcel_Szimonisz · Accepted solution]

Hello @Luca_Lattarini,

preview will fail every time you use anything more than variables. try to send yourself a proof and if it works it works.

Also mind that doing query in personalization will cause decrease in delivery processing speed. As you query database for each recipients.

It Would be better to append this article before delivery to the targeting dimension or even better if same article is used for more recipients inject the article array as json string to the delivery from the delivery object modification script and then use it as variable?

Follow this article:

https://blog.floriancourgey.com/2018/05/how-to-add-variables-from-a-workflow-in-a-delivery



How to add variables to delivery find here

[Sukrity_Wadhwa]

Hi @Luca_Lattarini,

Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.

Thanks!