Abhishek_Kumar_Keshri

Your achievements

0% to

Tip / to gain points, level up, and earn exciting badges like the new

Abhishek_Kumar_Keshri

Offline

Joined the community 08-05-2020

Level 1

Job title here

Location here

Badges

Accepted Solutions

Likes

Posts

Discussions

Questions

Ideas

Blog Posts

Expand more

View leaderboards

Profile

Trophy case

Top badges earned by Abhishek_Kumar_Keshri

Give Back

Ignite 1

Validate 1

Re: How to read and save data from SQL code activity - Adobe Campaign Classic

Thanks Saikat .

410

Re: How to read and save data from SQL code activity - Adobe Campaign Classic

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

459

How to read and save data from SQL code activity - Adobe Campaign Classic

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

536

Likes given to

User

Count

Learn

Documentation

Community

Support

Resources

Adobe account

Adobe