$pages->find() page or field equal value, separated by a pipe "|" symbol

[creativejay]

Apologies if this has been covered. I tried a search but didn't hit the usecase I'm after.

I currently have category pages listing their children products. Someone asked me to put a product in multiple categories, so I created a Page Reference field called prod_othercategories which lets a user pick multiple product category pages.

When I try to output a list of products for a category page, I came around to the following selector:

$pages->find("prod_othercategories|parent=$page, template=prod_series, sort=title, prod_status_pages!=1554|1559|1560|4242");

Only the first selector item is giving me trouble, but I'm including the entire string in case something is conflicting and I'm not realizing it.

The output is currently only outputting matches for "parent" and ignoring prod_othercategories. I tried listing parent first in the selector but it had no effect.

Appreciate if someone could help me with this! Thanks!

[OLSA]

Hello,

can you try this:

$pages->find("(prod_othercategories=$page),(parent=$page), template=prod_series, sort=title, prod_status_pages!=1554|1559|1560|4242");

Regards.

[creativejay]

That did it, thank you OLSA! I haven't seen that style of selector before!

[kongondo]

1 hour ago, creativejay said:

I haven't seen that style of selector before!

http://processwire.com/api/selectors/#or-groups

[creativejay]

16 hours ago, kongondo said:

http://processwire.com/api/selectors/#or-groups

Ah well that's embarrassing. I didn't read down that far because I thought the pipe was the solution I had to use. 

[kongondo]

2 hours ago, creativejay said:

Ah well that's embarrassing.

No need to be ?. Although this feature has been, relatively,  around for a while, it's not easy keeping up with all the new stuff. That selectors page has been updated several times with new stuff so it's good to have a fresh look at it.