query post based on comparison

Is their anyway we can do the filtering (i.e comparing 3 values) in
wp_query itself?

What you are asking is tricky in pure SQL, though it can be done. WP_Query cannot handle the logic natively, though. You would have to create one or more filters.

Doing this with the data structure you have right now is not ever going to be especially efficient though. The best answer has already been suggested in a comment– change your data structure so that you are saving rating to a single key such as my_gob_rating. You can then retrieve your data with a meta_query. Like this:

$args=array(
  'post__not_in' => array(get_the_ID()),
  'posts_per_page' => 10, // Number of related posts to display.
  'meta_query' = array(
    array(
      'key' => 'my_gob_rating',
      'value' => 10, // whatever the cutoff is between 'ok' and 'good'
      'compare' => '>=',
    )
  ),
  'ignore_sticky_posts' => true
);

You can change the compare operator to BETWEEN to get your “ok” data, and to < to get your “bad” values, if needed.

Also…

ignore_sticky_posts (boolean) – ignore sticky posts or not (available
with Version 3.1, replaced caller_get_posts parameter). Default value
is 0 – don’t ignore sticky posts. Note: ignore/exclude sticky posts
being included at the beginning of posts returned, but the sticky post
will still be returned in the natural order of that list of posts
returned.

http://codex.wordpress.org/Class_Reference/WP_Query

Related Posts:

  1. Fetch Record based on meta key dates
  2. how to make members list directory through wordpress post custom meta key.
  3. meta_query weird behaviour, static int will work, but not user data
  4. How do i create a custom post query when the meta value is an array?
  5. Custom WP_query and integrating into theme file
  6. Nested meta_query with multiple relation keys
  7. Use REGEXP in WP_Query meta_query key
  8. Meta query with string starting like pattern
  9. compare meta_query in get_posts arguments
  10. Getting attachments by meta value
  11. Query Multiple Post types each with own meta query
  12. Perform query with meta_value date
  13. querying with custom meta field with meta_query
  14. Meta Query with date and time on the same Day before given time
  15. Order by meta_value_num DESC and meta_value ASC on WP 4.0
  16. How do I create my own nested meta_query using posts_where / posts_join?
  17. WordPress altering my custom query, How to fix it?
  18. Querying by taxonomy vs Querying by Custom fields Speed Comparison
  19. How to query ‘posts_per_page’ to display a different blog posts index template?
  20. Order by meta_key in custom post type doesn’t affect the query
  21. How to show only one post for each categories of taxonomy of custom post that contains a specific custom field
  22. meta_key and meta_value not working together
  23. How add a custom posttype name using ACF field to a query post array
  24. How to implement time filter to show random post 1 month for one category and 3 months for other categories
  25. Order Posts by meta value AND published date
  26. Order a query result by a numeric meta key even if it does not exist, but put the posts with meta key first
  27. WP_Query last five posts, simply ordered by meta_value
  28. How to make Meta Query case sensitive?
  29. How to display multiple custom fields with the same meta_key in an ascending order?
  30. Meta_query with multiple keys and multiple values
  31. Bypass “supress_filters” in WP Query
  32. meta_query BETWEEN, but the range is stored in the custom field
  33. Extend product search with meta in WooCommerce
  34. Large AND OR query timing out
  35. Add class to first post in custom loop using post_class filter
  36. WP_Query with different postmeta filter for each categories
  37. meta_value_num not ordering all items
  38. Slow WP_Query with ‘OR’ on meta_query
  39. Query all posts if multiple meta key don’t exist
  40. meta_compare not comparing whole integer
  41. Filter Custom Taxonomy Posts
  42. How to provide meta_key array to wp_query?
  43. Filter post query to only show direct children of category
  44. Order post type by sum of two custom fields
  45. How to make posts unqueryable/unpublish posts where ACF relationship field is an unpublished post? [closed]
  46. Conditional operator OR not working with custom fields
  47. Display posts with specific value first in query
  48. Get every post with value in meta key
  49. Posts query according to meta box date
  50. Retrieve select tag custom values from array and display them in current page with wp_query?
  51. How to use a dropdown to filter posts by custom field
  52. add_query_arg to compare and display events from a certain date
  53. Show single posts date, in a page of posts
  54. Comparing 2 Decimal Numbers from custom fields and displaying posts
  55. Why doesn’t my WP Meta Query return any results?
  56. filter posts by meta key with pagination
  57. WP_Query Class custom field parameters
  58. Query multiple post types, but different order for each
  59. Order by the first array within a meta_query
  60. Query ACF relationship field – Comparator IN – Value array
  61. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  62. How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
  63. Custom meta_query order for Elementor based on post meta key [closed]
  64. How to add a “base” filter for all posts visible to visitors on the site?
  65. ElasticPress is (aparently) messing with my search filters
  66. WP Query – grouping posts by same meta key, adding together values from another key
  67. meta_query is overriding default search
  68. Trouble with serialized metadata
  69. Query for current post
  70. Custom query to retrieve oldest post and retrieve others with date interval
  71. Comparing Meta Field date in WPQuery using Meta_Query?
  72. Getting posts by custom field value
  73. Query against multiple locations within single custom post type post
  74. WP_Query, ACF field and array
  75. Problem with my loops
  76. Sorting query_posts() with a complex orderby filter
  77. Order by Date Custom Field
  78. Query by meta value (add a dropdown of all values)
  79. Order Posts By Custom Field That is an array of objects
  80. Orderby query does not work for custom fields even with meta query
  81. Using custom field as ‘orderby’ value causing post grouping by publish date
  82. Compare meta key separation
  83. query_posts with sorting on a custom datestamp
  84. Get posts by meta value except one post [closed]
  85. WP Query – Show custom posts only if user contain some user meta
  86. Filtering posts by custom field value not working
  87. Query post with meta_query where date is not in future
  88. pre_get_posts order by not working
  89. Order query by meta_value with multiple custom fields
  90. WP Group posts by year(desc) > month(desc) > date(asc)
  91. WP_Query not returning correct result with meta_query parameter
  92. Custom query looking at multiple custom fields and properly sorting
  93. How to do WP_User_Query for Nested Array value Inside Nested Array field
  94. Use WP_query to match post types based on custom field values
  95. How to filter on placeholder image
  96. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  97. WP_Query doesn’t works inside loop
  98. Creating Custom Query
  99. Help in query for list links
  100. Extend search query to search meta keys values based on search string