Skip Navigation

[Resolved] Woo archive custom field checkboxes search with OR condition

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
- 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 10:00 – 13:00 -
- 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 14:00 – 18:00 -

Supporter timezone: Asia/Kolkata (GMT+05:30)

This topic contains 0 replies, has 1 voice.

Last updated by tomasP 1 month, 1 week ago.

Assisted by: Minesh.

Author
Posts
#2797224
Snímek obrazovky 2025-02-19 v 22.03.14.png

Hello,
I have two custom fields (one text field, one number field) assigned to Products in Woocommerce, I need to filter product archives using these two fields. The product archive template contains Custom Search Filter fields set up to display values as "Set of checkboxes", tweaked with css to emulate select tag on the frontend. Each filter works just fine for one value selected. But selecting more than one value in the respective filter shows no results. I suppose the condition used in the filter is "AND". Tried to find some solution to this, but without any luck. Could you help, please?
The filters can be seen on the "Katalog" page.
Thanks in advance,
Tom

#2797241

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Hello. Thank you for contacting the Toolset support.

Can you please share problem URL and admin access details and let me check what query is generated by view and what is your expected result.

Please share one test case that by selecting what options I should search and what is your expected result in that case.

*** 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.

#2797462

Just realized - you might need to enter "cms" in both fields of the first pop-up, before entering the WP credentials in my previous reply - GEO protection of the webhosting

#2798029

Minesh
Supporter

Languages: English (English )

Timezone: Asia/Kolkata (GMT+05:30)

Can you please check now: hidden link

On the edit archive page on backend:
- hidden link

I've adjusted the query filters for the archive as you can see with the screenshot:
=> hidden link

As you can see I've set the comparision operator to "in" for both the filters. Can you please confirm it works as expected now.

#2798036

Wow! Thanks VERY much! That was it! Thanks again very much!