Arango AQL查询

Question

我正在创建一个类似Facebook的网站，我想为在同一所学校学习但还不是朋友的用户推荐朋友。

我已经试着用AQL查询来做这件事了，但是似乎有语法问题。

错误代码返回为：

语法错误，意外标识符在“user._key不在”(朋友在.在第3:3处(分析时)

for user in users
  filter user._key != "myself"
    user._key not in (for user in 1..1 outbound "users/myself" friendship return user) 
      user._key not in (for user in 1..1 outbound "users/myself" schoolStudies return user)
    return user

Answer 1

如果要应用多个筛选条件，则必须通过逻辑AND (或&&运算符)组合它们。

FOR user IN users
  FILTER user._key != "myself" AND
    user._key not in (for user in 1..1 outbound "users/myself" friendship return user) AND
    user._key not in (for user in 1..1 outbound "users/myself" schoolStudies return user)
  RETURN user

也可以使用单独的筛选子句。

FOR user IN users
  FILTER user._key != "myself"
  FILTER user._key not in (for user in 1..1 outbound "users/myself" friendship return user)
  FILTER user._key not in (for user in 1..1 outbound "users/myself" schoolStudies return user)
  RETURN user