I'm trying to find paths with alternating relationships.
The use case is a product information manager.
Each product has attributes and a family.
There are rules.
Each rule has one or more conditions (e.g. attribute_1 = "foo" and family in ["bar"]) and one or more action (e.g. clear attribute_2, set attribute_3 to "foo").
What I want my query to find is: which rules might be trigger and which attributes might be modified if I modify a specific attribute.
I tried a suggestion from an old post on stackoverflow, it is indeed extremely slow; after 10 minutes I'm still waiting although there are only 200 rules, 120 attributes, 1272 TRIGGERS relationships and 210 MODIFIES relationships.
In this post, @andrew.bowman said "APOC path expander procedures have support for sequences of relationships, so if you just needed alternating :C and :D relationships it could support that"
I looked at the documentation but didn't understand enough to apply it to my use case.