PROJECTS | ||||||||
|---|---|---|---|---|---|---|---|---|
Column | ID | KEY | NAME | DESCRIPTION | CATEGORY | LEAD | URL | COUNTER |
Type | BIGINT | VARCHAR | VARCHAR | VARCHAR | VARCHAR | VARCHAR | VARCHAR | BIGINT |
Indexed | x | x | x |
|
| x |
|
|
Example
How to get all the issues? This is not possible per the JIRA,API design, There is not a Java method on the project object to get all its issues. The only way to get the project issues is by performing a JQL similar to:
project = SSP
SQL for JIRA is strictly driven by the JIRA Java API and therefore there is no way to get all the JIRA issues at once.
If you try the SQL query below a full scan exception will be raised:
select * from projects p inner join issues i on p.id=i.projectid
even if you restrict the project:
select * from projects p inner join issues i on p.id=i.projectid where p.name='SSP'
As suggested by the JIRA API pattern, the right way would be:
select * from issues where JQL='project = SSP'
As you see, SQL for JIRA has the same JIRA constraints to limit to access to the resources and compromise the JIRA performance while keeping a good balance among features and performance.