Post Meta with DATE greater than current OR empty

Timm

#263357

Hello,

hopefully someone can help me with a simple setting, which i can’t get to work.

I just want to show results for entries which have a date >= than the current date or which have no date at all (empty field). If i write my own code i can simply get it to work with the meta_query OR relation.

But with Search & Filter Pro I had no luck to get it to work yet.

What i already tried:

1) General Settings: OR relation
2) Post Meta:
First condition (field date >= CURRENT Date)
Second condition (field date = empty; field char LIKE empty; field char not exists etc.)

Nothing seems to work for me so far.

Any ideas? Thanks a lot.

Best regards,
Tim

Add New Note to this Reply

Timm

#263371

I already figured out the solution not via the UI, but with the filter function and query args…

Maybe it helps someone 🙂

function filter_function_name( $query_args, $sfid ) {

// your filter pro ID
if($sfid==123) {
//modify $query_args here before returning it
$query_args['meta_query'] = array(
'relation' => 'OR',
array(
'key'		=> 'field',
'value'		=> date('Ymd'),
'type'		=> 'DATE',
'compare'	=> '>='
),
array(
'key'		=> 'field',
'value'		=> '',
'compare' 	=> 'IN'
)
);

return $query_args;
}
add_filter( 'sf_edit_query_args', 'filter_function_name', 20, 2 );

Add New Note to this Reply

Trevor Moderator

#263418

Thanks for sharing, I am sure others will find that useful.

I will close this thread for now.

Add New Note to this Reply

[Author]

Posts