i would like get one of the field details of my Jira ticket in confluence page

Question

Hi,

in my confluencece table, I wanted to bring the value of one of the Jira incident fields.

I tried with Jira keyword in the confluencece, and I am only able to show it as a table in confluence.  as per the below screenshot, i should just bring a value "Plan of Intent" from Jira query as single value (not as table as shown below)

Craig Nodwell_7eve9b · Answer

I know that Scriptrunner allows for a Resource to a database.  You could then write custom macros that execute SQL against that.

Jack Brickey · Answer

I am not aware of how that could be done. I found this addon that seems to achieve what you want - smart-issue-view-for-confluence

poosarla madhav · Answer

is it possible with writing some SQL queries in the confluence?