Sorting order of Sources

by bluesky, Monday, October 13, 2014, 14:19 (3480 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.


Complete thread:

 RSS Feed of thread

powered by my little forum