Topic Tag: Views

Problem:
A many-to-many relationship connects two post types, via an intermediary post type.

If the end posts are known, how to retrieve the intermediate post that connects them?

Solution:
Use the toolset_get_related_posts API function.

An example of retrieving the intermediate post ID would be:

$left_id = 168;
$right_id = 169;
 
// get the intermediate post(s) between these two posts
$intermediate_ids = toolset_get_related_posts( 
 
    array( 'parent' => array($left_id), 'child' => array($right_id) ), // origin post ID(s)
    'left-right', // slug of relationship
    array ('role_to_return' => 'intermediary')
);
$intermediate_id = $intermediate_ids[0];

Relevant Documentation:
https://toolset.com/documentation/customizing-sites-using-php/post-relationships-api/#toolset_get_related_posts

Problem: I would like to calculate an age in years based on a given birth year.

Solution: It's not possible to calculate an age with only a year. You must have a year, month, and day to perform an accurate calculation. I have created a custom shortcode for this purpose, you can adapt for your needs.

Relevant Documentation:
https://toolset.com/forums/topic/custom-date/#post-571557

Problem: I would like to display a list of posts that were published in the last 2 months, but I can't get the Query Filter to work correctly.

Solution: Month range filters like this aren't simple to add in wp-admin but I can provide a custom code snippet that will help. First, please remove the post date filters from your View. Then add the following code to your child theme's functions.php file, or create a new snippet in Toolset > Settings > Custom code:

add_filter( 'wpv_filter_query', 'get_past_two_months_posts', 10, 3);
function get_past_two_months_posts( $query_args ,$view_settings, $view_id ) {
    $views = array( 12345 );
    if (in_array($view_id, $views)) {
        $query_args['date_query'] = array(
            'column' => 'post_date',
            'after'  => '2 months ago',
        );
    }
    return $query_args;
}

Replace 12345 with the numeric ID of this View.

Relevant Documentation:
https://toolset.com/documentation/programmer-reference/views-filters/#wpv_filter_query
https://codex.wordpress.org/Class_Reference/WP_Query#Date_Parameters

Problem:

How can I get a count of the total posts of a given post type?

Solution:

You can try this:

1) Create a post view, query posts of given post type

2) in section "Limit and Offset", Use option "Display no limit items"

3) in section "Loop Editor", within shortcodes [wpv-items-found] ... [/wpv-items-found]

display shortcode [wpv-found-count]

Relevant Documentation:

https://toolset.com/documentation/user-guides/views-shortcodes/#wpv-found-count

Problem: I would like to create a View of WooCommerce Orders, but I cannot see Orders in the content selection area of a View editor.

Solution: You must activate Toolset's WooCommerce Views plugin to show lists of Orders.