Hi All, Facing this problem after v7 upgrade. Update database structure is showing timeout error most of the time. The error is coming before showing the list of tables that has any change. Can anyone provide some info on what kind of sql/other back end job is executed during this database update? D...

Thanks a lot!

Hi @vendimb15716755 , Could you please explain the reason behind "Function getpromoCode()". Is @promoCode coming from a calculated field? Thanks,Saikat

Check what happens if you set the opition variable to 0. If that checkox after TSDATE gets grayed out then your assumption is true. (Assuming you have not executed the database update script already)

Hi @Jonathon_wodnicki , Could you please share the process of altering Target schema with js? I remember you mentioned two js functions (something like generateSchema) in a forum post here but unfortunately I could not find that post/comment anymore. I would love to explore them. Thanks in advance,S...

Hi @Tarquinius , Put an end block after cont. delivery block.Use this in the advanced tab of end block:sqlExec("drop TABLE "+vars.tableName);vars.tableName with contain the temp table name that gets created in backend database. It will have name like wkf1163548174_64_1 Thanks,Saikat 

Hi @Abhishek_Kumar_Keshri , Sql code activity does not create temp table so you can not read the result of select statement in this way. Delete the sql code activity and just use query function in js block and run it in js activity. You can read the content of any table in the database this way. htt...

I guess the temp table thing is happening because of the check box. Please try after unchecking it.

Hi All,I am trying to add a custom attribute (Delivery Label 2) that will contain a computed value from a script during delivery like delivery label. I want to put script like <%= formatDate(new Date(), "%2D/%2M/%2Y") %> and it should put the date value in a custom attribute.   I duplicated code fro...

Use a query block and add two columns like this: And in advanced parameter, check the 4th box.