{"id":342,"date":"2021-12-07T11:21:13","date_gmt":"2021-12-07T10:21:13","guid":{"rendered":"https:\/\/project.inria.fr\/tcypher\/?page_id=342"},"modified":"2021-12-07T11:21:13","modified_gmt":"2021-12-07T10:21:13","slug":"new-groups","status":"publish","type":"page","link":"https:\/\/project.inria.fr\/tcypher\/new-groups\/","title":{"rendered":"New groups"},"content":{"rendered":"

Given a person, Return the top 20 forums the friends and friends-of-friends of that person joined after a given date.<\/p>\n

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

T-Cypher query:<\/h5>\n

RIGHT_SLICE <\/strong>2010-01-01T08:00:00Z ON R<\/strong><\/p>\n

MATCH<\/strong> (p1:Person)-[K:CONTINUOUS<\/strong>(knows*1..2)]->(p2:Person)<-[:hasMember]-(f:Forum)<\/p>\n

RETURN<\/strong> f LIMIT<\/strong> 20<\/p>\n

\n
Cypher query:<\/h5>\n

MATCH (p1:`Person`)-[k:`knows`]->(p2:`Person`)<-[r0:`hasMember`]-(f:`Forum`)<\/p>\n

WHERE (k.tEnd >= 1262332800000 AND r0.tEnd >= 1262332800000)<\/p>\n

RETURN f LIMIT 20<\/p>\n

UNION<\/p>\n

MATCH (p1:`Person`)-[r0:`knows`]->(n0)-[r1:`knows`]->(p2:`Person`)<-[r2:`hasMember`]-(f:`Forum`)<\/p>\n

WHERE (r0.tEnd >= 1262332800000 AND r1.tEnd >= 1262332800000 AND r2.tEnd >= 1262332800000 AND (myFunctions.min([r0.tEnd, r1.tEnd]) – myFunctions.max([r0.tStart, r1.tStart])) > 0)<\/p>\n

RETURN f LIMIT 20<\/p>\n","protected":false},"excerpt":{"rendered":"

Given a person, Return the top 20 forums the friends and friends-of-friends of that person joined after a given date. T-Cypher query: RIGHT_SLICE 2010-01-01T08:00:00Z ON R MATCH (p1:Person)-[K:CONTINUOUS(knows*1..2)]->(p2:Person)<-[:hasMember]-(f:Forum) RETURN f LIMIT 20 Cypher query: MATCH (p1:`Person`)-[k:`knows`]->(p2:`Person`)<-[r0:`hasMember`]-(f:`Forum`) WHERE (k.tEnd >= 1262332800000 AND r0.tEnd >= 1262332800000) RETURN f LIMIT 20 UNION MATCH\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-342","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/project.inria.fr\/tcypher\/wp-json\/wp\/v2\/pages\/342","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=342"}],"version-history":[{"count":1,"href":"https:\/\/project.inria.fr\/tcypher\/wp-json\/wp\/v2\/pages\/342\/revisions"}],"predecessor-version":[{"id":343,"href":"https:\/\/project.inria.fr\/tcypher\/wp-json\/wp\/v2\/pages\/342\/revisions\/343"}],"wp:attachment":[{"href":"https:\/\/project.inria.fr\/tcypher\/wp-json\/wp\/v2\/media?parent=342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}