union returning dto

[milesif]

Hi,

I have this query

FinalSetOperationCriteriaBuilder<PayrollEntryDto> mainQuery =
                cbf.create(em, PayrollEntryDto.class)
                        .from(SessionAttendance.class, "sa")
                        .joinOn(Person.class, "p", JoinType.INNER).setOnExpression("p.id=sa.idPerson and sa.role='tch'")
                        .select("sa.id", "id")
                        .select("p.id", "pid")
                        .union()
                        .from(Event.class, "ev")
                        .join("ev.owner", "p", JoinType.INNER)
                        .select("ev.id", "id")
                        .select("p.id", "pid")
                        .endSet()
                        .orderBy("id", true);

which works but returns a tuple insteadof PayrollEntryDto, which is a simple dto class (not an entity nor a CTE). I do not understand what I am missing.

thanks for your help

[jwgmeligmeyling]

In order to project to a DTO you either need to use the ObjectBuilder API, the selectNew method or Blaze-Persistence EntityView. The ObjectBuilder API is a bit like Hibernates ResultTransformer.