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

Likes
0

Posts

Posts
3

Discussions

Discussions
0

Questions

Questions
3

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
Avatar
Give Back
Level 1
Abhishek_Kumar_Keshri
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
View profile
Abhishek_Kumar_Keshri
- Adobe Campaign Classic
Thanks Saikat .

Views

410

Likes

0

Replies

0
Re: How to read and save data from SQL code activity
Avatar
Give Back
Level 1
Abhishek_Kumar_Keshri
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
View profile
Abhishek_Kumar_Keshri
- 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

Views

459

Likes

0

Replies

0
How to read and save data from SQL code activity
Avatar
Give Back
Level 1
Abhishek_Kumar_Keshri
Level 1

Likes

0 likes

Total Posts

3 posts

Correct reply

0 solutions
Top badges earned
Give Back
Ignite 1
Validate 1
View profile
Abhishek_Kumar_Keshri
- 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

Views

536

Likes

0

Replies

4
Likes given to