The way you are trying to do it is probably the wrong way. WP_Query does not have any build in feature to subtract the values from two custom fields and then returning (or ordering) posts according to the value of the subtraction from the two fields. You can probably filter the generated SQL via the … Read more
After some research on wp codex I found my solution. Here I have to change birth_date format during save. I saved value like yy-mm-dd this format and changed my meta_query Here is the code $studentdata = get_users( array( ‘meta_query’=> array( array( ‘key’ => ‘birth_date’, ‘value’ => array( $startyear.’-01-01′,$endyear.’-12-31′), ‘compare’ => ‘BETWEEN’, ) ), ‘role’=>’student’ ) … Read more
You’re meta querying on serialized data. I mean the artist from ‘key’ => ‘artist’ is serialized. That’s why your meta query hasn’t work. So here is my possible solution- $projects = get_posts(array( ‘post_type’ => ‘project’, ‘meta_query’ => array( array( ‘key’ => ‘artist’, // name of custom field ‘value’ => ‘”%’ . $artist->term_id . ‘%”‘, ‘compare’ … Read more
As you said data is stored inside meta_value as serialized format. You can match your string among the serialized string like data. $args = array( ‘meta_query’ => array( array( ‘key’ => ‘submitted’, ‘value’ => sprintf(‘:”%s”;’, ‘vivek’), ‘compare’ => ‘LIKE’ ) ) ); $query = new WP_User_Query( $args ); Hope this help!
The problem is that you’re passing a meta VALUE in the key field of the meta_query…you should be passing your meta KEY there (“_wccf_pp_event_date”), as in: $seasons = array ( ‘spring’ => array (‘2017-03-21’, ‘2017-06-20’), ‘summer’ => array (‘2017-06-21’, ‘2017-09-20’), ‘fall’ => array (‘2017-09-21’, ‘2017-12-20’), ‘winter’ => array (‘2017-12-21’, ‘2018-03-20’), ) ; foreach ($seasons as … Read more
LIKE as a compare value doesn’t make sense with an array. You want compare to be IN. Also, you’ve got an extra set of quotes in the values for no reason: $meta_query_args = [ [ ‘key’ => ‘checkboxes’, ‘value’ => [‘facebook’, ‘twitter’], ‘compare’ => ‘IN’, ], ]; EDIT: So, according to your comment you’re using … Read more
The meta_query cannot be used to search value which are stored as serialized arrays. You can use it to search multiple values (meta-fields can have several values using the same key). You need a different approach to solve your problem, this is what I suggest, store your meta field with the user id as part … Read more
‘meta_key’ => ‘clpr_topcoupon’, ‘orderby’ => ‘meta_value_num’, ‘order’ => ‘DESC’ You can solve the problem by using order by clause then there will no need to write meta query. Please use the above code to solve your problem.It will show the posts according to descending order of the value in meta key.
I’ve tried the meta query on another simple wordpress site, and it works there, so there must be something else going on, meddling with the query.. I’ve been doing some digging with the Query Monitor plugin… I thought it might have been because I’ve also been meddling with pre_user_query, but I can see that I … Read more
The whole problem was in WooCommerceCategoryExcluder (old, obsolete and unmaintained) plugin which hooks to pre_get_posts and adds taxonomy query to get_posts() args. Maybe this investigation helps someone else trying to solve similar problem.