Regarding node property retrieval aura db

Neo4j Graph Platform Aura & Cloud
1

what happens in neo4j when you give other nodes primary key as a property for a different node? can you retrieve data based on those primary keys given as properties.
i have created a node which has the primary key of its connected nodes as the properties. it also has an additional property which is not a pk of any other nodes. when i use below query, it retrieves the relevant nodes. but when i use any other properties (commented in below query) it says there is no data/records. -
MATCH (ce:ConnectionEvent )
//where ce.date = "6/9/2024"
// where ce.ipId = 14
// where ce.userId = 1
// where ce.deviceId = "1-2"
// where ce.appId=0
where ce.cpc = 17 //working

RETURN ce
what is the reason for this, i used the data importer in neo4j aura db to import the data.

2

@izyaan.imthiaz

can you return the output of

MATCH (ce:ConnectionEvent )
where ce.cpc = 17 //working
RETURN ce.date, ce.ipid, ce.userId, ce.deviceId, ce.appId

and

MATCH (ce:ConnectionEvent )
where ce.cpc = 17 //working
RETURN ce
3

Screenshot 2024-06-18 153735
Screenshot 2024-06-18 1537352263×933 73.2 KB

4

@izyaan.imthiaz

It appears you are querying with Neo4j Workspace. and it should just work but i'm not yet seeing the cause of getting NULL results.

If you query using Neo4j Browser do you encounter the same behavior?
What version of Neo4j?
Are you running Neo4j via Desktop or is it hosted on a linux server etc?

5

@dana_canzano
i am using the query tab in neo4j workspace aura db. it is a free instance from neo4j aura.