SubQueries in switch case

[killJoy-03]

I want to run subqueries in switch case is it possible? or is there any workaround in a single query

Example:

MATCH (a:Col1 { Uid : '123' })  
MATCH (d:Col2 { Uid : '345' })
CASE:
   a.prop1 <> '' THEN return a.prop1 as name
   d.prop1 = True THEN MATCH (c:Col3 {Uid : '789' } )  return c.prop2 as name
   d.prop2 = False THEN MATCH (d:Col4 {Uid : '878' } )  return d.prop2 as name
   ELSE MATCH (e:Col5 {Uid : '452' } )  return e.prop3 as name
  END name as name
 RETURN name

[killJoy-03]

Like in AQL we can do something like this

let name = a.prop1 != '' ? first(query1 ) : d.prop2 ? first (query2) : first(query3)

[RichardIrons-neo4j]

Hi there. I spoke to the Cypher team about this and they recommended I send you this link. Hope it helps!

https://neo4j.com/developer/kb/conditional-cypher-execution/

[loveleif]

You can use for example collect subqueries inside case statements.

neo4j@neo4j> create (:A {name: 'A1', p1:1, p2: 1})
             create (:A {name: 'A2', p1:2, p2: 2})
             create (:A {name: 'A3', p1:10, p2: -10})
             create (:B {name:'B1'})
             create (:C {name:'C1'})
             ;
0 rows
Added 5 nodes, Set 11 properties, Added 5 labels
neo4j@neo4j> match (a:A)
             with
               case 
                 when a.p1 < 2 then collect { match (b:B) return b.name }
                 when a.p2 > 1 then collect { match (c:C) return c.name }
                 else [a.name]
               end as names
             unwind names as name
             return name;
+------+
| name |
+------+
| "B1" |
| "C1" |
| "A3" |
+------+

3 rows