Custom Post Type + Custom Meta Query Not Showing 2012 Posts

I ended up solving this by doing essentially one thing in a couple places. WordPress doesn’t let you specify a particular type for your meta data and stores everything as strings. As such, I added an extra meta data field that I used as the actual timestamp (using strtotime to convert it to a unix numeric timestamp) that gets created when the post is saved from the $startDate value.

$startDateTimeStamp = strtotime($_POST['startDate']);

From there I made my original meta_query order the posts by this new meta data value instead:

$args = array(
                    'post_type'         => 'event',
                    'post_status'       => 'publish',
                    'posts_per_page'    => $num,
                    'paged'             => $paged,
                    'meta_key'          => 'startDateTimeStamp',
                    'orderby'           => 'meta_value_num',
                    'meta_query'        => array(
                                                array( 
                                                    'key'     => strtotime('startDateTimeStamp'),
                                                    'value'   => strtotime(date("m/d/Y")),
                                                    'compare' => '>=',
                                                    'type'    => 'NUMERIC'
                                                )
                                            ),
                    'order'             => 'ASC'
        );
    $e_query = new WP_Query($args);

*Please note: * This query wouldn’t work until I made sure that I ran the meta query’s key/value through the strtotime function and changed the orderby to ‘meta_value_num’.

Related Posts:

  1. WP_Query orderby custom field then post_date in one query
  2. Filtering a WP_Query meta_query by numeric values isn’t working
  3. How to sort CPT by custom meta value (date), and return posts month by month
  4. Comparing timestamps in meta query doesn’t work
  5. Display two post types ordered by two custom fields
  6. Filtering by Post Meta Custom Fields – Performance
  7. WP_Query: include custom post type only with specific meta value
  8. Returning a list of custom post types excluding those without a specific meta_value
  9. Two near-identical custom field types – one works, the other doesn’t . What can cause this?
  10. wp_query check if integer exists in custom field’s array
  11. Meta Query Filtering not working on Custom Meta Box using Radio Buttons
  12. Possible to filter custom post type with multiple meta data?
  13. Query based on custom fields start and end date
  14. Getting a custom post’s custom field based on another custom post’s custom field select
  15. WP_Meta_Query object with conditionals
  16. meta query multiple values for the same key
  17. Sort custom post archives by a meta value from a different custom post type?
  18. Custom post types – meta_query: search lesson which starts sooner
  19. Meta_Query refuses to return results
  20. Query events post type after current date and timezone
  21. Selecting posts older than the current Unix epoch timestamp
  22. WP_Query arguments: Loop through custom post type – get all entries except excluded meta_key?
  23. loop through custom post-type with two meta_keys
  24. Querying meta values within an array
  25. WP_Query() show posts that end later than today
  26. Sorting a query by custom field date
  27. echo value from ‘select’ field type into page template using cmb2?
  28. How can I generate a RSS feed based on a custom WP_Query?
  29. Detect meta value changes when post is updated (post_updated)
  30. Search Custom Post Type with all meta attached?
  31. Order custom posts by a date metabox
  32. How to select one major category (or custom taxonomy) for a custom post type?
  33. Using Query Posts With Multiple Post Types And A Taxonomy
  34. Can’t sort order of wp_query with 2 meta keys
  35. Displaying Meta Box Image
  36. How loop through posts based on custom fields
  37. Display posts if a custom field value is equal to another custom field value
  38. Filter posts with meta_query NOT IN where value has multiple values
  39. Sort by two dates. Default entry date and custom field if present
  40. Displaying Metabox value (custom post type taxonomy)
  41. Conditional to modify query results
  42. Get all Posts If has same custom field values in Posts
  43. advanced search forms with 3 input text and that the main problem 3 input text
  44. Adding dropdown select meta box to custom post type – seems restAPI is interfering
  45. Keep display metadata value on backend – Custom Metabox
  46. Why is my select meta data not saving?
  47. How can I get the number of custom post type posts that have a specific attachment image set?
  48. Visual editor issue by having multiple tiny mce editors in a CPT
  49. A method for ordering mixed dates in search result loop (theory only, no actual code)
  50. Stuck in Order by more then one
  51. Including metaboxes from custom post types in global search — continued
  52. Grouping metadatas into one
  53. Adding Page Templates to post but it ignored it
  54. Admin Custom Meta Box – Pull Last 5 Posts from Custom Post Type
  55. How to Output which matched meta_keys were found from custom_type_posts?
  56. How to let users choose where to search for posts?
  57. Custom “radio button meta box” not saving correctly
  58. DIsplaying URL of custom field in last post of certain taxonomy && post type
  59. WP Query ‘posts_per_page’
  60. Display Repeatable Meta Box Content
  61. What do the numbers mean at the end of add_action(‘save_post’)…?
  62. A meta box (in a custom post type) with two different type of fields
  63. WP_Query orderby not work with meta_key
  64. Having Issue on Ordering CPT by Custom Field In Custom WP Query
  65. Custom Query: If One Post Object Field Value Is The Same As Another
  66. Custom Post type loop with ACF not displaying properly
  67. Reusable metabox backend and frontend
  68. How can I output WPAlchemy repeating fields meta values in my page template?
  69. How can I modify a custom post type and custom page template for a child theme if all content seams to be handled by theme’s ‘native’ plugin?
  70. How to retrive Custom Post Type Meta Fields in Custom WP_Query
  71. Adding an extra parameter [string] to my posts’ permalink?
  72. Problem On Retrieving Post Meta Data on Custom Column [closed]
  73. Cache issue with WP_Query and custom field filtering
  74. Empty meta-box returns publishdate if no value is set?
  75. Custom Post Type Meta Box Text Input Field Won’t Save When Blank
  76. how to compare different timestamps in wp-query for events custom post types?
  77. Custom Post Type meta data getting deleted on bulk editing taxonomies
  78. Custom Form / Search with Custom Post Type Data
  79. Alike Shortcode using in Custom Shortcode
  80. Custom Metabox Info Not Saving
  81. Use WP_query to match post types based on custom field values
  82. How can I fetch all the dates from custom fields from various different custom post types and show / list them at one place in ascending order?
  83. PHP Warning with Custom Fields
  84. Post Filtered by Custom Field Value
  85. How to make a shortcode for my WP_Query Loop? [duplicate]
  86. How to shows CPT which has specific meta key?
  87. Avoid another meta box in my custom post type
  88. Conditional posts in WP_query for search
  89. Delete custom post type metadata without deleting the post in admin area
  90. Calling specific page with wp query
  91. How to stop wp_query searching pages as well as the specified CPT
  92. Unable to get the upcoming events for custom post
  93. Trying to combine multiple WordPress queries
  94. 404 on Pages for Custom Post Type & Query_Posts
  95. How to query custom post then display sections by meta value
  96. Show Posts in Vertical Tabs with Scrollbar
  97. Display div based on Group metabox selection [closed]
  98. Check for custom field value in different post type than current one and do something
  99. WP_Query() displaying past post / event
  100. WP Query Conditionally query meta and taxonomy
tech