java - Hybris 关系型 FlexibleSearch 选择

Question

Hybris 为同一个基础商店的用户创建多个购物车。如何选择一个商店有多个购物车的用户？

稍后我会对它们进行排序并删除最旧的。

SELECT {u.code} as userCode,
       {c.code} as cartCode,
       {c.site} as cartSite
FROM {User as u join Cart as c on {u.pk} = {c.user}}
WHERE...

Answer 1

使用这个:

select {u.pk}, {b.pk}, count(distinct({c.pk})) 
from {
   user as u 
   join cart as c on {c.user} = {u.pk} 
   join basestore as b on {b.pk} = {c.store}
} 
group by {u.pk}, {b.pk} 
having count(distinct({c.pk})) > 1