wp_query not work with numeric field

• vetru85

• September 25, 2019 at 9:27 pm

good morning,

I give you an example to explain my problem:
– I created a numeric custom field.
– in the products the custom filed contains 0,29
– the query below does not return products (if I remove the filter on the numeric field, it works)

$args = array(
‘post_type’ => ‘product’,
‘post_status’ => ‘publish’,
‘orderby’ => ‘_price’,
‘order’ => “asc”,
‘posts_per_page’ => 1000,
‘paged’ => 1,
‘tax_query’ => array(
‘relation’ => ‘AND’,
array (
‘taxonomy’ => ‘product_cat’,
‘field’ => ‘slug’,
‘terms’ => array(‘diamanti-sfusi’),
‘operator’ => ‘IN’
),
),
‘meta_query’ => array(
‘relation’ => ‘AND’,
array(
‘key’ => ‘stone_carat’,
‘value’ => 0.10,
‘type’ => ‘NUMERIC’,
‘compare’ => ‘>’
)

)
);