Neo4j密码查询具有基于性别的不同关系

Question

在家谱中，我们使用DNA来查找匹配项。Y-DNA发现父系匹配。执行此操作的neo4j查询（其中RN是一个人的唯一标识符）是：

MATCH (n{RN:1}) match p=n-[r:father*..22]->m return m.RN as RN,m.fullname as FullName,m.sex as Sex,m.bd as BD,m.dd as DD,length(p) as generation,case when left(m.bd,4)>'1930' and rtrim(m.dd)='' then 'Y' else 'N' end as mtDNA_Candidate, reduce(srt2 ='|', q IN nodes(p)| srt2 + q.RN + '|') AS PathOrder order by generation desc,PathOrder desc

或者我们使用线粒体DNA进行母系匹配：

`MATCH (n{RN:1}) match p=n-[r:mother*..22]->m return m.RN as RN,m.fullname as FullName,m.sex as Sex,m.bd as BD,m.dd as DD,length(p) as generation,case when left(m.bd,4)>'1930' and rtrim(m.dd)='' then 'Y' else 'N' end as mtDNA_Candidate, reduce(srt2 ='|', q IN nodes(p)| srt2 + q.RN + '|') AS PathOrder order by generation desc,PathOrder desc`

我的问题与X染色体DNA有关。父亲只给女儿一条X染色体，母亲给所有孩子一条。因此，我需要一个密码查询，当在最近的时间一代中有一个女儿时，它可以得到所有母亲的，但只有父亲的。如果有一个儿子在后一代，那么我排除了父亲。我在节点中有一个属性"sex"，其值为M或F。出生日期并不总是已知的，因此不能用于确定方向性

我试过这个，但得到一个错误：

`MATCH (n{RN:1}) match p=n-[r:mother*..22|father*..1]->m return m.RN as RN,m.fullname as FullName,m.sex as Sex,m.bd as BD,m.dd as DD,length(p) as generation,case when left(m.bd,4)>'1930' and rtrim(m.dd)='' then 'Y' else 'N' end as mtDNA_Candidate, reduce(srt2 ='|', q IN nodes(p)| srt2 + q.RN + '|') AS PathOrder order by generation desc,PathOrder desc`

Answer 1

[更新]

[r:mother*..22|father*..1]语法是非法的。Cypher查询中的关系最多只能有一个可变长度的规范，并且它必须在关系类型之后。（此外：还要注意，[:father*..1]与[:father]相同）。

这个看起来在逻辑上等价的查询对你有用吗？

MATCH pf=(n { RN:1 })-[:father]->()
MATCH pm=n-[:mother*..22]->()
WITH [pf] + COLLECT(pm) AS paths
UNWIND paths AS p
WITH LENGTH(p) AS generation, NODES(p) AS ancestors
WITH generation, ancestors, LAST(ancestors) AS m
RETURN m.RN AS RN, m.fullname AS FullName, m.sex AS Sex, m.bd AS BD, m.dd AS DD, generation,
  CASE WHEN left(m.bd,4)>'1930' AND rtrim(m.dd)='' THEN 'Y' ELSE 'N' END AS mtDNA_Candidate,
  reduce(srt2 ='|', q IN ancestors | srt2 + q.RN + '|' ) AS PathOrder
ORDER BY generation DESC, PathOrder DESC;