Is there anyway to filter out using custom meta field(text) using select filter?

Saklain Lingkon
Free
Is there anyway to filter out using custom meta field(text) using select filter?
Advanced Customizations
Description :

How to use a text field to make a select filter with the values stored in the database and order the result ascending by the values?
In my case is a metafield created with a metabox to the products

Solution :

Steps :

1. Create a SQL Query with Query Builder, select Posts table and Inner Join with Postmeta table by ID
2. Cretae Where clauses :
Post Type = product
Post Status = publish
Postmeta meta_key = You Meta Key
3. Order by postmeta.meta_value
4. Include columns : ID, Post Title, Meta Key, Meta Value (Add others if you want to use in other cases)
5.  Create a Select filter with Data Source JetEngine Query Builder and select the Query
6. In Property to get Value from type postmeta.meta_value
7. In Property to get Label from type postmeta.meta_value
8. In Query Variable * type the name of your metakey of the text field that you want to filter, in my case speed-value

Did you want to see this content ?
Scroll to Top