Querying Posts by Taxonomy From Alternate Network Site

After some thought, I came up with a possible “solution”. However, it wasn’t exactly the route I hoped to take.

The custom post type and all custom taxonomies for that custom post type must be registered on ALL network sites in order for WP_Query(); to fetch posts from the primary site from any of the sub sites in the network.

At least as a temporary solution, I have specified the following settings to help “hide” the custom post types and custom taxonomies from the sub sites.

Firstly, I specified two global variables to use through out my plugin. One for the primary site ID, and another for the current site ID. These variables can then be globalized into any class methods or functions.

$GLOBALS['mbe_primary_site_id'] = 1;
$GLOBALS['mbe_current_site_id'] = get_current_blog_id();

While registering the custom post type… I added a check, and altered some of the post type registration arguments.

global $mbe_primary_site_id, $mbe_current_site_id;
if($mbe_current_site_id != $mbe_primary_site_id){
    $args['show_ui'] = false;
    $args['public'] = false;
    $args['show_in_menu'] = false;
}

While registering the custom taxonomies… I added a check, and altered some of the taxonomy registration arguments.

global $mbe_primary_site_id, $mbe_current_site_id;
if($mbe_current_site_id != $mbe_primary_site_id){
    $args['show_ui'] = false;
    $args['public'] = false;
}

So now, I can query posts by taxonomy from the primary site on any of the sub sites like: switch_to_blog($mbe_primary_site_id);, WP_Query(...);, and restore_current_blog();

I don’t know if there’s a real solid way around this. What I do know is this method works, and if you were to do it via $wpdb; queries, there would be quite some conditional logic and checks involved, especially if you plan on paginating the content.

It would just be more of a pain and a lot of extra work to use $wpdb; for everything, when you could just register the custom post types and custom taxonomies on the sub sites as well, and just hide access to them on the sub sites.

Related Posts:

  1. WP_Query search posts by custom post type and custom taxonomy
  2. Is it possible to create a shortcode that will query a post based on taxonomies?
  3. Querying Term Posts in Loop
  4. Search / Filter posts on Title/Content OR Tags
  5. First custom field value (out of several) displayed twice after query
  6. WP_Query orderby and tax_query
  7. WP_Query() with custom post type and taxonomy — get all terms?
  8. Query custom posts from custom taxonomy
  9. WP_Query for custom taxonomies showing posts from non-specified terms?
  10. Get posts of an specific term of a custom taxonomy
  11. Query Pulling the same post twice
  12. $wp_query->queried_object->ID throws warning: Undefined property
  13. The Operator “NOT IN” Does Not Work In tax_query
  14. How to get_queried_object on multiple objects?
  15. Displaying Posts Related to Other Posts by a Taxonomy Term?
  16. How to get the parent’s taxonomy?
  17. custom post type paging not working past page 3
  18. Comparing timestamps in meta query doesn’t work
  19. Include both default and Custom Post Type in query modified inside pre_get_posts
  20. Should unaltered default loop/query return a list of custom posts belonging to a custom taxonomy?
  21. Include different loop templates in search query
  22. Query for posts in 2 taxonomies
  23. How do I Use Nested Loops of Custom Post Types for MultiSite Blogs using WP_Query()
  24. Paginated Taxonomy Term Archive including one post per term
  25. Custom Post Type vs. User Page
  26. wp_query to find posts by year and month
  27. WordPress Orderby Numeric Value Not Working
  28. Custom Post Type Loop within Shortcode
  29. Custom Taxonomy Invalid in REST API
  30. Display CPT posts based on specific taxonomy
  31. Am unable to reset a query properly
  32. Filtering WP_Query Dynamically on the Front-End
  33. Why get_posts() not returning only selected category posts from Custom Post Type?
  34. Making certain categories of CPT not publicly queryable
  35. WP_Query most viewed posts, in multiple Post Types, last 30 days, excluding a specific taxonomy term
  36. Return one unique custom post type result when it shares a custom taxonomy in WP_QUERY?
  37. How do I move/order posts with a tag to the end?
  38. Custom WP Query on custom meta and sort by multiple meta keys value
  39. How can I made custom taxonomies relationship?
  40. Specific query for custom post type
  41. Custom taxonomies relationship
  42. Display post content with respect to its title?
  43. Prioritize posts in query by meta keys?
  44. Add Custom Post Type of specific Custom Taxonomy to regularly blog loop
  45. I am trying to hide a custom post type category to logged in users with Pre_Get_Posts
  46. Different Ways to Query Custom Post Types?
  47. How to make WP_Query not to show irrelevant posts?
  48. WordPress wp_query() basic question about args
  49. Create an archive page for custom post type with custom taxonomy
  50. WP_query – Filter by tax_query and meta_query using multiple select
  51. Custom post type, custom taxonomy, query posts only from taxonomy (children of)
  52. how to get this tax_query working?
  53. How to sort a WP_Query by a custom field AND ALSO filter by a different custom field
  54. How to get the post terms from a child taxonomy
  55. display posts of custom post type with custom taxonomy
  56. Custom post type and custom taxonomy 404 on page 2
  57. tax_query (if the terms are empty)
  58. How to count other posts not having specific taxonomy terms?
  59. Exclude latest post from WP_Query taxonomy term loop
  60. Get posts by category name
  61. WP_Query order custom post type with certain meta key value by post modified date
  62. Cant’ Display Custom Post Type Title Base on Tax Terms
  63. Display featured posts for a custom post type by taxonomy
  64. Query for specific taxonomy that executes a particular loop depending on volume of posts?
  65. What is the most efficient way to execute recursive complex queries?
  66. How to divide Subcategories into pages of parent category wordpress
  67. set object terms after some some time of published post – functions.php
  68. Change search query in wordpress custom post type
  69. Sort custom posts by date and then by taxonomy
  70. WP Query: If field X is empty, show posts based on field Y
  71. Is there a way to use ‘publicly_queryable’ => false only on specific taxonomy term?
  72. display post count in archive page that have relation with another taxonomy term
  73. Displaying all posts by category and showing content on click
  74. How to search through all child taxonomies using WP_Query?
  75. How select query is generated in a Custom Post Type?
  76. WP_query sort by taxonomy
  77. Custom Taxonomy – fields
  78. CPT Loop, include taxonomies and disclude others?
  79. Linking posts together with Advanced Custom Fields “both ways”
  80. Why get_posts() returns empty array while I am trying to get posts from some specific taxonomies and work properly with others?
  81. Conditional posts in WP_query for search
  82. Checking Taxonomy Terms for a Custom Post Type With get_the_terms Not Working
  83. Custom post type and custom taxonomies display
  84. WP_Query for CPT with filter by another WP_Query
  85. Is it possible to add query parameters on the archive page?
  86. How to pass taxonomy terms to WP_Query along with $args?
  87. WordPress custom post type
  88. Custom Taxonomy Query by Taxonomny not working
  89. How to query posts by meta keys AND under specific category?
  90. Shortcode display CPT Query only showing 1 post?
  91. Query Only Show Text on Posts With Certain Taxonomy Tag
  92. Storing/querying custom date data
  93. Query child posts on parents single.php?
  94. Query Posts From Multiple Post Types
  95. WP Query Post Type with same Taxonomy name
  96. WordPress can only query up to 766
  97. Listing custom post type items from a couple of custom taxonomies
  98. Sort ACF by custom taxonomy
  99. Query custom post type and group by taxonomy
  100. Dynamically count the number of custom post types associated to a custom taxonomy

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)