Filter by Height and Width

I tried the following but it only works when there are no WooBeWoo filters selected. This is in a pre_get_posts action function I created.

$min_width = $_GET['width_min'] ?? false;
$max_width = $_GET['width_max'] ?? false;
if ($min_width !== false && $max_width !== false) {
  $width_query = array(
    'key' => '_width',
    'compare' => 'BETWEEN',
    'value' => array(intval($min_width), intval($max_width)),
    'type' => 'NUMERIC',
  );
  array_push($meta_query, $width_query);

  $query->set( 'meta_query', $meta_query );
}

• This reply was modified 2 years, 6 months ago by jordanwebdev.
• This reply was modified 2 years, 6 months ago by jordanwebdev.
• This reply was modified 2 years, 6 months ago by jordanwebdev.

Got it working with the following. I added a form for this on the front end, which submits values that are retrieved here using $_GET.

Of course it would be nice if this was a part of the plugin :).

Note that I’m using decimal casting because sometimes a value of 0 was set for the height/width, which is incorrect. So I used 0.01 instead of 0 for the min.

add_filter('get_meta_sql','cast_decimal_precision');
function cast_decimal_precision( $array ) {
  $array['where'] = str_replace('DECIMAL','DECIMAL(10,3)',$array['where']);
  return $array;
}

// Width Query
    $min_width = $_GET['width_min'] ?? false;
    $max_width = $_GET['width_max'] ?? false;
    if ($min_width !== false && $max_width !== false) {
      $min = intval($min_width) === 0 ? 0.01 : $min_width;
      $width_query = array(
        'key' => '_width',
        'value' => array($min, intval($max_width)),
        'compare' => 'BETWEEN',
        'type' => 'DECIMAL',
      );
      $meta_query[] = $width_query;
    }

    // Height Query
    $min_height = $_GET['height_min'] ?? false;
    $max_height = $_GET['height_max'] ?? false;
    if ($min_height !== false && $max_height !== false) {
      $min = intval($min_height) === 0 ? 0.01 : $min_height;
      $height_query = array(
        'key' => '_height',
        'value' => array($min, intval($max_height)),
        'compare' => 'BETWEEN',
        'type' => 'DECIMAL',
      );
      $meta_query[] = $height_query;
    }

Awesome. Does that $49 1 site license plan include unlimited updates?