How can I fetch all fields from database from backend include custom fields , I am using mysql if we can do so please share the query for the same?

[utiitsl uti]

I have tryed from jiraissue table but custom fields are not showing

[Nic Brough -Adaptavist-]

You need to join it to customfieldvalue although that still won't get you everything (another join to customfieldoption is needed)

For lots more queries and detail on the schema, see https://developer.atlassian.com/display/JIRADEV/Database+Schema