Need MYSQL Query

Question

Hi All,

I need mysql Query for jira to fetch out all my custom fields which are used by last six month and also unused custom field from last six month

brbojorque · Answer

Hi @Mahendar ,

You can create your own query through the help of the JIRA Schema it should be the same as other database vendors I believe.

Here's the link to the schema.

https://developer.atlassian.com/server/jira/platform/database-schema/

-

To be honest I don't see any date created column in the schema.