ARTICLE AD BOX
I use hibernate 6.6.29.Final and spring boot 3.5.6
I want to get a query like
but when I add the condition
cb.equal(laCaseInner.get(LawActBgEntity_.rCardBgId), root.get(LawCardBgEntity_.id)),I get an error
Could not locate TableGroup - entity.LawCardBgEntity(103)
please tell me how to fix this or if there are any alternatives for making such a query.
full code
JpaRoot<LawActBgEntity> laCaseInner = sqCaseNumberInner.from(LawActBgEntity.class); sqCaseNumberInner.multiselect(laCaseInner.get(LawActBgEntity_.caseNumber).alias("case_number")) .where(cb.and( cb.equal(laCaseInner.get(LawActBgEntity_.rCardBgId), root.get(LawCardBgEntity_.id)), cb.notEqual(cb.coalesce(laCaseInner.get(LawActBgEntity_.statusCode), cb.literal(0L)), cb.literal(15L)), cb.isNotNull(laCaseInner.get(LawActBgEntity_.caseNumber)) )).distinct(true); JpaSubQuery<String> sqCaseNumber = cq.subquery(String.class); JpaDerivedRoot<Tuple> rootCaseNumber = sqCaseNumber.from(sqCaseNumberInner); sqCaseNumber.select(cb.listagg(cb.asc(rootCaseNumber), rootCaseNumber.get("case_number"), "; ")); subquery.multiselect( sqCaseNumber.getSelection().alias("case_number"), …)