filter search result with custom post type meta key

This might not have worked before, but WordPress’s meta queries now support the relation parameter. To complete what @s_ha_dum was looking to do, simply add the relation parameter (as OR) and add a second meta query for NOT EXISTS. Example:

function searchExcludeOldMatches( $query ) {
    //if we're on the admin panel, or it's a search, or it's not the post type we want to filter, return the original query
    if( is_admin() || !$query->is_search() || $query->get( 'post_type' ) != 'yourposttype' )
        return $query;

    //this is the query we want to update
    $query->set('meta_query', array(
        'relation' => 'OR',
        array(
            'key' => 'cpt-match-date'
            ,'value' => date('Y/m/d',time())
            ,'type' => 'DATE'
            ,'compare' => '>'
        ),
        array(
            'key' => 'cpt-match-date'
            ,'value' => date('Y/m/d',time())
            ,'type' => 'DATE'
            'compare' => 'NOT EXISTS'
        ),
    ));
    return $query;
}
add_filter('pre_get_posts','searchExcludeOldMatches');

For further reading, check out the WP Meta Query Codex Page: https://codex.wordpress.org/Class_Reference/WP_Meta_Query

Edit Nov 17, 2015: Added filter for custom post type and simplified the conditional statement.

Related Posts:

  1. Meta Query “IN” doesn’t work with ACF checkbox filter
  2. How Do I Use WP_Query to Run This Database Query as Search Result?
  3. Can’t sort order of wp_query with 2 meta keys
  4. Building an Advanced Search (text, tags, category, custom fields) – Getting the wrong SQL query
  5. CPT Meta Searching
  6. Custom search for custom post meta with pre_get_posts interferes with WP search
  7. Multiple meta_values in the pre_get_posts filter?
  8. Custom post type search using $_SESSION and pre_get_posts
  9. filter custom post type by meta key in dashboard
  10. search suggest – filter post type
  11. filter search custom field query
  12. How to let users choose where to search for posts?
  13. find custom post type post by searching its custom field with my string
  14. Prevent A Specific Custom Post Type Showing In WP Search Results Page
  15. Meta query broken since 4.7.4 Update
  16. Conditional posts in WP_query for search
  17. Custom Post Search
  18. pre_get_posts not firing at all
  19. Meta_query question
  20. Include custom taxonomy term in search
  21. AJAX search on post pages by custom post type
  22. How can I change the admin search posts fields?
  23. Development of a WordPress Search Plugin – Best Practices
  24. Admin Area Custom Type Search By Meta Fields Without Title & Content
  25. Simple way to search custom-post types only
  26. Pushing a custom post type to the top of the search results
  27. $query->set in pre_get_posts is unintentionally affecting the backend
  28. WP_Query orderby custom field then post_date in one query
  29. Add Custom Post Type to Current Query
  30. How to show more posts on an archive page?
  31. Include post id[s] into WP_Query()
  32. Pre get posts for single post
  33. How Can I save multiple records in same meta key?
  34. Pre_get_posts Gives 404 on Custom Post Type
  35. Search everything (posts, pages, tags, cpt, meta)
  36. Order posts by (hierarchical custom) taxonomy terms and term children
  37. Custom search for custom post type, custom meta and search fields
  38. No results searching custom post type in admin panel
  39. custom search result page
  40. Display all Posts and only certain Custom Post Types with meta fields
  41. Customize Search Results for Custom Post Type
  42. Display custom post type taxonomy and month
  43. Search Custom Post Type Custom Fields
  44. Filtering by Post Meta Custom Fields – Performance
  45. Query that joins the postmeta table twice
  46. WooCommerce product search titles only
  47. Setting proper query for multiple custom admin filters
  48. Returning a list of custom post types excluding those without a specific meta_value
  49. How to modify archive query with pre_get_posts to append CPTs?
  50. custom post type Search returns No Results in admin panel
  51. Search Custom Post Type & Taxonomies
  52. How to stick custom post at the top in search results
  53. Can I search only some of the fields of a custom post type?
  54. How to filter wp_list_categories output with some custom post type meta query?
  55. Display a CPT based on a metabox selection
  56. How to do WP_Query with two meta fields with orderby clause
  57. Meta Query Not Returning Output Despite Having Matching Values
  58. Using meta_query and tax_query at the same time
  59. Advanced search form with filters for custom taxonomies
  60. Search one custom post type ONLY, disable “all posts”
  61. Main menu not appearing in custom post type archive
  62. Sorting search results with custom dropdown
  63. Hide custom post type from search based on custom taxonomy
  64. Pagination on search results page
  65. Best way to create a search for custom post type by custom field values
  66. Multi Parameter search with custom post type category and tag
  67. Two queries – one with checkbox ticked, one without – comparing meta_query
  68. Redirecting search to specific templates with $_GET[“post_type”]
  69. Search custom type post
  70. Order admin post list table by meta field, and have posts without the meta field always be at the end of the list
  71. Using OR relation in meta_query to check for a value before sorting by another
  72. Query to Exclude Child Pages from Custom Post Type Archive
  73. Filter result of Custom Post Type using meta_query with ACF
  74. How do I troubleshoot pre_get_posts with Debug Bar?
  75. meta_query Where the key value is stored as an array
  76. Creating a custom WP query for a Custom Post Type
  77. WP_List_Table Inside Metabox Not Working on Clicking Search Button
  78. ACF meta_key and meta_value break loop
  79. search results to show individual ACF fields from inside custom posts
  80. Sort custom post archives by a meta value from a different custom post type?
  81. post_type incorrect for custom post type
  82. Live search by custom tag
  83. List all posts associated under custom taxonomy
  84. how to create custom taxonomy drop downs for parents and child
  85. post type => ‘any’ not applied my custom queries
  86. How to get the posts that my following users are liked?
  87. Sort loop by custom field from different post type
  88. Meta_query by date for Events archive
  89. Extensive search filtering and results->PDF in the front-end
  90. Using $seed on a custom post type for randomly displayed posts
  91. How do I sort post listing by child post count?
  92. Advanced search form with filters for custom taxonomies and custom fields
  93. Querying meta values within an array
  94. Searching for a single custom post type, buddypress
  95. How do I do this?: If custom post type exists, echo it, else do not
  96. WordPress search results
  97. Drop Down Filter with CPT as Options for Search Form
  98. Searching Custom Posts content with JQuery
  99. Order Wp Query by earliest of 3 dates meta query
  100. Group search results by post type, but having a unique heading for each section?

Leave a Comment