List tables newest first

Hi,

thanks for your question, and sorry for the trouble.

I see what you mean, but the only solution I can offer here at the moment is to use the sorting funcionality on the “All tables” screen. For example, when clicking on the “ID” column’s header cell, the order will be reverted, which should then be corresponding to the newest tables being on top.

Regards,
Tobias

Yes! i know I can sort it, but when you have to do that in every part of WP it gets quite annoying!

Is this a fundamental WordPress thing? It must be hard to change as every plugin seems to suffer from this. As does WP in listing pages. Maybe I should put the question/suggestion in a different forum. It seems like a miracle that Media Library is newest first.

Hi,

yes, this is indeed coming from WordPress. There a common functionality that plugins can use to show such lists, which is the reason why all of them suffer from these drawbacks.

The reason why this is possible in the Media Library probably is that it is much newer than that mentioned lists functionality, and therefore can make use of other concepts and coding features.

The lists functionality of WordPress will be overhauled in upcoming releases though, from what I have heard. Maybe giving the lists a different default order will then be possible in an easier way.

Regards,
Tobias

If it’s this easy to show newest first in NextGen galleries then why not in Tablepress?

In file products/photocrati_nextgen/modules/ngglegacy/admin/manage-galleries.php

Swap the asc and desc to give this:

` if (!empty($_GET[‘order’]) && in_array($_GET[‘order’], array(‘ASC’, ‘DESC’)))
$order = $_GET[‘order’];
else
$order = apply_filters(‘ngg_manage_galleries_items_order’, ‘DESC’);`

Hi,

such a filter could indeed work, but I’d have to see if this can be added without TablePress having to do an extra sorting.
Thanks for the sugggestion, I’ll investigate this!

Regards,
Tobias

Is it view-list.php that determines the order? I think so. But what determines the default order of the ID there? Is there a hack I can put in for now? My php skills are not sufficient to write something!

After a year I have 55 tables. As a busy running club site it’s just going to go on and on so I am going to end up with a ridiculously long list of tables. This is why I am so keen on newest first!

Hi,

yes, view-list.php would be the file. TablePress does not perform an initial sort as the initial data set is already sorted by the ID when it is read from the database.

A hack would probably have to go into the prepare_items() method, but I’m not yet sure what the best way would be.

Regards,
Tobias

Hi,

ok, I’ve now had the time to take a closer look at this, and think I have found a good way using a plugin filter hook.
One can now use code like

add_filter( 'tablepress_load_class_name', 'tp_change_default_order_in_list' );
function tp_change_default_order_in_list( $class ) {
	if ( 'TablePress_List_View' === $class ) {
		if ( empty( $_GET['orderby'] ) && empty( $_GET['order'] ) ) {
			$_GET['orderby'] = 'id';
			$_GET['order'] = 'desc';
		}
	}
	return $class;
}

to change the default order. This example would sort the table ID column in descending order.

Regards,
Tobias

Joy!! Thank you so much!

Hi,

no problem, you are very welcome! ?? Good to hear that this helped!

Best wishes,
Tobias

P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!