Task "SQL script"
#17435
Replies: 1 comment
-
Any idea ? |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hello,
I created a task "SQL script" (the goal is to play the same request on different connections).
My script is a simply "select" and i would like to display the result of the select in the log run but what I get is this :
2022-08-23 16:36:25.971 - SQL Scripts Execute
2022-08-23 16:36:25.972 - > Execute script [/Liens production/Scripts/czczd.sql] in [twist_00AM - 11]
2022-08-23 16:36:25.972 - > Default catalog: twist_00am
2022-08-23 16:36:25.972 - > Default schema: twist_00am
2022-08-23 16:36:25.972 - Set JDBC connection auto-commit false
2022-08-23 16:36:25.972 - Execute queries (1)
2022-08-23 16:36:25.973 - -----------------> Execute query
SELECT ff.jira FROM feature_flipping ff WHERE ff.jira = 'FF-5851'
2022-08-23 16:36:26.048 - Fetch result set
2022-08-23 16:36:26.048 - 1 rows fetched
2022-08-23 16:36:26.049 - -----------------> Time: 76ms, fetched 1 row(s)
2022-08-23 16:36:26.049 - Set JDBC connection auto-commit true
2022-08-23 16:36:26.121 - > Execute script [/Liens production/Scripts/czczd.sql] in [twist_00BE]
2022-08-23 16:36:26.121 - > Default catalog: twist_00be
2022-08-23 16:36:26.121 - > Default schema: twist_00be
2022-08-23 16:36:26.122 - Set JDBC connection auto-commit false
2022-08-23 16:36:26.122 - Execute queries (1)
2022-08-23 16:36:26.122 - -----------------> Execute query
SELECT ff.jira FROM feature_flipping ff WHERE ff.jira = 'FF-5851'
2022-08-23 16:36:26.194 - Fetch result set
2022-08-23 16:36:26.194 - 1 rows fetched
2022-08-23 16:36:26.194 - -----------------> Time: 72ms, fetched 1 row(s)
2022-08-23 16:36:26.195 - Set JDBC connection auto-commit true
2022-08-23 16:36:26.266 - SQL script execute completed
I would have th result display like this for example :
jira |enabled|
FF-5851|true
Is it possible ?
Thanks,
Nicolas
Beta Was this translation helpful? Give feedback.
All reactions