get_terms showing link to category even if all posts are drafts

get_terms() doesn’t have built-in feature that excludes draft posts because it keeps track of only total posts term is attached to. I made a quick search and found this snippet but be warned:

  • It affects all get_terms() functions on your site (I excluded admin area)
  • There’s a SQL query in foreach loop – it will affect performance
  • More terms returned == bigger performance hit
  • I do not recommend testing it on live website
  • You might get away with it if your traffic is not super high

This is probably the reason why there’s no native support for that – it’s either query in loop or WordPress would need to keep track of both drafts and public posts count which is not perfect either.

SOURCE

This is a very hacky solution and I wouldn’t use it myself. It might also require few modifications.

If you’re willing to try it, add this to functions.php:

// Make sure that we're not in admin area
if( ! is_admin() ) {

    add_filter( 'get_terms', 'hide_draft_terms' );

    function hide_draft_terms( $terms, $taxonomies, $args ) {


        global $wpdb;
        $taxonomy = $taxonomies[0];

        if( ! is_array( $terms ) && count( $terms ) < 1 )
            return $terms;

        $filtered_terms = array();

        foreach ( $terms as $term ) {

            $result = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->posts p JOIN $wpdb->term_relationships rl ON p.ID = rl.object_id WHERE rl.term_taxonomy_id = $term->term_id AND p.post_status="publish" LIMIT 1" );

            if ( intval( $result ) > 0 ) {

                $filtered_terms[] = $term;
            }
        }

        return $filtered_terms;
    }
}

Related Posts:

  1. Get the the top-level parent of a custom taxonomy term
  2. get_terms – only top level
  3. How to only list the child terms of a taxonomy and not their parents?
  4. Hierarchical taxonomy UI
  5. Order get_terms using a Custom Field
  6. Hide the term description on the term edit page, for a given taxonomy
  7. get_term_by not working when in functions.php
  8. Can I lock down custom taxonomies on a parent term level, but not a child term?
  9. Get only the first term by taxonomy
  10. Exclude specific slug in ‘get_terms’
  11. wp_insert_term is adding a term that has no name
  12. Get terms from multiple taxonomies
  13. get_terms() returns an empty array
  14. Determine if Term has Grandparent/Great-Grandparent
  15. Retrieving custom taxonomy in order, but excluding specific tax IDs
  16. get taxonomy terms for parent and child
  17. Taxonomy query for children of parents
  18. Group posts that matches a term in a loop
  19. Separator for multiple terms
  20. Ordering Posts with Custom Taxonomy Terms Array
  21. How to display term description in empty terms archive?
  22. Checking if a Page has an Associated Term?
  23. What are terms and taxonomy, how they related to post and how these three are stored in database?
  24. Get multiple term objects by ids
  25. Echo custom taxonomy term name
  26. get_terms custom order
  27. Limits amount of terms displayed? Is it possible?
  28. How to List Parent Term Links for Custom Taxonomy With & Without Children?
  29. Why does WP rename similar “term name”-slugs in separate taxonomies?
  30. Get Bottom Most Level Taxonomy Terms?
  31. How can I get WP to build a feed based on multiple taxonomy terms
  32. Check if term is in a taxonomy?
  33. Get child product categories from parent product category in WooCommerce
  34. Set custom post type terms by id without knowing taxonomy
  35. How to determine the depth of a term in a custom taxonomy?
  36. get_term_children doesn’t return an array of children terms
  37. How to show only terms by id or slug on edit-tags.php (custom taxonomy manage page) for a custom taxonomy
  38. Display the description of taxonomy terms
  39. get_terms adds slaces to the resualt
  40. Term count by user
  41. AJAX response, edit tags
  42. List child terms if parent but show nothing on children
  43. get_term and get_term_by return null or false, even though term exists
  44. Display Taxonomy Terms in an option tag with value being the slug
  45. If post has ANY term attached to it, get the first one only
  46. How to add contents of a custom field to a taxonomy term list?
  47. one term two taxonomy’s?
  48. Getting WooCommerce product related child categories
  49. List Posts For Terms Of A Custom Taxonomy For Any Post Type
  50. Query posts from a child taxonomy term id
  51. get_terms() duplicate first term of a custom taxonomy
  52. Having Issue on Passing Variable into HTML Class Tag
  53. Echo custom taxonomy slug
  54. Admin (All posts) stop responding problem
  55. Query posts using custom taxonomy and selected terms
  56. Proper use of wp_get_object_terms
  57. Remove a href from this code
  58. Output all terms in a custom taxonomy and add a “active” class only to the ones attached to the current post
  59. How to get posts that contain multiple terms from multiple taxonomies?
  60. Cannot delete or edit a single term in a custom taxonomy, taxonomy name is wrong?
  61. one post per term taxonomy
  62. How to check if a post has at least 2 terms from a custom taxonomy attached?
  63. How can I change the output display of my pagination?
  64. Can’t get taxonomy ID for each post on archive page
  65. Terms change id after importing
  66. delete term from taxonomy and assign in new one
  67. Wp_query…a type of term a different div
  68. How to add a date creation field when a custom taxonomy relationship is created?
  69. Adding Child Terms Programatically – No Warning but No dice either
  70. Show related posts on single.php, grouped by taxonomy terms, with Advanced Custom Field post object selected
  71. Running a function only once when a taxonomy term is changed
  72. Set post terms by term id
  73. Displaying my custom taxonomies in a using the_term_list()
  74. Use wp_list_categories to list parent categories from actual term
  75. Trash Bin for Categories?
  76. using wp_insert_term to create custom terms for a custom taxonomy from frontend form,
  77. is there a way of getting term children that only shows those from two taxonomies
  78. Display term picture of each post in a loop
  79. Get Terms of custom Taxonomy of products with certain Product Category
  80. Problems using get_the_terms in a plugin
  81. How to add a shortcode function that returns the taxonomy slug of the actual post within the loop
  82. Tree view wp-admin terms
  83. Retrieve the child terms by having the parent’s information
  84. add pagination in wordpress page template
  85. Order get_terms by count using a custom taxonomy hierarchy
  86. How to create a non removable taxonomy term?
  87. WordPress taxonomy terms archive template help
  88. wp_insert_post not adding taxonomy (using wp_set_object_terms)
  89. Filter “get_terms” query
  90. Show message if term slug changed
  91. generate random slug when adding taxonomy
  92. Why get_terms() behaves strangely when being called in admin (for use in meta box)?
  93. qtranslate-x problem with custom term description
  94. Custom post type term names with ampersand in the term name
  95. Sorting terms individually for each post
  96. get_terms returns array starting at 4
  97. Multiple category lists on one page
  98. get_the_terms inside save_post gives old terms
  99. How to delete unused terms?
  100. Foreach for get_the_terms for hierarchical taxonomy don’t repeat Top Level Terms if contains multiple Second Level Terms

Leave a Comment