Reply To: Using checkbox fields in custom queries

• Hal Gatewood

• November 16, 2016 at 3:40 am

I had a similar problem where the checkbox had been checked, creating the key, and then being unchecked at a later time. I seemed to have fixed it with this (‘rented’ is the checkbox field):

'meta_query' => array(
  'relation' => 'AND',
  array(
    'key' => 'status',
    'value' => 'active',
  ),
  array(
    'relation' => 'OR',
    array(
      'key' => 'rented',
      'value' => '1',
      'compare' => '!='
    ),
    array(
      'key' => 'rented',
      'value' => '1',
      'compare' => 'NOT EXISTS'
    )
  )
)