사용자정의필드도 검색 가능하도록 쿼리 수정

이민희

2021-11-24 b7dfb19b01f66a450126debb0590d20f2f71f2cc

사용자정의필드도 검색 가능하도록 쿼리 수정

 src/main/java/kr/wisestone/owl/web/condition/IssueCondition.java

@@ -34,6 +34,7 @@
    private String projectType;
    private String deep;
    private Long parentIssueId;     // 상위 일감
    private String useValue;
    private List<Long> projectIds = Lists.newArrayList();
    private List<Long> issueStatusIds = Lists.newArrayList();
    private List<Long> issueTypeIds = Lists.newArrayList();
@@ -43,7 +44,6 @@
    private List<Long> departmentIds = Lists.newArrayList();
    private List<Long> registerIds = Lists.newArrayList();
    private List<String> issueIds = Lists.newArrayList();   //  이슈 목록 검색에서 사용자 정의 필드로 1차 검색한 결과를 담을때 사용
    private List<String> userCustomFields = Lists.newArrayList();
    private List<Map<String, Object>> issueCustomFields = Lists.newArrayList();
    private List<Map<String, Object>> issueCompanyField = Lists.newArrayList();
    private List<Map<String, Object>> issueIspField = Lists.newArrayList();
@@ -455,11 +455,11 @@
        this.parentIssueId = parentIssueId;
    }

    public List<String> getUserCustomFields() {
        return userCustomFields;
    public String getUseValue() {
        return useValue;
    }

    public void setUserCustomFields(List<String> userCustomFields) {
        this.userCustomFields = userCustomFields;
    public void setUseValue(String useValue) {
        this.useValue = useValue;
    }
}

 src/main/resources/mybatis/query-template/issue-template.xml

@@ -31,7 +31,7 @@
        severity.id as severityId,
        severity.name as severityName,
        severity.color as severityColor,
        issue_custom.use_value AS useValue,
        GROUP_CONCAT(issue_custom.use_value) AS useValue,
        IFNULL(temp_attached_file.attachedFileCount, 0) as attachedFileCount,
        IFNULL(temp_issue_comment.issueCommentCount, 0) as issueCommentCount
        FROM issue issue FORCE INDEX(reverseIndex)
@@ -189,6 +189,7 @@
        </choose>
        AND issue.reverse_index <![CDATA[ < ]]> 0
        AND workspace.id = #{workspaceId}
        GROUP BY issue.id
        ORDER BY issue.register_date DESC
        <if test="page != null and !page.equals('')">
            limit #{pageSize} offset #{page};