Is there anyway to filter out using custom meta field(text) using select filter?
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
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
