{"id":337,"date":"2021-12-07T11:19:44","date_gmt":"2021-12-07T10:19:44","guid":{"rendered":"https:\/\/project.inria.fr\/tcypher\/?page_id=337"},"modified":"2021-12-07T11:19:44","modified_gmt":"2021-12-07T10:19:44","slug":"most-recent-replies","status":"publish","type":"page","link":"https:\/\/project.inria.fr\/tcypher\/most-recent-replies\/","title":{"rendered":"Most recent replies"},"content":{"rendered":"

Return the 20 most recent reply comments to all the posts of a person from friends or friends-of-friends created before a date.<\/p>\n

\"\"<\/a><\/p>\n

T-Cypher:<\/h4>\n

LEFT_SLICE<\/strong> 2014-01-01T08:00:00Z ON R<\/strong><\/p>\n

MATCH<\/strong> (pe1:Person)<-[hasCreator]-(po:Post)<-[replyOf]-(c:comment)<-[hasCreator]-(pe2:Person), (pe1)-[CONTINUOUS<\/strong>(k:knows*1..2)]->(pe2)<\/p>\n

RETURN<\/strong> c ORDER BY<\/strong> START(c@T) LIMIT<\/strong> 20<\/p>\n

Cypher:<\/h4>\n

MATCH (pe1:`Person`)<-[hasCreator]-(po:`Post`)<-[replyOf]-(c:`comment`)<-[hasCreator]-(pe2:`Person`), (pe1)-[k:`knows`]->(pe2) WHERE (hasCreator.tStart <= 1388563200000 AND replyOf.tStart <= 1388563200000 AND hasCreator.tStart <= 1388563200000 AND k.tStart <= 1388563200000) RETURN c LIMIT 20 UNION MATCH (pe1:`Person`)<-[hasCreator]-(po:`Post`)<-[replyOf]-(c:`comment`)<-[hasCreator]-(pe2:`Person`), (pe1)-[r0:`knows`]->(n0)-[r1:`knows`]->(pe2) WHERE (hasCreator.tStart <= 1388563200000 AND replyOf.tStart <= 1388563200000 AND hasCreator.tStart <= 1388563200000 AND r0.tStart <= 1388563200000 AND r1.tStart <= 1388563200000 AND (myFunctions.min([r0.tEnd, r1.tEnd]) – myFunctions.max([r0.tStart, r1.tStart])) > 0) RETURN c ORDER BY myFunctions.start([c.tStart, c.tEnd]) LIMIT 20<\/p>\n","protected":false},"excerpt":{"rendered":"

Return the 20 most recent reply comments to all the posts of a person from friends or friends-of-friends created before a date. T-Cypher: LEFT_SLICE 2014-01-01T08:00:00Z ON R MATCH (pe1:Person)<-[hasCreator]-(po:Post)<-[replyOf]-(c:comment)<-[hasCreator]-(pe2:Person), (pe1)-[CONTINUOUS(k:knows*1..2)]->(pe2) RETURN c ORDER BY START(c@T) LIMIT 20 Cypher: MATCH (pe1:`Person`)<-[hasCreator]-(po:`Post`)<-[replyOf]-(c:`comment`)<-[hasCreator]-(pe2:`Person`), (pe1)-[k:`knows`]->(pe2) WHERE (hasCreator.tStart <= 1388563200000 AND replyOf.tStart <= 1388563200000 AND\u2026<\/p>\n

Continue reading<\/span><\/i><\/a> <\/p>\n","protected":false},"author":2118,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-337","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/project.inria.fr\/tcypher\/wp-json\/wp\/v2\/pages\/337","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/project.inria.fr\/tcypher\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/project.inria.fr\/tcypher\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/project.inria.fr\/tcypher\/wp-json\/wp\/v2\/users\/2118"}],"replies":[{"embeddable":true,"href":"https:\/\/project.inria.fr\/tcypher\/wp-json\/wp\/v2\/comments?post=337"}],"version-history":[{"count":1,"href":"https:\/\/project.inria.fr\/tcypher\/wp-json\/wp\/v2\/pages\/337\/revisions"}],"predecessor-version":[{"id":338,"href":"https:\/\/project.inria.fr\/tcypher\/wp-json\/wp\/v2\/pages\/337\/revisions\/338"}],"wp:attachment":[{"href":"https:\/\/project.inria.fr\/tcypher\/wp-json\/wp\/v2\/media?parent=337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}