since ‎13-10-2020
‎13-10-2020
Sinhue
Level 1
Re: SqlSelect Function Javascript doesn't retrieve above... Sinhue - Adobe Campaign Classic
Hi @_Manoj_Kumar thanks for you answer, but how can I do that?, the purpose of my javascript code is to get the date difference between rows.
80
Views
0
Likes
0
Comments
SqlSelect Function Javascript doesn't retrieve above 70000 rows. is that possible? Sinhue - Adobe Campaign Classic
Hi everyone I have this javascript code after an enrichment activity:// select rows of the last transition var sql = "SELECT sVin,sMktSale,iCountVehicles,sDayDifference,tsDelivery,coalesce(tsDelivery - lag(tsDelivery) over(partition by sCustomerId order by tsDelivery), 0) as Difference FROM " + vars.tableName; var contracts = sqlSelect("resultQuery,@vin:string,@MktSale:string,@CountVehicles:int,@DayDifference:string,@deliveryDate:date,Difference:string", sql); // // Iterate each row for each(var...
96
Views
0
Likes
4
Answers and Comments
Likes given to