I solved this with a different approach. I used posts_join and posts_orderby filters. Do not forget to cast meta value as unsiged to avoid string ordering instead of int. //edit query join function hsa_story_join($join){ global $wpdb; $option = get_option(‘hsa_story_cats’); if(!is_admin() && is_category($option)) { $current_category = get_queried_object(); $join .= ” LEFT JOIN (SELECT post_id, meta_key, meta_value … Read more
Try creating a custom rewrite rule and a custom rewrite tag. This should allow you to set up a regular expression to capture the ID and manipulate the query. Rewrite API/add rewrite rule « WordPress Codex https://goo.gl/kdEJd8 Rewrite API/add rewrite tag « WordPress Codex https://goo.gl/PVLzLh
First of all, $query object is passed by reference, you don’t need to return $query in pre_get_posts. Second, is_post_type_archive( ‘events’ ) will work just fine, you don’t need to use query->query_vars[]. Corrected code will look like this: function my_pre_get_posts( $query ) { if( ! is_admin() && is_main_query() && is_post_type_archive( ‘events’ ) ) { $query->set(‘orderby’, ‘meta_value_num’); … Read more
You could do two things: A) replace the search with a SQL query that only searches the postmeta table (faster as there’s no JOIN involved – you can get the post via it’s ID later on, when displaying the results). B) Split the string right after WHERE 1=1 and drop the later part. You can … Read more
I think you should be able to do this with the user_has_cap filter. Because that filter passes through the post ID in the $args for the edit_post capability, you can use that to check if the current user has been artificially given this capability – and if so, force the edit_post capability to be true … Read more
OK so for reference I ended up actually using switch_to_blog() and restore_current_blog(). I found no references whatever for querying multiple tables (except writing my own JOIN-statements) when followed the source code for the action pre_get_posts. A lot of advice was given to skip restore_current_blog() to save CPU-cycles but when I checked the source code for … Read more
I would suggest you when you are updating meta values with 1 update rest with 0. I mean set the key in all posts with 1 or 0 to avoid the complex query. You can still do it with a simple script. It will check if key doesn’t exist then update it with 0. So … Read more
You can use pre_get_posts action to achieve that: add_action( ‘pre_get_posts’, function ($query) { if ( ! is_admin() && is_archive() && $query->is_main_query() ) { $query->set( ‘posts_per_page’, 100 ); } }); In the code above I use is_archive(), but you can use other conditional tags in there…
Yes, pre_get_posts runs for REST API requests. Your issue is likely that your request is not properly authenticated, so $user_ID is not set. To allow the REST API to recognise the logged-in user you need to send the wp_rest nonce with the request. You can create this with wp_create_nonce( ‘wp_rest’ ) and send it with … Read more
One way is to use the offset parameter in WP_Query, but it overrides the paged parameter according to the docs. Example formula for an offset with pagination: ‘posts_per_page’ => $posts_per_page, ‘offset’ => ( $paged – 1 ) * $posts_per_page + $offset_per_page, Example: Then for $posts_per_page as 4 and $offset_per_page as 5 we get the post … Read more