You can run a loop through all your posts and change their meta value. To do so, create a plugin and run a loop upon its activation, using get_posts(): <?php /* Plugin Name: Update MetaData for Posts Description: Enable this plugin to update the metadata for all the posts Author: JackJohansson Version: 1.0 Author URI: … Read more
If you look at the Codex for WP_Query you will notice that orderby is not a valid parameter for a meta_query, nor is order, and in fact nor is meta_key. But even if that were sorted out, I don’t think you can do what you are trying to do with WP_Query. A meta_query is a … Read more
There are similar posts on this site about the same topic, if you look around. But here is your answer: To make this work you need to change your date format. You can sort alphabetically, or numerically, not calender-merically. The only human date format that orders correctly is YYYY/MM/DD. The separator are optional and shouldn’t … Read more
After thinking about the problem, I found the simplest solution, do a direct query using $wpdb in archive-{post-type}.php <?php global $wpdb; $meta_key = get_query_var(‘publisher’); $result = $wpdb->get_results(” SELECT * FROM ” . $wpdb->prefix. “postmeta_books WHERE publisher LIKE ‘%$meta_key%’ “); foreach( $result as $results ) { echo $results->publisher; echo ‘<br/>’; } ?> It is the basic … Read more
A couple things, Make sure in your save_post hook you’re checking for DOING_AJAX which is used for saving in quick-edit. Check out my other question: Quick edit screen customization. The answer I received worked, but I haven’t actually implemented it into my plugin quite yet as it’s not a priority of mine yet. Hope that … Read more
As of WordPress 3.4.1, there is no way, out of the box, to order by multiple meta values. Since we can’t do it cleanly, we’ll have to hack something together. We can hook into posts_orderby to manually modify the ordering. It’s not altogether pretty, but it will get the job done. Here’s an example: add_filter(‘posts_orderby’, … Read more
One possibility is a direct SQL query similar to the one given here. But I’m not convinced that it would be much more efficient than 2 queries, all handled by WordPress: The is untested $price =0; //Price of current property $id=0; //Property (post) ID. $args = array( ‘post_type’ => ‘property’, ‘post__not_in’=>array($id), ‘posts_per_page’=> 2, ‘meta_query’ => … Read more
You can filter the query for these keys on’query’. I would start that filter as late as possible to avoid side effect. Sample code, tested: add_filter( ‘postmeta_form_limit’, ‘wpse_73543_hide_meta_start’ ); function wpse_73543_hide_meta_start( $num ) { add_filter( ‘query’, ‘wpse_73543_hide_meta_filter’ ); return $num; } function wpse_73543_hide_meta_filter( $query ) { // Protect further queries. remove_filter( current_filter(), __FUNCTION__ ); $forbidden … Read more
Your problem is this: CAST(wp_postmeta.meta_value AS SIGNED) Run a simple SQL query (command line or PhpMyAdmin, whatever you like) like SELECT CAST(‘1.2’ as SIGNED) and you will see that the value returned is 1. What causes that cast is ‘type’ => ‘NUMERIC’,. You can pass DECIMAL to meta_query instead of NUMERIC but I don’t see … Read more
The following is just a proof of concept and needs to be adapted/improved to work per the Question requirements. It creates a meta box with a dropdown listing all available Navigation Menus. On post save, it is added to the selected menu. This Q&A was used as starting point: Programmatically add a Navigation menu and … Read more