The Problem I think there’s a typo in there: The name of the filter is posts_fields not post_fields. That could explain why the title2 field is unknown, because it’s definition isn’t added to the generated SQL string. Alternative – Single filter We can rewrite it to use only a single filter: add_filter( ‘posts_orderby’, function( $orderby, … Read more
The OrderBy argument can take more then one parameter so the solution was to change : ‘orderby’ => ‘meta_value_num’, to: ‘orderby’ => ‘meta_value meta_value_num’,
When declaring your custom post type using the register_post_type function, you have to add ‘page-attributes’ to the support field, like in the following example: register_post_type(‘myposttype’, array( ‘supports’ => array(‘title’, ‘editor’, ‘page-attributes’), ‘hierarchical’ => false )); You’ll need to add any other supported meta boxes as well to the ‘supports’ field, see https://developer.wordpress.org/reference/functions/register_post_type/ for more information … Read more
You can use a filter to modify the ORDER BY statement of WP_query. That way you can manually set the query to use ORDER BY RAND($seed); Mysql RAND() accepts a seed as an optional argument. Using a seed, it will return the same randomized result set each time. So you can generate a random number … Read more
OK – in the end turned out to be fairly simple – as I’d had some kind of mental block – menu_order is a variable in the $post object (thanks to @brady for reminding me of that). @scribu’s post on creating sortable column values then gives the rest. So, assuming the custom post type is … Read more
There’s two possible solutions to this: 1. All posts have meta The best solution I have found here is to give the rest of the posts/products an item price of 0. You can do this manually, or loop through all the posts and if the price is empty then update it. To make this manageable … Read more
orderby should be meta_value_num, or meta_value, not the name of the key. See WP_Query orderby parameters.