[Resolved] Datepicker not filtering on start of view to today or greater

[Author]

Posts

[mikeB-14]

Hi

I have a filter set in my view which is sett to filter by default wpcf-stdstartdate >= today
When view shows the datepicker is set to today's date but the row are not filtered by default

If i select the date in the datepicker and then sumbit the rows get filtered.
I would like to have a default set from >= today
The user can choose to change the filter is needed.

My page which has this view is configured this way

[wpv-conditional if="( '[wpv-current-user info='email']' ne '' )"]
[wpv-view name='planner-list-view-with-custom-search-v2' cached="off" orderby='field-stdstartdate' email="[wpv-current-user info='email']"]
[/wpv-conditional]

Thanks Tony

----------------------------------------------------------------------------
[wpv-filter-start hide="false"]
[wpv-filter-controls]
<div class="form-group">
<label>[wpml-string context="wpv-views"] Select Start Date[/wpml-string]</label>
[wpv-control-postmeta field="wpcf-stdstartdate" default_date="TODAY()" url_param="wpv-wpcf-stdstartdate"]
[wpv-filter-submit output="bootstrap"]
[/wpv-filter-controls]
<div class="pagination">
[wpv-pager-prev-page force="true"][wpml-string context="wpv-views"]Previous Page [/wpml-string][/wpv-pager-prev-page]
[wpv-pager-next-page force="true"][wpml-string context="wpv-views"]Next Page[/wpml-string][/wpv-pager-next-page]

</div>
[wpv-filter-end]
</div>

[Christian Cox]

Hi, if the datepicker is the only custom field filter in the View, then the following custom code snippet will filter the initial result set correctly:

add_filter( 'wpv_filter_query', 'filter_gte_today', 10, 3 );
function filter_gte_today ( $query, $view_settings, $view_id ) {
  // if the datepicker is already set, don't modify the selected value
  if( isset($query['meta_query'])) {
    return $query;
  }

  $views = array( 12345 );
  if( in_array( $view_id, $views) ) {
    $today = strtotime('0:00');
    $args = array(
      'relation' => 'AND',
      array(
        'key' => 'wpcf-stdstartdate',
        'value' => $today,
        'compare' => '>=',
        'type' => 'numeric'
      )
    );
    // add these arguments to your meta query
    $query['meta_query'] = isset($query['meta_query']) ? $query['meta_query'] : [];
    $query['meta_query'][] = $args;
  }

 return $query;
}

Change 12345 to match the numeric ID of this View, then place this snippet in a child theme's functions.php file or in a new custom code snippet in Toolset > Settings > Custom Code.

[mikeB-14]

MY view has 2 filters

Select items with field: Email is a string equal to VIEW_PARAM(email)

AND STDstartDate is a number greater than or equal URL_PARAM(wpv-wpcf-stdstartdate)

[mikeB-14]

Hi Christian
I have also added the code snippet into the custom code and activated it , does not appear to doing anything

[Christian Cox]

Okay yes if there is more than one custom field filter, the code is a bit more complex. Here's an updated snippet:

add_filter( 'wpv_filter_query', 'filter_gte_today', 10, 3 );
function filter_gte_today ( $query, $view_settings, $view_id ) {
  $views = array( 12345 );
  $date_slug = 'wpcf-stdstartdate';
  $url_param = 'wpv-wpcf-stdstartdate';

  // do not edit below this line

  if( in_array( $view_id, $views) ) {
    // check to see if the datepicker filter has been manually set or manually unset
    // if so, bail out and don't modify it
    if( isset($query['meta_query'])) {
      $cols = array_column($query['meta_query'], 'key');
      if( in_array($date_slug, $cols) || ( isset( $_GET[$url_param] ) && $_GET[$url_param] == '' )) {
        return $query;
      }
    }

    // datepicker filter has not been set or unset. Use the default value.
    $today = strtotime('0:00');
    $args = array(
      'relation' => 'AND',
      array(
        'key' => $date_slug,
        'value' => $today,
        'compare' => '>=',
        'type' => 'numeric'
      )
    );
    // add these arguments to your meta query
    $query['meta_query'] = isset($query['meta_query']) ? $query['meta_query'] : [];
    $query['meta_query'][] = $args;
  }

 return $query;
}

Again, change 12345 to match the View's unique ID.

[mikeB-14]

My issue is resolved now. Thank you!