Wordpress: how to make "on approval" entries always on top?

Question

WordPress

Tell me how you can do so that the records that are under approval are always higher than the rest of the records.
I dug into the code for half a day, but I couldn’t do it, plugins also don’t seem to fit my problem.

Answer 1

All post requests can be edited on the hook pre_get_posts. For admin requests, it looks something like this:

add_action( 'pre_get_posts', 'admin_pre_get_posts', 1 );
function admin_pre_get_posts( $query ) {

  if( is_admin() ) {
    $query->set( 'posts_per_page', 200 );
  }

}

The orderby argument is responsible for sorting posts , but, unfortunately, sorting by the post_status field cannot be done right away.
You can:

1. Try solutions from the internet
   
2. Add your field to post_meta on the hook save_postand sort by this field
   
3. Score, because you even have a separate tab "Pending approval" on the screenshot, use it