Sorting order of Sources

by bluesky, Saturday, October 11, 2014, 09:49 (3457 days ago)

On my sources list (the far left window) the ordering is not by alphabetical order, it looks to be split into two sections, each section being in alphabetical order. Is there anyway to force the sources list to be alphabetical order? It makes reading the RSS feeds messy.

Sorting order of Sources

by bluesky, Monday, October 13, 2014, 14:19 (3455 days ago) @ bluesky

Sort of figured it out. In the daos/mysql/Sources.php I changed the following line:
$ret = \F3::get('db')->exec('SELECT id, title, tags, spout, params, error FROM '.\F3::get('db_prefix').'sources ORDER BY error DESC, lower(title) ASC');

to
$ret = \F3::get('db')->exec('SELECT id, title, tags, spout, params, error FROM '.\F3::get('db_prefix').'sources ORDER BY lower(title) ASC');

Don't know why it first sorts by "error" but that was causing the order issue for me.

I'm on 2.10.

RSS Feed of thread
powered by my little forum