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✦ @svignesh.8397Outbreak Analysis✦ @ramrajArt Provenance Agent✦ @serah.elrashidiGraphImmune Trust Agent✦ @anudhyandatta2021MovieGraph Agent✦ @sadashivbAthlete Nutrition Intelligence✦ @agung_sidharta_gungzSybil-Hunter Fraud Agent✦ @bhattacharya.ananya0OSS Sentinel✦ @abimael.carrasquilloJibarito Agent✦ @leongkwokhingTabletopGameRecommender✦ @strawberrychewyMental Health Assistant✦ @bruno.henrique.britoNeoSmith✦ @kitushenoyLifeGraph✦ @neerajchormale39GymBuddy✦ @neeraj42888Movie Graph Agent✦ @martynscnNaijaHealth✦ @rishabhprsd7Wortgraph Coach✦ @Rodrigo-TenorioChess Analytics Assistant✦ @priyagijainIPL Cricket Intelligence Agent✦ @joslatMarketMind✦ @ayushdeosinghHostLens AI✦ @hellopriyanshu4FraudGraph Sentinel✦ @winleexzCPF Customer Agent✦ @vinod.nageshwarGeospatial Supply Chain Agent✦ @jakub.kierznowskiiiDrugPath✦ @kumar20051020shivamVibeGraph AI✦ @wanga.15065M-Pesa (Kenya) Insight Agent✦ @epiphanyanEarnings Call Graph Analyst✦ @tarunnarang1992ReviewGraph AI✦ @violet.ols.devRecallScope Agent✦ @shrikantbhadaneAura-Health-Bot✦ @mabu.mateApple HealthGraph Agent✦ @ochiengokumu482VAT-TaxGraph AI✦ @mahanteshimathFinSight✦ @prashant7090Detect Cyber Attack✦ @jonas.koennerConspiracyGraph Agent✦ @deanfouldsJapan Seismic Risk Intelligence Graph✦ @jevlachovKorca Triage Agent✦ @shantanunitw01CineGraph AI✦ @dhiraj.patraRegulatoryRisk GraphAgent✦ @venkatasaiprasadpDepGraph Agent✦ Submissions are now closed

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	541	June 3, 2021
Relation on nodes with respect of time Neo4j Graph Platform cypher	4	367	May 19, 2021
How to compare datetime with only month and day in Cypher Cypher cypher , knowledge-base	17	420	April 17, 2024
Slow performance on time series queries Cypher performance , cypher	6	2972	January 28, 2019
How to get nodes between time range using relationship properties Cypher cypher	3	1817	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