SHOW QUERY,这里有社区用户常用的 nGQL 查询语句

  • 语句 1
    • 场景:用 GO 做多 tag 的条件筛选
    • 具体语句:
    GO FROM <A>/* 这里需要是id */ over com WHERE $^.acc.time >= "" yield e1._dst AS dst, $^.acc.flgid AS flgid
    | GO FROM $-.dst OVER com REVERSELY WHERE $^.acc.time >= "" AND $^.acc.timeflg==0 AND $-.flgid=$.comtag.flgid /*其他过滤属性同理*/ YIELD $-.src AS A, com._src AS B
    UNION
    
  • 语句 2
    • 场景:GO 语句查询结果将起始点和终点合成一个列表
    • 具体语句(:warning:下面语句的括号记得加上):
    (GO FROM a  OVER H BIDIRECT YIELD src(edge) as src UNION GO FROM  a OVER H BIDIRECT  YIELD dst(edge) as src) | GO FROM $-.src OVER H  YEILD dst(edge)
    
  • 语句 3
    • 场景:查询多个点的共同邻居
    • 具体语句:
    MATCH (v)--(v2) WHERE id(v2)=="player100" RETURN DISTINCT id(v) 
    INTERSECT MATCH (v)--(v2) WHERE id(v2)=="team203" RETURN DISTINCT id(v) 
    INTERSECT MATCH (v)--(v2) WHERE id(v2)=="player101" RETURN DISTINCT id(v)
    
1 个赞