Extend functionality of WP_Date_Query beyond core tables

[transom]

Class WP_Date_Query in wp-includes/date.php already allows filtering of the valid columns. But when constructing the query limits the output to the known data fields in the core tables. The attached patch adds a filter over the known_columns so that the entire class can be used to generate SQL clauses on tables beyond the core tables.

Yes, the class could be extended with the validate_column method overloaded but why??

[transom]

Add filter to known_columns in wp-includes/date.php WP_Date_Query/validate_column

[transom]

Duh - Add the phpdoc

[boonebgorges]

Can you explain how 'date_query_valid_columns' doesn't already allow this?

function wp32115_add_valid_date_column( $cols ) {
    $cols[] = 'foo';
    return $cols;
}
add_filter( 'date_query_valid_columns', 'wp32115_add_valid_date_column' );

$date_query = new WP_Date_Query( array(
    array(
        'column' => 'foo',
        'year' => 2015,
    ),
) );

[transom]

OK - I will now accept my dunce cap for the day - I just re-read the code.

To callback to an old SNL skit - Never mind!

[boonebgorges]

OK - I will now accept my dunce cap for the day - I just re-read the code.

Let me know when you're done with that dunce cap - I'm usually the one who wears it.