MySQL 8.0 query Retrieve project schemes categories for all jira projects via the database

Question

Hello Team,

Ex:

-----------------+---------------+---------------------------------------------------------------+---------------------+--------------------------------------------------+-------------------------------------------+-----------------------------+------------------------------------------------------+------------------------------------------+-----------------+-------------------------------------------------------------------------

veereshpatil0101 · Answer

I want to have an overview of the jira project configuation.

So a list of all project names, leads and then which workflow scheme, issuetype scheme, screen scheme and permission scheme, notification scheme, they are using.

Nic Brough -Adaptavist- · Answer

You need to stop trying to use the database, it's the wrong way to report on anything.  You want to report on something, but you have not told us what or why.  If you could tell us what you are trying to do, we may be able to help.

veereshpatil0101 · Answer

@Nic Brough -Adaptavist-

I need MySql query to retrieve the project associated all schemes.