~jhpark/owl-kisa.git - maprexDevGit

			@@ -1756,6 +1756,9 @@
			String comma = ",";

			if (issueCustomFieldValueForms.size() > 0) {
			IssueCustomFieldValueFormComparator comp = new IssueCustomFieldValueFormComparator();
			Collections.sort(issueCustomFieldValueForms, comp);

			String concatUseValue = "";
			for (int i = 0; i < issueCustomFieldValueForms.size(); i++) {
			IssueCustomFieldValueForm issueCustomFieldValueForm = issueCustomFieldValueForms.get(i);
			@@ -1802,6 +1805,7 @@
			List<Issue> issues = Lists.newArrayList();
			for (Issue issueVo : issue) {
			issueForm.setId(issueVo.getId());
			issueForm.setTitle(issueVo.getTitle());

			// 자동 종료 상태 설정이 되어 있지 않으면 오류발생
			Issue modifyIssue = this.modifyIssueForApi(user, issueForm, files);

			@@ -1096,14 +1096,13 @@
			issue.id as id,
			issue.title as title,
			customFieldValue.customFieldType AS customFieldType,
			GROUP_CONCAT(customFieldValue.useValue) AS concatUseValue
			GROUP_CONCAT(customFieldValue.useValue ORDER BY customFieldValue.customFieldId ASC) AS concatUseValue
			FROM issue issue FORCE INDEX(reverseIndex)
			INNER JOIN issue_status as issStatus ON issue.issue_status_id = issStatus.id
			LEFT OUTER JOIN (
			SELECT cf.id AS customFieldId, cf.custom_field_type AS customFieldType, issue_custom.use_value AS useValue, issue_custom.issue_id AS issueId
			FROM issue_custom_field_value issue_custom
			INNER JOIN custom_field cf ON cf.id = issue_custom.custom_field_id
			ORDER BY issue_custom.id ASC) customFieldValue ON customFieldValue.issueId = issue.id
			INNER JOIN custom_field cf ON cf.id = issue_custom.custom_field_id) customFieldValue ON customFieldValue.issueId = issue.id
			WHERE issStatus.issue_status_type != 'CLOSE'
			AND issue.issue_type_id = #{issueTypeId}
			GROUP BY issue.id

	src/main/java/kr/wisestone/owl/service/impl/IssueServiceImpl.java	4 ●●●●● 패치 \| 보기 \| raw \| blame \| 히스토리
	src/main/resources/mybatis/query-template/issue-template.xml	5 ●●●●● 패치 \| 보기 \| raw \| blame \| 히스토리