How to query for posts (in hierarchical custom post type) that have children?

You can use the post_parent__not_in parameter:

$args = array( 
           'post_type'           => 'cpt',
           'post_parent__not_in' => array( 0 ) 
);
$query = new WP_Query( $args );

to retrieve child posts of type cpt.

The generated SQL will then include this part:

wp_posts.post_parent NOT IN (0)

Related Posts:

  1. Parent / Child formatting in a list of post of a custom post type
  2. How to query for posts (hierarchical custom post type) that have children but are NOT top level?
  3. Display posts of a hierarchical custom post type excluding parent posts
  4. Most efficient way of showing children posts?
  5. Display all posts in a custom post type, grouped by a custom taxonomy
  6. Get post with multiple meta keys and value
  7. Get posts for custom post type with WP_Query
  8. WP_Query() show posts that end later than today
  9. Sorting a query by custom field date
  10. Enforcing canonical URLs with multiple custom post types
  11. WP_Query -> sort results by relevance (= most tags / taxonomy terms in common)
  12. how to group custom post type posts by custom taxonomy terms
  13. How to sort CPT by custom meta value (date), and return posts month by month
  14. Query by 2 values of a repeater ACF field
  15. Display two post types ordered by two custom fields
  16. Post type hierarchy
  17. Display children and grandchildren of a custom post type
  18. Getting all custom posts with a certain category
  19. Sort by two dates. Default entry date and custom field if present
  20. Querying CPT with Two Taxonomies
  21. Custom Query to display posts with custom field
  22. Get taxonomy description based on variable
  23. Custom post_type search’s $wp_query->query_vars do not correspond
  24. How to create a permalink structure with custom taxonomies and custom post types like base-name/parent-tax/child-tax/custom-post-type-name
  25. Conditional to modify query results
  26. Use WP_Query() to Output the 4th to 6th Most Recent Posts of a Custom Post Type
  27. WP_Query | ‘post_type’ doesn’t work
  28. Filter by custom taxonomy slug on a custom post type
  29. Pagination : How to remove /page/x/ after a ‘POST’ action on a form returning to page 1
  30. Can I create a loop with multiple post types and specify different $args for each post type?
  31. How to get the parent of a non-hierarchical custom post type being edited in Gutenberg
  32. Display custom post type from dynamic custom field
  33. Two near-identical custom field types – one works, the other doesn’t . What can cause this?
  34. Previous/Next Link by Meta Value in CPT
  35. Custom-Posttype & Custom Taxonomy WP_Query
  36. Stuck in Order by more then one
  37. Display featured image from one CPT within another CPT query
  38. How do you paginate a query grouped by month?
  39. Query Custom Post Type Taxonomy term with multiple parameters
  40. Why is my category template ignoring post type?
  41. pagination not working for category.php (custom post types in categories)
  42. Query based on custom fields start and end date
  43. Create a permalink structure with custom taxonomies and custom post types gives 404
  44. Retrieve custom post types by custom taxonomies with WP_Query
  45. Why is my WP Query not returning first result’s post meta?
  46. Different Limit number of post on different archive page
  47. DIsplaying URL of custom field in last post of certain taxonomy && post type
  48. Custom Post type & Taxonomy 404
  49. WP_Query Custom Post Type if Category ID Equals
  50. Custom post types and ‘new WP_Query’
  51. Using page slug in wp_query
  52. Custom taxonomy wp_query woes.
  53. Select2 AJAX and WP Query Returns ALL and does not filter
  54. WP_Query orderby not work with meta_key
  55. Having Issue on Ordering CPT by Custom Field In Custom WP Query
  56. Different options per post type in WP_Query
  57. Returning a custom content types with meta values
  58. Custom Category Walker with Image, Fallback to Most Recent Post in Category Image
  59. Creating a non-hierarchical Taxonomy that behaves like categories
  60. Custom Post type loop with ACF not displaying properly
  61. Sort results without WP_QUERY?
  62. Using Wp_Query, Json to add Highcharts series data
  63. Display the current post in browser as the first post in a loop (for a slideshow)
  64. Searching post types
  65. How to retrive Custom Post Type Meta Fields in Custom WP_Query
  66. wp_query not returning my custom post
  67. Does “Custom Post Type” can have page hierarhy option?
  68. Get_the_term_list inexplicably adds values in foreach
  69. Single parent post lists child posts with pagination
  70. custom taxonomy pagination 404 error
  71. wp_query can’t get max_num_pages in custom post type
  72. Get next and prev item from custom WP_Query and Custom Post Type
  73. After inserting new post with wp_insert_post() the post is not visble to WP_Query, but the same WP_Query works for post inserted from wp-admin panel
  74. WP_Query: how to search tags in addition to a custom post type?
  75. Pagination Not Working When Used With WP_Query() `offset` Property
  76. how to display posts content on the custom css popup by clicking on each title on the sidebar?
  77. Help understand and create a loop with WP_query
  78. How do I insert a custom post type query after a certain number of recent posts and then resume recent posts?
  79. how to display new private message to users?
  80. Custom post types & Pages hierarchy – Error 404
  81. subtracting the current post form then whole loop, which is generating all CPT titles
  82. Create a Hierarchical List of Custom Taxonomies AND Posts
  83. Displaying WordPress posts from post and custom post type in custom taxonomy
  84. Imported Content Doesnt Show Up On Frontend
  85. Loop carousel slider in wordpress
  86. Manually build WP_Query
  87. How can I add a “fake” parent into the permalink?
  88. How to load more custom type posts through AJAX & LOAD MORE POSTS button
  89. Pagination always adding “Next” link when results come from Custom Post Type WP_query
  90. 404 on Pages for Custom Post Type & Query_Posts
  91. Using tax_query to get single post per category
  92. Show Posts in Vertical Tabs with Scrollbar
  93. How to manage wordpress knowledge base/wiki/posts collections
  94. Is it possible to make is_category() recursive?
  95. Get X posts with the same terms as the current post (custom post type and custom taxonomy)
  96. Display ACF object field data using Elementor Custom Query
  97. WordPress custom field sorting, weird behavior: the latest post is at the end
  98. Default WordPress Query for a Specific Custom Post Type URL
  99. Sort ACF by custom taxonomy
  100. Dynamically count the number of custom post types associated to a custom taxonomy

Leave a Comment