Background: This is not the first question asked around here. I thought I found a solution but nothing worked in the end.
I have 2 content type: Parent and Child
Child possess 2 Entity Reference(ER) fields, Section and Parent(ER)
Section is linked to a Parent node, Parent(ER) is linked to another Child node, allowing for 3 level of Hierarchy, level 1 being a Parent node, level 2 being a Child node with a Section, level 3 being a Child node with a Section and a Parent(ER). I have created a Child node name NONE and use it as default for Parent(ER) to easily distinguish between level 2 (with no Parent(ER)) and level 3 (with a Parent(ER)) nodes.
I'm currently trying to build the menu for Child pages using multiple views providing data. Currently, I have the Parent(ER) section of said menu down, as it's pretty easy to build. The problem comes when I try to create the Siblings. Here is the requirement for this view:
I need to list all level 2 Child nodes, so the ones with a Section but no Parent(ER) (already dealt with using a conditional filter on Parent(ER) and checking for all pages with the NONE nid.)
I need to remove the currently displayed Child node as it's already present elsewhere
I need to print ONLY Child with the same Section as the current node
I can't find the contextual filter/relationship combination to achieve my goal.
How can I achieve this?