Why you are querying for meta query if your length is taxonomy? Replace meta_query with tax_query in your query and it should start working. Taxonomy parameters in WP_Query Custom fields parameters in WP_Query
Solved. After the edit it was easy. It is allowed to use type => ‘decimal(x,x)’ in meta_query. Maximum precision is decimal(65,30). https://dev.mysql.com/doc/refman/5.7/en/precision-math-decimal-characteristics.html array(6) { [“orderby”]=> array(2) { [“uss_product_price”]=> string(4) “DESC” [“title”]=> string(3) “ASC” } [“meta_query”]=> array(3) { [“relation”]=> string(3) “AND” [“sortprimary_clause”]=> array(3) { [“key”]=> string(17) “price” [“compare”]=> string(6) “EXISTS” [“type”]=> string(13) “decimal(30,5)” } [0]=> array(4) … Read more
The reason you’re only getting those users that have that meta_key is because you’re include ‘meta_key’ => ‘…’ in $args. That limits results to those that have that key, regardless of any clauses you may have in a meta_query. This applies to WP_Query, WP_User_Query and WP_Comment_Query. Starting in WP 4.2, you can “name” the clauses … Read more
Considering your current code I think you missed the WP Meta Query class which can do what you want; https://codex.wordpress.org/Class_Reference/WP_Meta_Query
I went with custom taxonomy instead of custom meta field and it works great (although I am still not sure why meta_query didn’t work) I have saved custom taxonomy term for each attachment wp_set_object_terms($post->ID, $slug, ‘image_category’ ); And custom query args are $args = array( ‘post_type’ => ‘attachment’, ‘posts_per_page’ => 44, ‘post_status’ => ‘inherit’, ‘post_parent’ … Read more
You are doing the right thing. In theory you can probably intercept the “normal” API request and modify the relevant wp_query to whatever you need, but this will mean that you are changing and overriding that API and if you will need it in its “virgin” form at some point it will not be available. … Read more
SOLVED: I had this in the function to save the meta data (like an idiot!!) if ( !$value ) delete_post_meta( $post->ID, $key ); // Delete if blank So it wasn’t saving the meta value if set to 0. I changed it to: if ( !$value ) add_post_meta( $post->ID, $key, ‘0’ ); // add 0 if … Read more
What you are doing is not a valid way of retrieving and checking serialize data from the WP. You may insert array as a user meta but this array behind the scenes is transformed to serialize string something the MySql can handle. There are options for searching with the LIKE operator but I don’t endorse … Read more
This is a symptom of having a % character in your meta query value. Since 4.8.3 % characters are being escaped (actually replaced by a semi random string) and should be unescaped before executing the sql query. You should check with the plugin author what would be the best way to handle it, but in … Read more
If the key-2 is uniquely assigned to cpt-3 post type, then you can add another meta query argument to your query arguments: array( ‘key’ => ‘key-2’, ‘value’ => 1, ‘compare’ => ‘=’ ) If not, you can run another query, and then merge them as follows: $final_query = array_merge( (array) $query_1, (array) $query_2 ); But, … Read more