How to combine custom fields to make one order-able value

If you want to make it as easy as possible on the user, then I think the best option would be to add a custom meta box with three fields for inputting the day/hour/minute values. Using something like a jQuery UI slider style timepicker would further simplify input. Then when the post is saved, use the save_post action to store those three values in a single field.

The second option is similar to the first, but you’d continue using the custom fields as you are now, except a fourth field would be added by you on the save_post action to combine them into a single field you use in your query.

Related Posts:

  1. WP_Query – Order results by meta value
  2. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  3. Filter WP_Query for posts having a certain meta-value
  4. Can I query custom meta data through WP_Query
  5. Meta Query with AND & OR?
  6. How do I search an array stored in a custom-field using WP_Query?
  7. How do I order by multiple custom fields using wp_query?
  8. Trying to perform complex custom field query with order by set to field value
  9. Query meta field using between
  10. Order Posts by Closest Numeric Values
  11. 2 orderby in wp_query with 2 custom fields
  12. Can serialized arrays in DB be matched against serialized arrays with meta_query?
  13. How to get a meta value from all post
  14. Compare meta_query decimals not working right
  15. WP_Query multiple use of relation and/or
  16. Query Problem – Show posts within category ‘x’ that have a custom field between ‘y’ and ‘z’
  17. Using OR in WP_Query negates the “NOT EXISTS” compare
  18. WP_query : meta_key with custom rule for specific value
  19. How can I combine meta_query queries?
  20. How to filter a dd/mm/yyyy date from a custom field in a query
  21. Using WP Query to search by multiple meta fields
  22. Difference between ‘LIKE’ and ‘IN’ in meta queries
  23. Compare WP Custom Field date
  24. Sort by posts that have a featured image?
  25. WP_Query display next custom post from today’s date
  26. Order by value in serialized custom field
  27. $wp_query meta_key naming issue [closed]
  28. Author Page Custom Query WHERE author OR [post meta value] OR [post meta value]
  29. Meta_query and numeric comparison [closed]
  30. Adding Custom Fields to Search
  31. Upcoming Event: How do I sort database by custom date field, but ignore past dates?
  32. Any way to include custom fields in WP_Query results?
  33. Multiple relationships in a query
  34. WP Query Returning All Posts
  35. How do I use wp_query for WordPress search?
  36. Meta query with timestamp using WP_query
  37. Conditional custom field query
  38. Order query by meta_value with multiple custom fields
  39. Auto Populate Custom Field with Complex Value That Increase by One?
  40. Custom WP_Query for WordPress Search Results with meta_query
  41. Meta Query And/Or
  42. Passing meta_box string to post__in?
  43. Query post by date (stored custom field meta as yyyymmdd) and differentiate across 12 months
  44. meta_value and meta_key filtering returning no posts [closed]
  45. Select custom posts by meta_value and sort by a different meta value
  46. Can’t query by meta_key
  47. Adding custom field and querying from post table
  48. Meta query relation ‘OR’ not working as expected
  49. The best way to collision check in WP
  50. WP_query multiple custom fields not working
  51. Custom Query Fields – Altering Meta Value
  52. How to query for posts with either one or another custom field
  53. Multiple Custom Field Query
  54. How to update custom field of a posts in a particular category
  55. How can I modify my meta_query to work with prices that are stored in the database that contain dollar signs and commas?
  56. Query to sort a list by meta key first (if it exists), and show remaining posts without meta key ordered by title
  57. WP Query multiple select form – meta_query help
  58. How to Order Posts by Custom Fields?
  59. WP_Query based on multiple metadata comparisons
  60. Complex WP_Query Using Post Date And Post Meta
  61. Display posts where date field matches current month?
  62. Show posts containing or not custom field
  63. Display agents (custom post type) alphabetically, except one who always shows last
  64. Query posts by Custom Meta (checkbox) & Genesis Grid Loop
  65. Need small coding with Custom Fields Search
  66. How can I remove fields in the attachment editor?
  67. WordPress Search Custom Meta Field Only
  68. Get post info inside modal window?
  69. Which is best in the following scenario : post_meta vs custom table vs parent/child posts
  70. How to add content at the end of posts?
  71. WP_Query orderby modified to include custom meta changes
  72. wordpress custom fields multiple data
  73. Why the pagination for a query modified by pre_get_posts doesn’t mind the number & order of posts sorted & selected based on a custom date time field
  74. Large AND OR query timing out
  75. Trying to update_post_meta function
  76. Categorising search results based on Custom Fields
  77. How do i add custom fields to my themes template file?
  78. Custom Field to a Role?
  79. Shortcode To Display Post Custom Field Value in Post Title, Post Content
  80. How to make a customized user registration form using the built in wp-register() template tag
  81. Link FROM attachment to full post and get custom fields values on attachment page?
  82. How to copy data from a custom field to the post_content?
  83. Custom field as featured image caption
  84. Query only displays one page_id
  85. add meta box considers the selected option as post parent
  86. How do I display a custom field in an existing form on the front end?
  87. Extend WP_User_Query or WP_User to return all custom fields?
  88. Quicktag button to automatically add a custom field to a post
  89. WordPress taxonomy child image
  90. Create custom fields/meta data gender+country – radiobuttons and dropdown on register screen for these fields
  91. How do I display posts with specific value in a custom field into my loop?
  92. Add nofollow to custom field link and make domain exceptions?
  93. wordpress simple post multi rating with post_meta and user_meta
  94. Download stuff after filling fields?
  95. Querying meta values within an array
  96. Custom registration form and custom field
  97. How can i put a custom field inside this php
  98. Add fields to edit in custom widget
  99. custom field value is blank or empty
  100. How to add a custom field to the comments “Quick Edit” screen?
tech