Abhishek_Kumar_Keshri

Re: How to read and save data from SQL code activity - Adobe Campaign 14-02-2021

Thanks Saikat .

771

Re: How to read and save data from SQL code activity - Adobe Campaign 05-02-2021

Hi Craigthonis, Here is the error which I am getting:- . Below is the JS code that I am using for the same var query=xtk.queryDef.create();var res = query.ExecuteQuery();for each(var result in res){logInfo(res.sql.@relname);logInfo(res.sql.@last_vacuum);logInfo(res.sql.@last_autovacuum);logInfo(res.sql.@last_analyze)logInfo(res.sql.@last_autoanalyze);} Thanks & Regards Abhishek Keshri

820

How to read and save data from SQL code activity - Adobe Campaign 04-02-2021

Hi, I try query def in js but JS code giving an errorNeed JS to read and save output coming from below SQL. Workflow Image:- SQL code activity contains:-SELECT relname,last_vacuum,FROM pg_stat_all_tablesWHERE schemaname = 'common'ORDER BY last_vacuum DESC; Thanks & Regards Abhishek Keshri

897

Likes given to

User

Count

Learn

Documentation

Community

Support

Resources

Adobe account

Adobe