Topic Tag: Views API

Problem:
A View already contains date filters. How is it possible to add additional conditions to the same filters?

Solution:
That's not possible without custom code, using the wpv_filter_query filter to set up multiple meta query conditions.

Relevant Documentation:
https://toolset.com/documentation/programmer-reference/views-filters/#wpv_filter_query

Problem: I am using the render_view API to render a View, but I need to pass a shortcode attribute to the View's query filter.

Solution: You can add any shortcode attributes to the arguments array for render_view, like the "ids" attribute here:

$args = array(
    'title' => 'Produit phare',
    'ids' => '12345' // modify this to match the post ID
);
    echo render_view( $args );

Be sure to uncheck "Do not include the current page in the results" checkbox if your View should include the current page in the results.

Relevant Documentation:
https://toolset.com/documentation/programmer-reference/views-api/#render_view

Problem: I have a View with two custom field filters. The first filter is applied using a shortcode attribute. The second filter is a front-end filter using a datepicker field. I can set the default date using TODAY(), but the initial result is not filtered. I would like to filter the initial results, and allow the User to change the filter as needed.

Solution:
It's possible to filter the initial result set using the default selection TODAY while still allowing front-end date filtering. Add the following code to your child theme's functions.php file, or to a new snippet in Toolset > Settings > Custom Code:

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;
}

Change 12345 to match the numeric ID of this View. Change wpcf-stdstartdate to match the date field slug. You must use the 'wpcf-' prefix here. Change wpv-wpcf-stdstartdate to match the URL parameter specified in your Query filter.

Relevant Documentation:
https://toolset.com/documentation/programmer-reference/views-filters/#wpv_filter_query