Selector with two fields using OR operator fails

[efiguerola]

I have the following selector:

wire("pages")->find("template=news|video, parent|secondary_categories=$page, limit=8, sort=-publish_date, sort=title");

parent represents the parent of the current page

$page is the object representing the current page

secondary_categories is a field assigned to the "news" and "video" templates, it is of type "Page" and it uses ASMSelect for selecting multiple pages

So basically, what I'm telling ProcessWire is:

"Get me 8 pages that use either the 'news' OR 'video' template, AND that also have the current $page as their parent OR that have a reference to the current $page within their secondary_categories field".

The problematic part is:

parent|secondary_categories=$page

The OR operator is not working - I'm only getting pages where the parent is $page, and none where $page is in secondary_categories.

[LostKobrakai]

parent is not a field in the traditional sense, but a native field and might therefore function a bit different. You could try:

rel=(parent=$page), rel=(secondary_category=$page), …

[efiguerola]

Thanks, that worked!

I didn't know about "rel", where can I find documentation on that feature?

[LostKobrakai]

It's not about the rel, but the parenthesis: https://processwire.com/api/selectors/#or-groups

I just chose rel for "relationship", which is what you're dealing with.