How to achieve post_status__not_in?

Unfortunately there is no post_status__not_in query argument, but you can simply query for all statuses other than trash & draft:

$stati = array_keys( get_post_stati() );
unset( $stati['trash'], $stati['draft'] );
$stati = array_flip( $stati );

$query->set( 'post_status', $stati );

Related Posts:

  1. Sticky Posts exceed posts per page limit
  2. Theres a way to use $query->set(‘tax_query’ in pre_get_posts filter?
  3. Modify Taxonomy pages to exclude items in child taxonomies
  4. Obliterate the main query and replace it
  5. Post injection – how to exclude the original post
  6. Adding meta_key via pre_get_posts causes navigation to disappear
  7. Sorting posts that has a meta value first then the rest of the posts
  8. pre_get_posts on a page
  9. How pre_get_posts filter by roles in WP Admin
  10. Weird problem with pre_get_posts and $query->is_page()
  11. Why is ‘pre_get_posts’ having no effect?
  12. Date Query to Pull Current and Future Posts
  13. pre_get_posts all posts and custom post type with certain tag
  14. Using Sessions to Filter Posts – bad thing?
  15. pre_get_posts and the blog page
  16. Archive by custom post type and custom date field
  17. pre_get_post filter returns results when there should not be
  18. Trying to exclude first 5 posts from the first page on the homepage
  19. Exclude a WordPress post from pre_get_posts if a field is null
  20. Why the ‘date_query’ is not working in ‘pre_get_posts’ hook?
  21. Only show certain post types in recent posts widget
  22. pre_get_posts for exclude category
  23. pre_get_posts: using tax_query only for certain post type
  24. pre_get_posts dont firing… Anybody knows whats the wrong with my code?
  25. Restrict Search Query To After Specific Date
  26. WP_Error not displaying errors
  27. Show all posts even if URL points to a single one
  28. Ordering by meta_key
  29. Using a pre_get_posts filter to search for multiple strings on all meta values
  30. Removing taxonomy query by pre_get_posts
  31. Using different parameters for different queries with pre get posts in functions.php
  32. how to restrict posts_request filter to the main query only
  33. Automatically applying a pre_get_posts filter for child categories only
  34. How to override a query and display specific page by ID?
  35. pre_get_posts variables
  36. Another query in pre_get_post cause memory issue
  37. pre_get_posts having no effect on my category archive
  38. pre_get_posts returns non property object when using posts__not_in
  39. Override tax_query with pre_get_posts to include other term_ids on a single category
  40. $query->is_main_query() is causing query’s tax_query to be ignored
  41. Menu disappears when meta_key changed [closed]
  42. pre_get_posts with multiple queries
  43. How to show the last and newest modified post in a custom category?
  44. Altering the main query using get_post_meta() in pre_get_posts
  45. Why query by specific date with variables doesn’t return same result that with harcoded integers?
  46. Sort WordPress Archive by multiple oderby arguments in pre_get_posts action
  47. Exclude post type with pre_get_posts?
  48. Exclude page by title for non admins
  49. problem with setting tax_query in pre_get_posts
  50. Problem ID to exclude specific posts from category
  51. Modify Taxonomy pages to exclude items in child taxonomies
  52. Modify author archive query to combine two queries
  53. Change post order on archive to be displayed by most commented being ignored by theme
  54. Complex query using pre_get_posts
  55. Super confusing ‘pre_get_posts’ behavior with $query->set
  56. Having trouble with settings terms as array in pre_get_posts
  57. Override main query for page template
  58. Querying custom taxonomy on category-specific page is overwritten by function
  59. how to get content from other site and show it?
  60. Insert a variable in pre_get_posts
  61. Extend taxonomy term page with other posts
  62. Set a custom number of posts on the first page
  63. Why does this query not SELECT post IDs like a normal query would?
  64. Please ensure me that I’m not crazy using the pre_get_posts [closed]
  65. How to pass >= condition filter to my year custom tax_query
  66. What is the proper way to use pre_get_post?
  67. pre_get_posts has php notice when not on CPT archive
  68. Duplicating event posts in wordpress
  69. How to Change Order of Posts in Admin?
  70. Media library to list images only user uploaded
  71. Include and Exclude Taxonomies From Archives & Feeds Using ‘pre_get_posts’
  72. Using meta_query on pre_get_posts to exclude a particular meta_key value
  73. complex restriction of items in media library
  74. pre_get_posts OR relation between taxonomy and author
  75. Change of query var in pre_get_posts not maintained
  76. Single page theme that uses pages for the content
  77. When querying a combination of posts and other meta fields, is there a better solution than directly modifying the WHERE value?
  78. Formulate a url to show posts with both taxonomy terms
  79. pre_get_posts order by not working
  80. Adding a parameter to the default query
  81. Using WP_Query in “parse_query” or “pre_get_post” in Posts2Posts
  82. pre_get_posts query between 2 dates (date stored in custom post meta)
  83. Use pre_get_posts to sort meta_key by an array of values
  84. How to use $query->set with post__in?
  85. Make blog page show 10 on first page, 9 on every other page
  86. Alter query using pre_get_posts() if meta_key is present
  87. Filtering out child category posts from parent category archive not working
  88. Remove posts inside pre_get_posts using a custom query
  89. How to ignore posts in pre_get_posts?
  90. WP Query – order posts by meta field first and then order the rest
  91. post__in not working with pre_get_posts, but post__not_in does work
  92. Displaying number of search results for each post type
  93. WP_Query – How to get all posts of specific days of week by custom field date?
  94. Pre Get Posts – Difference between conditional() and $query->conditional()?
  95. Detect Ajax call inside pre_get_posts function
  96. Make a products only viewable to a specific user ID in meta_query pre_get_posts
  97. Exclude Posts Using Meta Query and User Meta
  98. Adding a Theme Customizer Control for Posts_Per_Page
  99. pre_get_posts not firing at all
  100. Search for meta_query does not return any result if combined with title