我有這個方法： public List<IncomeChannelCategoryMap> allIncomeChannels(final List<String> list) { final CriteriaQuery<IncomeChannelCategoryMap> criteriaQuery = builder.createQuery(IncomeChannelCategoryMap.class); final Root<IncomeChannelMapEntity> root = criteriaQuery.from(IncomeChannelMapEntity.class); final List<Selection<?>> selections = new ArrayList<>(); selections.add(root.get(IncomeChannelMapEntity_.incomeChannel).get(IncomeChannelEntity_.code)); selections.add(root.get(IncomeChannelMapEntity_.logicalUnitCode)); selections.add(root.get(IncomeChannelMapEntity_.logicalUnitIdent)); selections.add(root.get(IncomeChannelMapEntity_.keyword)); criteriaQuery.multiselect(selections); Predicate codePredicate = root.get(IncomeChannelMapEntity_.incomeChannel).get(IncomeChannelEntity_.code).in(list); criteriaQuery.where(codePredicate); return entityManager.createQuery(criteriaQuery).getResultList(); }響應是這樣的：[{ "incomeChannelCode": "DIRECT_SALES", "logicalUnitCode": "R_CATEGORY", "logicalUnitIdent": "7" }, { "incomeChannelCode": "DIRECT_SALES", "logicalUnitCode": "R_CATEGORY", "logicalUnitIdent": "8" }]我想要實現的是： { "incomeChannelCode": "DIRECT_SALES", "logicalUnitCode": "R_CATEGORY", "logicalUnitIdent": "7,8" }有什么建議我怎樣才能實現這個目標？我嘗試過這個，我在一些例子中發現了這一點：builder.function("group_concat", String.class, root.get(IncomeChannelMapEntity_.logicalUnitIdent));但這是行不通的。還有其他建議嗎？@Data@Builder@NoArgsConstructor@AllArgsConstructorpublic class IncomeChannelCategoryMap implements Serializable { private static final long serialVersionUID = 1L; private String incomeChannelCode; private String logicalUnitCode; private String logicalUnitIdent; private String keyword;}
2 回答
鳳凰求蠱
TA貢獻1825條經驗 獲得超4個贊
嘗試這個：
ArrayList<IncomeChannelCategoryMap> list = entityManager.createQuery(criteriaQuery).getResultList();
List<IncomeChannelCategoryMap> finalList = new ArrayList<>(list.stream().collect(
Collectors.toMap(IncomeChannelCategoryMap::getIncomeChannelCode, Function.identity(), (IncomeChannelCategoryMap i1, IncomeChannelCategoryMap i2) -> {
i1.setLogicalUnitIdent(i1.getLogicalUnitIdent()+","+i2.getLogicalUnitIdent());
return i1;
})).values());
return finalList;
注意：請相應地添加您的 getter 方法，我只是假設您有這些方法名稱。
慕后森
TA貢獻1802條經驗 獲得超5個贊
您應該使用本機查詢方法，正如我在上一個問題中建議的那樣：
public List<IncomeChannelCategoryMap> allIncomeChannels(final List<String> list) {
List<Object[]> resultList = entityManager.createNativeQuery(
"select income_channel_code, logicalunit_code, string_agg(logicalunitident,',') idents, keyword from r_income_channel_map where income_channel_code in (:codes) group by logicalunit_code, income_channel_code, keyword")
.setParameter("codes", list).getResultList();
return resultList.stream().map(IncomeChannelCategoryMap::new).collect(Collectors.toList());
}
您需要將此構造函數添加到您的IncomeChannelCategoryMap類中：
IncomeChannelCategoryMap(Object[] objects) {
this.incomeChannelCode = (String) objects[0];
this.logicalUnitCode = (String) objects[1];
this.logicalUnitIdent = (String) objects[2];
this.keyword = (String) objects[3];
}
添加回答
舉報
0/150
提交
取消