meta-query - Read For Learn

Single meta_query query using OR instead of AND in request’s WHERE statement

I believe the shortest and best approach is to (1) modify the query: function search_faqs_metadata($query) { if(!is_admin() && $query->is_main_query()) { if($query->is_search) { $query->set(‘meta_query’, array(array( ‘key’ => ‘_faqs’, ‘value’ => $query->query_vars[‘s’], ‘compare’ => ‘LIKE’ ))); } } } add_action(‘pre_get_posts’, ‘search_faqs_metadata’); and then (2) replace the AND with OR via the get_meta_sql filter: function change_meta_key_where_from_and_to_or($sql) { if(is_search()) … Read more

Does meta_query working with value paramater higher then 999?

I found solution by using type parameter in meta_query, set it to numeric. By default it is char and 1000 interpreted as string. ‘meta_query’ => array( array( ‘key’ => ‘wpcf-product-price’, ‘value’ => array(0, 1000), ‘type’ => ‘numeric’, ‘compare’ => ‘BETWEEN’, ), ),

advanced search forms with 3 input text and that the main problem 3 input text

As you’ve already get results with tag I’m going to give suggestion only for address and rating. For your current situation, the best option is to use WordPress post meta to store these values. Then you can use meta query to retrieve those posts. $args = array( ‘post_type’ => ‘hotel’, ‘meta_query’ => array( array( ‘key’ … Read more

Complex WP_User_Query call fails on production server

When executing the generated SQL statement in MySQL it gave me The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay To fix that I had to call $wpdb->query( ‘SET OPTION SQL_BIG_SELECTS = 1’ ); right before calling WP_User_Query.

Query metas (and not : query posts by metas)

Look at the section on $wpdb->get_results(), it allows you to send distinct queries to the database, which is what it sounds like you are looking to do. So… // 1st Method – Declaring $wpdb as global and using it to execute an SQL query statement that returns a PHP object global $wpdb; $results = $wpdb->get_results( … Read more

pre_get_posts order by not working

I think this would be easier if you had the performance_datetime custom field, because that could simplify your meta query. The following is just a demo fun for you to play with: As far as I understand the problem, you get three INNER JOINS on the wp_posts table, namely wp_postmeta, mt1 and mt2. But the … Read more

Complex Orderby Parameters: How to query with multiple orderby parameters using meta_value_num?

Boohoo why did I start a bounty for that 😉 The answer is pretty simple – add ‘type’ => ‘numeric’ to the meta query. array(5) { [“posts_per_page”]=> int(6) [“orderby”]=> array(2) { [“uss_product_price”]=> string(4) “DESC” [“uss_product_weight”]=> string(4) “DESC” } [“meta_query”]=> array(3) { [“relation”]=> string(3) “AND” [“sortprimary_clause”]=> array(3) { [“key”]=> string(17) “uss_product_price” [“compare”]=> string(6) “EXISTS” [“type”]=> string(7) … Read more

WP_Query on custom field and order results

Change your code with this and might help you with what you are looking for. The issue here is that we cannot include key, order and orderby in meta_query. But if you want to order you result posts based on key than you can pass the query arguments as below: $custom_query_args = array( ‘post_type’ => … Read more

Using pre_get_posts for meta value of LIKE comparison on ACF repeater sub field

You need to add Wildcards to your meta_value. Change $query->set(‘meta_query’, array( array( ‘meta_key’ => ‘test_repeater_%_test_sub_field’, ‘meta_value’ => $search, ‘compare’ => ‘LIKE’, ), )); To $query->set(‘meta_query’, array( array( ‘meta_key’ => ‘test_repeater_%_test_sub_field’, ‘meta_value’ => ‘%’.$search.’%’, ‘compare’ => ‘LIKE’, ), ));

Extending woocommerce admin product search

I solve this problem it’s too easy just paste the code in functions.php and the code do not remove the default searching by title. See The Example with screenshots First, add your Custom Field Group with Post Type is equal to Product and add a new field with field label and field name as like … Read more

+ More