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- · Accepted solution]

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?

[HaRsHaS' V]

@Nic Brough -Adaptavist- , thanks for responding. So, Jira issue macro will just just an list of issues and it is dynamic in nature

Let me give you a background. I am working on a documentation, where we are trying to keep just the configuration details

example 1: projects-issue types used

example 2: custom fields> Field values> type of field> issue types associated.

This is what i am looking for..I know its crazy...if any more thoughts..would appreciate it.

But thanks for the reply-appreciate it!!.