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

[veereshpatil0101]

---

Hello Team,

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

Ex: 

projectname | projectlead | fieldlayoutscheme | issuesecurityscheme | issuetypescreenscheme | issuetypescheme | notificationscheme | permissionscheme | priorityscheme | projectcategory | workflowscheme                              

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

 ADJAS | JIRAUSER10000 | | | ADJAS: Scrum Issue Type Screen Scheme | | Default Notification Scheme | Default software scheme | | | jdg-schema-for-project-adjamdjamensis

 ADRYSA | JIRAUSER10000 | | | ADRYSA: Scrum Issue Type Screen Scheme | | Default Notification Scheme | Default software scheme | | Linking_CatTwo | jdg-schema-for-project-adryasa

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

Schemes do not have categories, so I'm a bit stuck on what you are actually asking for here.

[veereshpatil0101]

@Nic Brough -Adaptavist- 

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

[Nic Brough -Adaptavist-]

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]

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.