WP_Query – How to get all posts of specific days of week by custom field date?

WP_Query provides no such date parameter. While you could query for/store the date of the earliest post on the site and then calculate every date for a particular day of the week in the timespan since then and query based on that criteria, it would be far more efficient to track the publish day of week directly.

This could be accomplished with post meta-data, but for query efficiency it would probably make more sense as a taxonomy with a term for each day of the week. As an added benefit of storing this information in a taxonomy, you’ll also get automatic archives and permalinks, which sound as though they might be beneficial here – but you can disable that functionality if not.

Add a hook to look up and set the appropriate day of week term whenever a new course is inserted.

If the archives don’t directly fit your filter needs, your filtration query would be just a matter of specifying the day of week taxonomy/term.

Related Posts:

  1. Filter WP_Query output before it is accessed (pre_get_posts)?
  2. How to add taxonomy filter on the query fly?
  3. Changing Posts Per Page and offset with pre_get_posts
  4. RSS feed with specific keyword
  5. Which filter/action hook gets triggered after a query has been performed?
  6. Including only current user’s posts in search
  7. WP_Query ignoring tax_query when is_singular
  8. Applying posts_clauses filter to specific queries only
  9. Elementor posts custom query based on tag [closed]
  10. Track write actions to the database
  11. Using pre_get_posts with WP_Query
  12. Use REGEXP in WP_Query meta_query key
  13. WP_Query orderby post__in remains ineffective in the Loop [closed]
  14. Changing the meta_query of the main query based on custom query_vars and using pre_get_posts
  15. Hook/action after WP_Query gets posts to query custom tables for post-related meta
  16. How to uniquely identify queries?
  17. ajax category filter
  18. “pre_get_posts” firing on every query
  19. Using is_main_query to select custom post type on certain page
  20. SQL Statement generated by WP_Query not producing expected results
  21. How to pass custom parameter to WP_Query for filtering in pre_get_posts
  22. Single page theme that uses pages for the content
  23. How to get any tag ID
  24. WordPress custom search form with pre_get_posts not work
  25. order by multiple meta keys in pre_get_posts
  26. Remove ellipsis from the excerpt retrieved using get_the_excerpt()
  27. Using pre_get_posts on a specific core/query block
  28. Searching through different categories on different pages code is not working
  29. How to implement time filter to show random post 1 month for one category and 3 months for other categories
  30. When querying a combination of posts and other meta fields, is there a better solution than directly modifying the WHERE value?
  31. Use ‘parse_query’ filter to show posts that from multiple criteria
  32. Using apply_filters(‘the_content’, $custom_query->post_content) alters output
  33. Modifying the Search Results
  34. Formulate a url to show posts with both taxonomy terms
  35. Offset Page Loops and Pagination
  36. pre_get_posts order by not working
  37. Adding a parameter to the default query
  38. Using WP_Query in “parse_query” or “pre_get_post” in Posts2Posts
  39. Single meta_query query using OR instead of AND in request’s WHERE statement
  40. How to choose between hooking into per_get_posts or into parse_query
  41. How to use filter hook “the_posts” with a function that refers to $this?
  42. How to change main query based on post meta
  43. new WP_Query to get max price meta value not working
  44. Display posts from only one post form in custom query and exclude in main query
  45. WP_Query, pre_get_posts and offset
  46. Complex WP SQL Query
  47. add_actions called from functions.php not returning good values
  48. Order by title without taking into account ‘the’
  49. How can I filter by slug depending on language selection
  50. How to get all product attributes for filters in WooCommerce?
  51. A method for ordering mixed dates in search result loop (theory only, no actual code)
  52. Set global $wp_query/$post variable for dynamic page generation
  53. Filtering out child category posts from parent category archive not working
  54. WP_Query with different postmeta filter for each categories
  55. Slow WP_Query with ‘OR’ on meta_query
  56. Add posts to WP Query object
  57. Filter Posts from the Main Query
  58. Custom post type archive pagination query issue
  59. Shouldn’t I be able to modify the main query by this filter?
  60. Hide elements outside loop based on query
  61. Woocommerce – exclude only older out-of-stock items
  62. WP Query – order posts by meta field first and then order the rest
  63. Include posts from some categories while excluding from others
  64. I need help using pre_get_comments to limit comments in the comments admin screen
  65. How I can change the condition or compare operator for WP_Query in pre_get_posts
  66. Change AJAX filter from POST to GET for URL Parameters
  67. Filtering posts by archive showing all years
  68. Filter WooCommerce archive pages by an additional category
  69. Sorting search results with custom dropdown
  70. Multiple wp_query on archive page
  71. Retrieve select tag custom values from array and display them in current page with wp_query?
  72. How to use a dropdown to filter posts by custom field
  73. Filtering by multiple conditions in the loop
  74. Custom post type – filter content by custom meta box content
  75. $wp_query->found_posts not returning correct value
  76. wp-query and wp_get_post_terms on custom taxonomy archive page
  77. Display posts ONLY from the current logged in user and current week/year/month Elementor posts
  78. How do I display main query posts in random order using add_filter
  79. Replace wp_query with wp_user_query
  80. Block internal search queries with pre_get_posts and regex rules
  81. Make a products only viewable to a specific user ID in meta_query pre_get_posts
  82. Custom meta_query order for Elementor based on post meta key [closed]
  83. is_user_logged_in not working from WP-API (wp-json)
  84. Search Exact on WordPress – Relevannsi Solution Not Working
  85. order posts by a secondary query that counts items
  86. How can I re-query post_type and rewrite the url?
  87. Woocomerce – Order products by float attribute in archive pages
  88. WP Query filters active on wrong query
  89. Insert wp_query after the_content with plugin (filter the_content won’t work)
  90. Gather same custom field values in one value in a select tag with wp_query
  91. In Product Category archives how to show Posts having same/similar prod_cat slug structure?
  92. Using the same WP_Query for shop and widgets in WooCommerce shop
  93. Fetch only categorized posts
  94. Modify query to exclude certain ids and certain parents and its corresponding children
  95. Adding a Theme Customizer Control for Posts_Per_Page
  96. Sort posts in dashboard using custom field; also include posts where field isn’t set
  97. Looking for a way to exclude frontpage and nav menu from query filter
  98. Custom post types loop on a page template
  99. Woocommerce set loop_shop_columns to be 3 in the main shop page loop only and 4 otherwise
  100. List categories using WP_Query