@Zach, indeed, you cannot use the WHERE condition that way.
I went with Trevor solution (thanks!), implemented the function that returns the proper nodes in a list.
Changed the CSS List Menu part to a Repeater for styling reasons, and voilà! All the proper items are displayed.
I still do get a strange result though. I wanted to add some style for selected items, and therefore I'm using two transformations :
- Transformation: SecondaryMenuLink
- Selected item transformation: SecondaryMenuLinkHighlighted
The issue is that when doing so, only the selected item does actually gets retrieved & displayed (which is kind of cumbersome). When I remove that selected transformation, all items get displayed.
The code of the transformation is quite simple:
I searched for the repeater documentation, but didn't read anywhere that it wasn't possible to have two transformations for a same repeater.
Any ideas on what breaks here?