Interspire Product Knowledge Base

This applies to ArticleLive NX 1.7 only

When viewing a category, the list of articles by default is sorted by Sort Order, than Date, then Article ID. If you would like to change this, it will be a small MySQL query change to edit those sorting options.

Open the /includes/display/ViewCategoryPanel.php file using FTP and find the GetArticles() function. There is a line beginning with $query in that function and this content:

order by %sarticles.SortOrder ASC, StartDate DESC, %sarticles.ArticleID DESC LIMIT %d, %d
And replace it with something like:

order by %sarticles.Title ASC, StartDate DESC, %sarticles.ArticleID DESC LIMIT %d, %d