The orderby argument is limited by what is possible in MySQL, and it’s not good at natural alphanumeric sorting like you describe. Possible options include: Rewriting the values with leading zeros, e.g. “CA05” Creating a separate “Sort Order” column that just stores an integer, and ordering by that. Separating the letters and numbers into two … Read more
You can use the code update_post_meta( get_the_ID(), ‘_stock_status’,$value) to change the value of the meta. Please place the above line in the code where you want to change the status value and remember $value is the variable/array/object you can place any string/array/object in it.
What I don’t really understand is how or what the ‘orderby’ => ‘meta_value’, is actually sorting by as the key has multiple values. It doesn’t have multiple values. It has a single value: a:2:{s:3:”day”;s:1:”8″;s:5:”month”;s:5:”March”;}` This is a ‘serialised array’. This is just a way to store an array as a string. As far as WordPress … Read more
Thank you everyone for your help! In the end the query below got me the results I desired – which was to show and sort the posts by a custom field of “publication_date” first – sorting by the date, and if there were multiple of the same date (say, 4 marked June 2013), it would … Read more
Probably should have waited a bit but after posting the question I found a solution based on my points above and repeated here: https://codex.wordpress.org/Class_Reference/WP_Meta_Query https://generatewp.com/filtering-data-with-wp_meta_query/ My Solution: $metaSearchSubQuery = [ ‘relation’ => ‘OR’ ]; foreach($eventTypeId as $id) { $metaSearchSubQuery[] = [ ‘key’ => ‘EventId’, ‘value’ => serialize($id), ‘compare’ => ‘like’ ]; } $metaSearchQuery[] = $metaSearchSubQuery;
I figured it out… $meta_value = get_user_meta( $atts[‘owner’], $meta_key, true ); $store_numbers = array(); foreach ($meta_value as $store_number) { $store_numbers[] = ‘shop’.$store_number; } $usernames = $store_numbers;
I founded myself my searching: $sql = $wpdb->prepare( ” SELECT meta_value FROM {$wpdb->prefix}commentmeta INNER JOIN {$wpdb->prefix}comments ON {$wpdb->prefix}commentmeta.comment_id = {$wpdb->prefix}comments.comment_ID WHERE comment_post_ID = %d AND meta_key = ‘rating’ AND meta_value IS NOT NULL AND meta_value <> ” “, get_the_ID() ); $results = $wpdb->get_results( $sql );
Get meta_value from GDRating
If you run this query manually, you should get a response like (1054, “Unknown column ‘wp_postmeta.meta_key’ in ‘where clause’”) Long story short, wp_postmeta.meta_key is not a valid column of wp_posts. You need to JOIN the postmeta table to be able to use its columns. (There are many resources out there that explain JOIN, one would … Read more
Ok I’v created a admin plugin to do this… If you have better idea 🙂 I’m in Create a admin button to open a csv file of meta_value to compare with existing products. and update products as featured if exist. add_action(‘admin_menu’, ‘featured_button_menu’); function featured_button_menu() { add_menu_page(‘Featured Products Page’, ‘Mise en avant produits’, ‘manage_options’, ‘featured-button-slug’, ‘featured_button_admin_page’); … Read more