Neeed SQL query to fetch the projects having Test issue type

[Naveen_LK]

Hi All,

Neeed SQL query to fetch the projects which are having Test issue type with the Count of the the Test issues and project admins list of those projects.

Thanks

Naveen L K

[sukkeong]

SQL? Are you attempting to query for data directly from the database?

[Naveen_LK]

Yes

Even if i get SQL query for project list with number of tests in each project, it will be helpful

[sukkeong]

I would not recommend performing query directly to the database. Querying through the application, i.e. using JQL in a REST API call would allow use of the same datamodel abstraction users experience through JIRA.

IMHO,

• querying directly from the DB is not scalable or portable if and whenever Atlassian updates the DB schema.
• access to DB should be restricted to the application as good security practice.