SET Property

[rsunkari]

Please keep the following things in mind:

1. did you search for what you want to ask before posting?
2. please use tags for additional info
3. use a self-descriptive title

Please format code + Cypher statements with the code </> icon, it's much easier to read.

Please provide the following information if you ran into a more serious issue:

• neo4j version, desktop version, browser version
• what kind of API / driver do you use
• screenshot of PROFILE or EXPLAIN with boxes expanded (lower right corner)
• a sample of the data you want to import
• which plugins / extensions / procedures do you use
• neo4j.log and debug.log

Hi All
Can we use Aggregation on SET property

match (c:Client)-[:RAISED]-(t:Ticket) where c.Client=t.Client
SET c.TICKETS = count(t.TKTID)

Please help
Thanks
Ramdas

[glilienfield (Gary Lilienfield)]

Try:

match (c:Client)-[:RAISED]-(t:Ticket) 
where c.Client=t.Client
with c, count(t.TKTID) as cnt 
set c.TICKETS = cnt 

[rsunkari]

@glilienfield

match (c:Client)-[:RAISED]-(t:Ticket) 
where c.Client=t.Client
with c, count(t.TKTID) as cnt 
set c.TICKETS = cnt 

Great it worked
Thanks a lot Gary