Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Abhishek_Kumar_Keshri
Abhishek_Kumar_Keshri
Offline

Badges

Badges
3

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts & Comments

Posts & Comments
3

Discussions

Discussions
0

Questions

Questions
1

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by Abhishek_Kumar_Keshri
Customize the badges you want to showcase on your profile
Re: How to read and save data from SQL code activity - Adobe Campaign 14-02-2021
Thanks Saikat .

Views

771

Likes

0

Replies

0
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

Views

820

Likes

0

Replies

0
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

Views

897

Likes

0

Replies

4
Likes given to