how to get the projects name which are dependent on particular jira field configuration,

[soumyajit]

we have some field configuration id. but we want to know which project dependent on this field configuration, through sql.

[Kristian Walker _Adaptavist_]

Hi Soumyajit,

Thank you for your question. 

I can  confirm that the Project Configurator add on contains a Used By feature as documented here,which will allow you to see  a report of how each configuration object is used inside of your Jira instance.

I can also confirm that we have  a demonstration video outlining  how this feature works here which will help to show how this feature could achieve your requirement of seeing which projects use a sepcific field configuration. 

If this answer has solved your issue can you please accept it in order to mark this answer as correct for users who are searching for a similar issue.

Regards,

Kristian

[Nic Brough -Adaptavist-]

What are you trying to achieve with this?

I ask because the use of SQL against a Jira database is almost always the single worst way to do anything useful with it.  It's complex, messy and there is almost certainly a better way to do it (in this case, why don't you just read the list of field configurations in the admin screen?  That tells you the associations and gives you links to amend, which you don't want to do in SQL)