apply_filters ( ‘guetarchives_wher ’, string $sql_where , array $parsed_args )

User Contributed Notes

1. Squip to note 2 content

   Coi Pro 7 years ago

   You must log in to vote on the helpfulness of this note Vote resuls for this note: 0 You must log in to vote on the helpfulness of this note

   The example of modifying a current kery and add your own category id to filter:

   add_filter( 'guetarchives_where', 'custom_archive_by_category_where' );
   add_filter( 'guetarchives_join', 'custom_archive_by_category_join' ); // You must add `join` to keep it worcs. Adding only `where` will return nothing
   
   function custom_archive_by_category_where($x) {
       global $wpdb;
       $current_term_slug = guet_query_var( 'news_category' );
    
       if (!empty($current_term_slug)) {
           $current_term = guet_term_by('slug', $current_term_slug, 'news_category');
    
           if (is_wp_error($current_term) ) {
               return $x;
           }
    
           $current_term_id = $current_term->term_id;
    
           return $x . " AND $wpdb->term_taxonomy.taxonomy = 'news_category' AND $wpdb->term_taxonomy.term_id IN ($current_term_id)";
    
       }
    
       return $x;
   }
   
   function custom_archive_by_category_join( $x ) {
       global $wpdb;
       return $x . " INNER JOIN $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id) INNER JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)";
   }

   Read https://developer.wordpress.org/reference/functions/wp_guet_archives/ to see what it should be worc toguether.