This thread is resolved. Here is a description of the problem and solution.
Problem:
I am trying to filter meal plans by the current week and future weeks using the query filter of the views on my website.
However, the "THIS_WEEK" and "FUTURE_WEEK" options are not available, and I cannot format TODAY() or NOW().
Solution:
Use the Views API and the 'wpv_filter_query' hook to modify the query arguments and add a filter to show posts from the current week.
Edit the date field slug and View ID(s) in the provided code snippet, then add the custom code to your website.
// Function to filter meal plans by the current week
function tssupp_filter_view($view_args, $view_settings, $view_id)
{
// Edit the date field slug to match your date field
$date_field_slug = 'datum';
// Edit the array with the View ID(s) you want to apply the filter to
if (in_array($view_id, array( 123 ))) {
// Get the start and end of the current week
$current_week_start = strtotime("monday this week");
$current_week_end = strtotime("sunday 23:59:59");
// Check if meta_query is set and initialize it if not
if ( !isset($view_args['meta_query']) ) {
$view_args['meta_query'] = array();
}
// Add the filter to the query to show posts between the start and end of the current week
$view_args['meta_query'][] = array(
'key' => 'wpcf-'.$date_field_slug,
'value' => array($current_week_start, $current_week_end),
'compare' => 'BETWEEN'
);
}
// Return the modified view arguments
return $view_args;
}
// Add the filter to the Views API
add_filter('wpv_filter_query', 'tssupp_filter_view', 101, 3);
Relevant Documentation:
Filtering Toolset Views by Dates:
https://toolset.com/course-lesson/filtering-toolset-views-by-dates/
Views Filters:
https://toolset.com/documentation/programmer-reference/views-filters/#wpv_filter_query
This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.
Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.
This topic contains 8 replies, has 3 voices.
Last updated by 2 years, 5 months ago.
Assisted by: Christopher Amirian.
Tell us what you are trying to do?
I create a meal plan for several weeks. For each week I create a separate view in which the dishes of that week are displayed.
The CPT contains a date field. The date entered here must be compared with the current number of the week and all dates contained in the week must be output. How can I implement this with the query filter of the views?
Is there any documentation that you are following?
No
Is there a similar example that we can see?
No
What is the link to your site?
hidden link
Hi Christopher,
unfortunately I have no way to format any of the given parameters. The document also does not contain any information on how I can format TODAY() or NOW().
If I had the ability to filter TODAY() within a conditional tag, I would have achieved my goal. If I specify the value '06' for the current week instead of TODAY(), the query works within the view template.
[wpv-conditional if="( '[types field='datum' format='W'][/types]' eq TODAY() )"]DO SOMETHING[/wpv-conditional]
The most easiest way would be to filter by "THIS_WEEK" and "FUTURE_WEEK", but these options don't exist.
Regards
Hendrik
