| | |
| | | select |
| | | distinct i.id as id, |
| | | i.title as title, |
| | | i.issue_type_id as issueTypeId, |
| | | p.name as projectName, |
| | | CONCAT(p.project_key, '-', i.issue_number) AS issueKey, |
| | | p.project_key as projectKey, |
| | |
| | | CONCAT(p.project_key, '-', i.issue_number) AS issueKey, |
| | | i.issue_number as issueNumber, |
| | | p.project_key as projectKey, |
| | | p.name as projectName |
| | | p.name as projectName, |
| | | i.issue_type_id as issueTypeId |
| | | from issue i |
| | | inner join issue_risk ir on ir.issue_id = i.id |
| | | inner join issue_status iss on iss.id = i.issue_status_id |
| | |
| | | , i.issue_number as issueNumber |
| | | , p.project_key as projectKey |
| | | , CONCAT(p.project_key, '-', i.issue_number) AS issueKey |
| | | , i.issue_type_id as issueTypeId |
| | | </if> |
| | | FROM issue i |
| | | <if test="page != null and !page.equals('')"> |
| | |
| | | , iss.name as issueStatusName |
| | | , i.issue_number as issueNumber |
| | | , p.project_key as projectKey |
| | | , i.issue_type_id as issueTypeId |
| | | , CONCAT(p.project_key, '-', i.issue_number) AS issueKey |
| | | </if> |
| | | FROM issue i |
| | |
| | | </when> |
| | | </choose> |
| | | ,p.id, |
| | | p.name as projectName |
| | | p.name as projectName, |
| | | i.issue_type_id as issueTypeId |
| | | from issue i |
| | | inner join project p on p.id = i.project_id |
| | | inner join issue_status iss on iss.id = i.issue_status_id |
| | |
| | | </when> |
| | | </choose> |
| | | ,p.id, |
| | | p.name as projectName |
| | | p.name as projectName, |
| | | i.issue_type_id as issueTypeId |
| | | from issue i |
| | | inner join project p on p.id = i.project_id |
| | | inner join issue_status iss on iss.id = i.issue_status_id |
| | |
| | | p.project_key AS projectKey, |
| | | p.name AS projectName, |
| | | iss.name AS issueStatusName, |
| | | CONCAT(p.project_key, '-', i.issue_number) AS issueKey |
| | | CONCAT(p.project_key, '-', i.issue_number) AS issueKey, |
| | | i.issue_type_id as issueTypeId |
| | | FROM issue i |
| | | INNER JOIN project p ON p.id = i.project_id |
| | | INNER JOIN workspace w ON w.id = p.workspace_id |
| | |
| | | p.project_key AS projectKey, |
| | | p.name AS projectName, |
| | | iss.name AS issueStatusName, |
| | | CONCAT(p.project_key, '-', i.issue_number) AS issueKey |
| | | CONCAT(p.project_key, '-', i.issue_number) AS issueKey, |
| | | i.issue_type_id as issueTypeId |
| | | FROM issue i |
| | | INNER JOIN project p ON p.id = i.project_id |
| | | INNER JOIN workspace w ON w.id = p.workspace_id |