Query loop with last modified date also shows new posts

Hi there,

WordPress saves the a modified date for all new posts, it just happens to be the same as published date.
So to exclude all new posts, you need to tell the WP Query to exclude any posts where the modified and published dates match.

To do that in a GB Query Loop block:

1. Add this PHP Snippet to the site:

add_filter( 'generateblocks_query_loop_args', function( $query_args, $attributes ) {
    if ( 
        ! is_admin() && 
        ! empty( $attributes['className'] ) && 
        strpos( $attributes['className'], 'mod-post-only' ) !== false 
    ) {
        $query_args = array_merge( $query_args, array(
            'date_query'     => array(
                array(
                    'column'  => 'post_modified',
                    'after'   => 'post_date',
                ),
            ),    
        ));
    }
    return $query_args;
}, 10, 2 );

2. select the Grid Block inside the Query Loop
2.1 in the block settings Advanced > Additional CSS Class(es) add: mod-post-only

Yeah, to be honest, it was some potluck shooting on my part here…. and looking at it now, was a bit dumb as the after arg requires an actual date.

So… not 100% sure on this but you could try:

1. Remove thea above snippet

2. add this snippet to create a custom query arg of: exclude_unmodified

add_filter( 'posts_where', 'exclude_unmodified_posts_where', 10, 2 );

function exclude_unmodified_posts_where( $where, $query ) {
    global $wpdb;

    if ( $query->get( 'exclude_unmodified' ) ) {
        $where .= " AND {$wpdb->posts}.post_modified != {$wpdb->posts}.post_date";
    }

    return $where;
}

3. Add this snippet to write in our new arg.

add_filter( 'generateblocks_query_loop_args', function( $query_args, $attributes ) {
    if ( 
        ! is_admin() && 
        ! empty( $attributes['className'] ) && 
        strpos( $attributes['className'], 'mod-post-only' ) !== false 
    ) {
        $query_args = array_merge( $query_args, array(
            'exclude_unmodified' => true,    
        ));
    }
    return $query_args;
}, 10, 2 );

4. as above add the mod-post-only class to the query loops grid block.

Awesome – glad to hear that worked!