Forums › Forums › Search & Filter Pro › Post Meta with DATE greater than current OR empty
- This topic has 2 replies, 2 voices, and was last updated 6 years, 1 month ago by
Trevor.
-
Anonymous(Private) October 19, 2020 at 12:25 pm #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,
TimAnonymous(Private) October 19, 2020 at 1:52 pm #263371I 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 ); -
AuthorPosts