[plugin Batch Categories] Query posts on Date

  • Resolved cstoltenkamp

    (@cstoltenkamp)


    12 years, 2 months ago

    Hello,

    I rewrite Rob Millers Batch Post Category Move/Removed plugin and like to restict post-results to a specific date / date range

    WordPress construct a query string like followed,
    This is the string $q for $query->query($q);
    “paged=1&posts_per_page=15&orderby=post_date&order=desc&post_type=post&category_name=Neuigkeiten&post_date=’2012-08-30′”

    With and without quotes on the date
    it follows with:
    $query = new WP_Query;
    $posts = $query->query($q);

    The query result works with all conditions except the date.

    When I try something like date >=, then I get back the name with >
    Looks like there is being done a split on = or something like that.

    What? I am doing wrong, or where can I found the right information?
    I found on Internet a lot information, but the solution are not very useful.
    It should be something simple. Al solutions don’t cover the whole thing, while it is so simple.

    I hope someone can help me out.

    Best solution is of course that WordPress self is able to batch delete posts categories and not just put a new category to a post.

    With regards,

    Cees Stoltenkamp

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter cstoltenkamp

    (@cstoltenkamp)

    Found a solutions

    $fdate = $_GET[‘iDate’];
    $dt = split(‘-‘, $fdate);
    $q .= ‘&year=’ . $dt[0];
    $q .= ‘&monthnum=’ . $dt[1];
    $q .= ‘&day=’ . $dt[2];
    $query = new WP_Query;
    $posts = $query->query($q);

    Still I cant only use is equal, is there a way to do different?
    Like $q .= ‘&day>=’ . $dt[2];
    and
    Like $q .= ‘&day<=’ . $dt[2];

    Thanks

    Thread Starter cstoltenkamp

    (@cstoltenkamp)

    Found! I can make what I want, in short time I will release a New Batch Category with a lot of additional possibilities.

    // Create a new filtering function that will add our where clause to the query
    function filter_where( $where = ” ) {
    // posts for March 1 to March 15, 2010
    $where .= ” AND post_date >= ‘2010-03-01’ AND post_date < ‘2010-03-16′”;
    return $where;
    }

    add_filter( ‘posts_where’, ‘filter_where’ );
    $query = new WP_Query( $query_string );
    remove_filter( ‘posts_where’, ‘filter_where’ );

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[plugin Batch Categories] Query posts on Date’ is closed to new replies.