getarchives_where filter

Filters the SQL WHERE clause for retrieving archives.

To use getarchives_where filter, first you have to register it using add_filter. You can write this code into functions.php of your activated theme or in a custom WordPress Plugin.

We at Flipper Code, always prefer to create a custom WordPress Plugin while using hooks so nothing breaks when you update your WordPress Theme in the future.

In the below live example, we have defined a function modify_getarchives_where_defaults which takes 2 parameters and we registered using add_filter. The first parameter getarchives_where is name of the hook, The second parameter modify_getarchives_where_defaults is name of the function which need to be called, third parameter is the priority of calling the hook if same hook is used multiple times and the last parameter is the number of arguments (if any) to be passed in the registered function.

Sometime, you have to remove a registered hook so you can use remove_filter to remove getarchives_where filter.


    Below are the 2 parameters are required to use this hook.

  • $sql_where : (string) Portion of SQL query containing the WHERE clause.
  • $parsed_args : (array) An array of default arguments.

Live Example

add_filter( 'getarchives_where', 'custom_archive_by_category_where' );
add_filter( 'getarchives_join', 'custom_archive_by_category_join' ); // You must add `join` to keep it works. Adding only `where` will return nothing
 function custom_archive_by_category_where($x) {
    global $wpdb;
    $current_term_slug = get_query_var( 'news_category' );
      if (!empty($current_term_slug)) {
        $current_term = get_term_by('slug', $current_term_slug, 'news_category');

Below is an example how you can use this hook.

                        function modify_getarchives_where_defaults($sql_where, $parsed_args) { 
                            // Update the $sql_where variable according to your website requirements and return this variable. You can modify the $sql_where variable conditionally too if you want.

                            return $sql_where; 
                        // add the filter
                        add_filter( "getarchives_where", "modify_getarchives_where_defaults", 10, 2 );

To remove a hook callback, use the example below.

remove_filter( "getarchives_where", "modify_getarchives_where_defaults", 10, 2 );

Please make sure provide the same callback function name, priority and number of arguments while removing the hook callback.

Flipper Code is a Premium WordPress Plugins development company and integrating new functionalites into WordPress sites in form of custom WordPress Plugins since 2012. If you’re having any trouble using this hook, please contact our WordPress Development Team and we’d be happy to assist you.


 Subscribe to our weekly newsletter below and never miss the latest updates in WordPress