cancel
Showing results for 
Search instead for 
Did you mean: 

SET Property

rsunkari
Node

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

1 ACCEPTED SOLUTION

glilienfield
Ninja
Ninja

Try:

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

View solution in original post

2 REPLIES 2

glilienfield
Ninja
Ninja

Try:

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

rsunkari
Node

Great it worked
Thanks a lot Gary