Hello @SorenDP ,it's because SQL performs integer division.you have to ''trick'' sql into thinking that on your division ther is at least one float.Try this : ToDouble(151)/7 or this with your formula : Ceil(ToDouble((WeekDay(GetDate())+1 + DayOfYear(GetDate()))) / 7)results : Br,

Hello @Sukrity_Wadhwa, Thank you for your encouragement.Br, Amine

Hello @montezh2001, I see two issues in your xtk.session.Write, the "vars.targetSchema" should be " {vars.targetSchema.split(':')[1]} ", and the identifier used to update your rows. As i understand from your request, the identifier of your temporary table is "clientId" and not "id", so your script s...

@montezh2001, Something like this would work for you :var query = xtk.queryDef.create( <queryDef schema={vars.targetSchema} operation="select"> <select> <node expr="@id"/> //or any identifier of the workflow's temporary table <node ex...

Hello @montezh2001  the type of your ''res'' variable is xml and the replace function works only on string variables. You have to convert your xml variable to a string one like this :var res = results[0].@image1.toXMLString();  result :  Br, Amine 

Hello @Luca_Lattarini, You can not use querydef in your email. However you can achieve what you are trying to do by using the same method explained here. Br Amine

Hello @SushantTrimukheD, if you don't ask explicitly Adobe Campaign to add the audit trail (by adding "<element aggregate="xtk:common:auditTrail" name="auditTrail"/>" in the schema) it won't do it. Br, Amine

Hello @davidh2892249 , Yes there is a better way, you can use the OOTB Personalization tab in delivery properties to query your schema,get the coresponding line for your delivery and store it in a Javascript object that you can use in your HTML :  Br, Amine

Aristide, Exactly. you can find Batch api doc here . Br, Amine

Hello @Prasanna_Soni, if it does not impact other applications around Adobe Campaign I do not see any inconvenience. Br, Amine