Update class-wp-site-query.php - Change function parse_orderby()

[lenasterg]

This is a follow-up to #26580.
Currently there isn't allowed to sort the site query based on the 'deleted' field which is striped from the "orderby" keys due to parse_orderby() function.

In order to have plugins that give the ability to add filters to the sites list to sort deleted/active sites, we need the 'deleted' field of wp_blogs table to be sortable.

A possible solution suggestion into the following PR

​https://github.com/WordPress/wordpress-develop/pull/2345

Addition to function parse_orderby()
the case 'deleted'
This is useful in order to allow the sites to be sortable based on the 'deleted' field column.

Trac ticket: https://core.trac.wordpress.org/ticket/55226

[peterwilsoncc]

To try and avoid followup tickets, is the same needed for any/all of the other boolean fields in the table: mature, spam, archived, public?

[lenasterg]

Hi,
I think you are right about that. It's better to do it for all the fieldes.

Replying to peterwilsoncc:

To try and avoid followup tickets, is the same needed for any/all of the other boolean fields in the table: mature, spam, archived, public?

[peterwilsoncc]

@lenasterg I've pushed some additional commits to your branch to add the additional booleans and include them in the documentation.

[peterwilsoncc]

In 53107:

Networks and Sites: Increase sort options in WP_Site_Query.

Add orderby support for the boolean options: deleted, spam, mature, archived and public.

Props lenasterg, SergeyBiryukov.
Fixes #55226.

Merged in https://core.trac.wordpress.org/changeset/53107