How to query using a combination of custom_field values?

Since WordPress 4.1 it is possible to build nested meta, date and tax queries. I’ve not tested it but the code bellow should work. Also, I recommend to replace PHP date() function with current_time from WordPress to get the current date taking in account the blog time zone configuration:

After the chat with you, it seems that you just need to use “DATE” as type argument.

$since = current_time('Y-m-d');
$args = array(
        'meta_key'          => 'bjab_event_date_start_id',
        'category_name'     => 'private',
        'order'             => 'ASC',
        'orderby'           => 'meta_value',
        'meta_query'        => array(
            'relation' => 'OR',
            array(
                //event_date_start_id greater or equal to $since
                'key' => 'bjab_event_date_start_id',
                'value' => $since,
                'type' => 'DATE',
                'compare' => '>='
            ),
            array(
                'key' => 'bjab_event_date_end_id',
                'value' => $since,
                'type' => 'DATE',
                'compare' => '>='
            )
        )
    );

$query = new WP_Query( $args );

Related Posts:

  1. How can I use order_by to order by two meta_keys without excluding posts that don’t have those keys initialized?
  2. Sorting posts by custom date fields (non standard date format)
  3. Group posts by custom field
  4. getting posts and number by specific meta value in multiple meta
  5. Sorting Posts by custom field
  6. Order posts by date and then by custom field
  7. Revolution Slider Orderby Two Custom Fields
  8. Query two post types and order by two different date fields
  9. Querying by taxonomy vs Querying by Custom fields Speed Comparison
  10. How to show only one post for each categories of taxonomy of custom post that contains a specific custom field
  11. meta_key and meta_value not working together
  12. How can i make WP_Query return post image and categories?
  13. wp_query with multiple custom fields
  14. How add a custom posttype name using ACF field to a query post array
  15. Display link to taxonomy archive only if it has posts with certain custom field values
  16. Ordering Posts Type A by Custom Fields of related Post Type B
  17. Order Posts by meta value AND published date
  18. Search Posts with Custom Fields as query
  19. Group WP_Query by meta_key date
  20. exclude posts with a specific custom field and value
  21. Add quicklink to in the Admin posts page where I can query by a meta_key
  22. How to make Meta Query case sensitive?
  23. Display custom field meta outside loop, site wide
  24. Meta_query with multiple keys and multiple values
  25. meta_query BETWEEN, but the range is stored in the custom field
  26. Get a list of posts with associated meta_value
  27. WordPress Comments sort by custom meta key
  28. Understanding the orderby in WP_Query?
  29. Extend product search with meta in WooCommerce
  30. How to list custom fields as headers and list all pages sharing that custom field under it?
  31. how to make members list directory through wordpress post custom meta key.
  32. Order by empty custom field
  33. Query posts without meta preload
  34. Adding multiple meta_key fields as orderby options to a WP Query via a function
  35. Query all posts if multiple meta key don’t exist
  36. meta_compare not comparing whole integer
  37. Search posts missing a particular custom field
  38. wp_query to print posts if have X custom field value
  39. Why is WP_Query not displaying expected data?
  40. WP_Query Meta_key is text value and need to sort as numeric not working
  41. filter wp_query result with custom field values
  42. Order post type by sum of two custom fields
  43. Conditional operator OR not working with custom fields
  44. WP_QUERY with group by with custom fields
  45. How to order posts on each different category?
  46. Intiger meta value with ‘>=’ returns posts with lower value
  47. Get every post with value in meta key
  48. Using get_posts to get posts based on a checkbox value with Advanced Custom Fields
  49. Posts query according to meta box date
  50. create metabox to activate slider
  51. Query posts using less than
  52. Order WP_Query results by meta key value in custom query
  53. Excluding posts with certain value of meta_key keeping posts without that meta_key
  54. Query only displays one page_id
  55. Display post meta conditionally based on it’s value
  56. Query using string from custom field as array value
  57. How to show list of posts with custom field value (a date) that are coming soon
  58. Comparing 2 Decimal Numbers from custom fields and displaying posts
  59. Sorting posts by Multiple custom fields in defined order
  60. meta_query weird behaviour, static int will work, but not user data
  61. Woocommerce Shortcode which displays a table with product data
  62. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  63. How to add a “base” filter for all posts visible to visitors on the site?
  64. Sort custom post by custom field if none order by latest release
  65. Query posts by post type, author and post meta
  66. How to use the Term Object from a custom select field in a query
  67. WP Query – grouping posts by same meta key, adding together values from another key
  68. Retrieve all custom field values of a specific custom field metakey as an array, inside WP_Query
  69. meta_query is overriding default search
  70. Trouble with serialized metadata
  71. Getting posts by custom field value
  72. Query post by Category and custom file (ACF)
  73. Problem with my loops
  74. ACF Post Object meta-query by title not ID
  75. Sort posts on custom field AND after that sort on date?
  76. From admin edit user page query either the user_nicename or username field value of the user profile being edited or viewed
  77. Query by meta value (add a dropdown of all values)
  78. Order Posts By Custom Field That is an array of objects
  79. How to create URL parameters to run custom queries?
  80. Custom WP_query and integrating into theme file
  81. Query by Category and Custom Field – Shortcode
  82. Querying posts with meta key and meta value not returning anything
  83. Sorting posts by meta values: 2 different orders
  84. WP_Query with Pagination and orderby meta_value_num showing duplicates
  85. Mathematical operations on custom field values? (updated)
  86. Compare meta key separation
  87. WP_Query a custom field value bringing back 0 results
  88. Order by three custom fields (Y-m-d), then separate into yearly sections
  89. Custom search (wp query by custom fields)
  90. Loop through multiple custom fields with increasing number
  91. How do I display posts with specific value in a custom field into my loop?
  92. new WP_query using custom fields
  93. Custom Search Query – include only custom fields and title
  94. query_posts with sorting on a custom datestamp
  95. query post based on comparison
  96. Query posts filter not working
  97. Display all custom meta field values from the database using ACF Repeater
  98. Taxonomy related query not working
  99. WP_Query – order with usort by custom meta
  100. WP_Query sort by ACF date field (newest first) with blank dates first

Leave a Comment