PluginUs.Net - Business Tools for WooCommerce and WordPress

[realize your idea - make your dreams come true]

Support Forum

You need to log-in to create request (topic) to the support

Meta filter with custom post type id array (CPT) - Is it possible to filter on product meta array?

The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday. If you have problems with registration ask help on contact us page please
If you not got email within 24~36 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only here.
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday.

Is it possible to filter on product meta array?

I have linked products to a custom post type by product meta field.
The relation is n x n

A product can be linked to 1-n CPTs.
a CPT can be linked to 1-n products.

SQL of data I need to filter:

SELECT ID, post_title, meta_value FROM `wp_posts`, `wp_postmeta`
WHERE post_type ="product"
AND ID = `post_id`
AND meta_key ="my_meta_key"
LIMIT 20

This is DB structure: IMG

Spoiler
test

Hello

unfortunately the plugin does not have this feature