Hi, Which would it be the best approach to audit all the client interactions (react app) in the graphs? a) have a node or relationships with dates and down there with the sessionId have all the actions (login, search, create, logout) i guess nodes but in the same level b) or have nodes that have …

You could query the sessions with a predicate that sets boundaries on the timestamp for the timeframe you want. And you should then index that property. That should perform adequately. See here for an example of a range query: https://neo4j.com/docs/cypher-manual/current/clauses/where/#composite-ra…

Hi @undefined21 , The general rule-of-thumb for data modeling applies equally well to graphs: model the data so that it is easy and efficient to answer questions. What questions do you want to ask that the data can answer? A good way to start is by literally sketching a representative sample of th…

Hi thanks for the response! After some read, this is what I get as a first sketch, [Screenshot 2021-05-06 at 16.15.35] With that graph I could achieve mainly everything that I want, get all user events in each session or group by user. But what about if we want to get the sessions in some timef…

Thanks @abk ! That's a nice response, lot of content there... The first approach seems easier but we have to add the index which I do not know how it could affect the memory and performance perspective in Neo4j (I need to read about the pros & cons hahah). I think, I like more the second approach a…

[image] Neo4j TimeTrees cannot extract the result Cypher Hi, I am quite new with that technology and I would like to extract from my small graph the following session(blue ones) nodes. [Screenshot 2021-05-25 at 16.57.51] This is my query: get the sessions between 2021-…

The 'Audit' node has no connection to Year, month, day nodes. 'Profile' only has the connections per your screenshot. Try this: MATCH (a:Audit)-[rel:HAS_AUDIT]->(u:Profile { uuid: "xxxxxxxxx" }) MATCH (u)-[:HAS_YEAR]->(:Year {year: 2021})-[:HAS_MONTH]->(m:Month {month: 5}) -[:HAS_DAY]->(d:Day…

That query works! I was obvious (after see it) to use where clause, thanks for your time

CURRENT SUBMISSIONS ✦ @mabu.mate Apple HealthGraph Agent ✦ @venkatasaiprasadp DepGraph Agent ✦ @dhiraj.patra RegulatoryRisk GraphAgent ✦ @shantanunitw01 CineGraph AI ✦ @jevlachov Korca Triage Agent ✦ @deanfoulds Japan Seismic Risk Intelligence Graph ✦ @jonas.koenner ConspiracyGraph Agent ✦ Submit your Aura Agent Project to appear here @mabu.mate Apple HealthGraph Agent ✦ @venkatasaiprasadp DepGraph Agent ✦ @dhiraj.patra RegulatoryRisk GraphAgent ✦ @shantanunitw01 CineGraph AI ✦ @jevlachov Korca Triage Agent ✦ @deanfoulds Japan Seismic Risk Intelligence Graph ✦ @jonas.koenner ConspiracyGraph Agent

Neo4j Online Community

Client UI Audit

Neo4j Graph Platform Modeling

undefined21 (Undefined_21) May 25, 2021, 3:10pm 6

Topic		Replies	Views
Neo4j TimeTrees cannot extract the result Cypher	6	538	June 3, 2021
Relation on nodes with respect of time Neo4j Graph Platform cypher	4	364	May 19, 2021
How to compare datetime with only month and day in Cypher Cypher cypher , knowledge-base	17	417	April 17, 2024
Slow performance on time series queries Cypher performance , cypher	6	2968	January 28, 2019
How to get nodes between time range using relationship properties Cypher cypher	3	1810	January 5, 2020

Take the Course Then Join The Aura Agent Hackathon

Client UI Audit

Related topics

Take the Course Then Join
The Aura Agent Hackathon