Question regarding SQL query for Custom fields

HaRsHaS' V

I am trying to put the custom field data on a confluence page for an instance-that includes custom fields, their values and issue types. 

The page should contain the details and it should be updated when ever we make any change to the instance-for example if we add a new custom field it should be updated auto on the confluence page.

 

Please suggest me any SQL query for this?

 

Nic Brough -Adaptavist-

No, don't use SQL to do this, you'd need to write a complex macro to get it to run every time you refreshed or visited the page, and the SQL would be inefficient.

Why don't you just use the Jira issues macro?