Add filters to WP_MS_Sites_List_Table::prepare_items()

[csixty4]

In WP_MS_Sites_List_Table::prepare_items(), it would be helpful to be able to filter $like_s before it gets integrated into the query (we needed to force a like %keyword% query).

It might also be handy to filter the WHERE and ORDER BY clauses.

The query filter can be used to alter the SQL after it's generated, but that's just asking for trouble.

[nofearinc]

Related: #25360

[danielbachhuber]

#25338 is related in the sense that there's this general trend of wanting to be able to easily filter prepare_items(). I think it would be interesting to see a patch (that would also solve pagination, total items, etc.)

[lenasterg]

Hi.
In the attached file I imported a simple filter "wpmu_blogs_orderby' in prepare_items() function. This way at least a custom column made be a plugin can be sortable.
Example usage:
Sort a custom column created from a plugin which shows the "deleted" field of wp_blogs

add_filter( 'wpmu_blogs_orderby' , 'mycustom_column_orderby' ) ;

function mycustom_column_orderby( $order_by ) {
    if ( $order_by == 'deleted' ) {
        $query = 'ORDER BY deleted ' ;
        return $query ;
    } else {
        return null ;
    }
}

What do you think about this solution?

[lenasterg]

Suggestion new filter "wpmu_blogs_orderby" into prepare_items

[mbootsman]

This would also be useful to have plugins give the ability to add filters to the sites list. Like, only show deleted/active sites.

[danielpataki]

I think that's slightly different than the title of this ticket, although it is definitely related. I created #32956 to add the frontend requirements for what you need :)

[jeremyfelt]

With the addition of WP_Site_Query (#35791) and its use in WP_MS_Sites_List_Table (#36675), we should soon have a place to use a filter like ms_sites_list_table_query_args before the query for the list table is requested.

[jeremyfelt]

After [37736], WP_MS_Sites_List_Table is now in a better position for a ms_sites_list_table_query_args filter. Marking this as a good first bug.

[flixos90]

26580.diff​ adds the filter for the query arguments.

[jeremyfelt]

In 37899:

Multisite: Add a ms_sites_list_table_query_args filter to WP_MS_Sites_List_Table.

This allows a developer to filter the arguments used to query sites during the prepare_items() method.

Props flixos90.
Fixes #26580.