sorting by ...

[Energetik]

$GLOBALS['TL_DCA']['tl_content']['list']['sorting']['mode'] = 2;
$GLOBALS['TL_DCA']['tl_content']['list']['sorting']['fields'] = array('pid');

how get article title by pid ?
and insert it in sorting field

thanks

[Energetik]

$GLOBALS['TL_DCA']['tl_content']['list']['sorting']['fields'] = array('(SELECT title FROM tl_article WHERE tl_article.id=tl.content.pid)');

this not work...

because full query

SELECT * FROM tl_content ORDER BY (SELECT title FROM tl_article WHERE tl_article.id=tl.content.pid) LIMIT 0,150)

[foxservia]

SELECT * FROM table ORDER BY expression ASC

or DESC for descending...

You also forgot one ")"