[Resolved] I need to be able to use OR in the query filter for a view

[Author]

Posts

[Gavin]

I understand that View Query Filters use AND and not OR.

I need to use OR for my my Query Filter and found two work-around pieces of code here:

https://toolset.com/forums/topic/user-view-with-or-in-the-query-filter/
https://toolset.com/errata/and-always-used-with-multiple-views-query-filters-even-if-or-is-specified/

However these workarounds do not work where I have two Query Filters set as follows (as per screenshot):

Filter by post relationship or repeatable fields group owner
Post author filter

i.e. I would like to be able to (Filter by post relationship or repeatable fields group owner) OR (Post author filter)

[Minesh]

Hello. Thank you for contacting the Toolset support.

Normally - You can apply the "AND" or "OR" clause to the entity of same type. For instance, there are multiple custom fields added to filter the view we can define the "AND" or "OR" for those multiple custom field.

You have two different entity here so I will have to check if we can have any workaround here.

Can you please share problem URL where you added your view as well as admin access details. Once I check your structure let me see if I will be able to share any possible workaround.

*** Please make a FULL BACKUP of your database and website.***
I would also eventually need to request temporary access (WP-Admin and FTP) to your site. Preferably to a test site where the problem has been replicated if possible in order to be of better help and check if some configurations might need to be changed.

I have set the next reply to private which means only you and I have access to it.

[Gavin]

Hi Minesh. Thank you. The fact that you can't use OR comparison with different entity types has prompted me to think about my implementation and I think I can work up a better and simpler design.