如果我想找到用户数大于平均用户数的组,我添加了where子句,但我们不能在where中使用聚合...下面是我的cypher查询:
params.put("query", "name:*");
ExecutionResult result = engine.execute( "start n=node:groups({query})
match n<-[:Members_In]-x
with n,count(distinct x) as numberOfUsers
where numOfUsers>avg(numOfUsers)
retu
我在处理复杂查询时遇到了问题;下面是我的cypher查询:
params.put("query", "name:*");
ExecutionResult result = engine.execute( "start n=node:groups({query})
match n<-[:Members_In]-x
with n,count(distinct x) as numberOfUsers
where numOfUsers>avg(numOfUsers)
return n.name,numOfUsers ", params
我有一个用户,组,组配置文件,组成员,表。
关系:
users belongs to many groups,
groups belongs to many users (name of function is groupMembers),
group has one groupProfile
我想要显示某个用户的群组以及群组配置文件和群成员计数。
目前,我有以下内容:
$userGroups = UserView::findOrFail($userId)
->groups()