Project

General

Profile

Bug #2037

Bug in QueryBuilderImpl when counting

Added by Maurício Dos Santos almost 9 years ago. Updated almost 9 years ago.

Status:
Closed
Priority:
Normal
Target version:
Start date:
08/11/2016
Due date:
% Done:

0%

Complexity:

Description

Eu incluí no método QueryBuilderImpl.createHQLCount() o trecho abaixo

        if (hqlJoin != null) {
            s.append(hqlJoin);
            s.append('\n');
        }

Esse trecho esta causando um erro em um teste relacionado ao AdministrativeUnit.

Eu precisei incluir esse trecho pois no método TagCasesReportService.getTagCases eu acrescento uma restriction relacionada ao Join. Veja:

    public QueryResult getTagCases(TagCasesQueryParams qryParams) {
        QueryBuilder<TbCase> builder = queryBuilderFactory.createQueryBuilder(TbCase.class);

        builder.setHqlSelect("select c");
        builder.setEntityAlias("c");
        builder.addDefaultProfile("caseitem", CaseItem.class);

        *builder.setHqlJoin("join c.tags t");*
        *builder.addRestriction("t.id = :tId", qryParams.getTagId());*
        builder.addRestriction("c.ownerUnit.id = :unitId", qryParams.getUnitId());
        //TODO: builder.addRestriction("c.ownerUnit.ADMINUNIT = :unitId", qryParams.getAdminUnitId());

        builder.initialize(qryParams);
        return builder.createQueryResult();
    }

Sem essa condição e join no count eu terei um numero errado.

History

#1 Updated by Ricardo Memoria almost 9 years ago

  • Status changed from New to Closed

Fixed...

Also available in: Atom PDF