我想按 Neo4j 中的相关性对返回的数据进行排序。
就我的目的而言,相关性可以简化为“我正在搜索的单词的索引”,其中索引越低,相关性越高。
Example
我有这三个节点:
node : {
Label: PROD
properties : {
name: "Bearing replacement Skateboard"
}
}
node : {
Label: PROD
properties : {
name: "Skateboard"
}
}
node : {
Label: PROD
properties : {
name: "L7 Skateboard"
}
}
我希望将它们与此订单一起退回:
node : {
Label: PROD
properties : {
name: "Skateboard" // name.indexOf("Skateboard") = 0
}
}
node : {
Label: PROD
properties : {
name: "L7 Skateboard" // name.indexOf("Skateboard") = 3
}
}
node : {
Label: PROD
properties : {
name: "Bearing replacement Skateboard" // name.indexOf("Skateboard") = 19
}
}
到目前为止我所拥有的:
String query = "MATCH (n:PROD) where LOWER(n.name) CONTAINS LOWER({textToSearch}) RETURN n ORDER BY LOWER(n.name) ASC LIMIT 15";
String textToSearch = "Skateboard";
Map<String, Object> queryParams = new HashMap<>();
queryParams.put("textToSearch", textToSearch);
try (
Transaction ignored = database.beginTx();
Result resultSet = database.execute(query, queryParams)
) {
Iterator<Node> results = resultSet.columnAs("n");
while (results.hasNext()) {
Node node = results.next();
/* data processing here */
}
}
这只是按名称上升顺序对结果进行排序。有没有办法告诉neo4j根据排序n.name.indexOf({textToFind})
?
在 Cypher 中做这样的事情怎么样
MATCH (n:PROD)
WHERE n.name_lc CONTAINS toLower({textToSearch})
WITH n, SPLIT(n.name_lc, toLower({textToSearch})) as parts
RETURN n.name, SIZE(parts[0]) AS leading
ORDER BY leading
为了有效利用以上...
在属性的小写版本上创建索引
CREATE INDEX ON :PROD(name_lc)
将常规名称复制为小写版本
MATCH (n:PPOD)
SET n.name_lc = toLower(n.name)
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)