Sort the KB Javascript menus alphabetically

[Matthew]

In the Staff CP, I want to alphabetize the articles in the Knowledgebase 'Quick Jump' and 'Quick Insert' javascript menus. (I've already got the categories and sub-categories alphabetized.)

I believe the key is in function buildKBArticleData() from functions_knowledgebase.php.

First, there is this line, which does not seem to affect the sort of the menu:

PHP Code:

    $dbCore->query("SELECT * FROM `". TABLE_PREFIX ."kbarticles` AS kbarticles LEFT JOIN `". TABLE_PREFIX ."kbarticledata` AS kbarticledata ON (kbarticles.kbarticleid = kbarticledata.kbarticleid) ORDER BY kbarticles.kbarticleid ASC;"); 


Then there is this one, which I suspect is where the issue lies; however, I don't understand how to contruct the query that would create the correct sort order:

PHP Code:

    $dbCore->query("SELECT * FROM `". TABLE_PREFIX ."kbarticlelinks` ORDER BY `kbarticlelinkid` ASC;", 2); 


Anyone willing to help? Surely others would like to see the KB list in alphabetical order...

[Jamie Edwards]

I have not tested this, but I have modified the query so that it joins the two tables kbarticlelinks and kbarticles together, ordering the two by the respective article subject (ascending - a to z). The SQL works, I am not sure if it will in place of the existing code.

SQL:

SELECT * FROM swkbarticlelinks, swkbarticles WHERE swkbarticlelinks.kbarticleid = swkbarticles.kbarticleid ORDER BY swkbarticles.subject ASC;

PHP:

PHP Code:

$dbCore->query("SELECT * FROM `". TABLE_PREFIX ."kbarticlelinks`, `". TABLE_PREFIX ."kbarticles` WHERE `". TABLE_PREFIX ."kbarticlelinks.kbarticleid` = `". TABLE_PREFIX ."kbarticles.kbarticleid` ORDER BY `". TABLE_PREFIX ."kbarticles.subject` ASC;", 2); 


[Matthew]

Originally Posted by Jamie Edwards

I have not tested this, but I have modified the query so that it joins the two tables kbarticlelinks and kbarticles together, ordering the two by the respective article subject (ascending - a to z). The SQL works, I am not sure if it will in place of the existing code.

Great Jamie! That was just enough to get me started. This is actually the code that does the trick...

PHP Code:

    $dbCore->query("SELECT * FROM `". TABLE_PREFIX ."kbarticlelinks`, `". TABLE_PREFIX ."kbarticles` WHERE (". TABLE_PREFIX ."kbarticlelinks.kbarticleid = ". TABLE_PREFIX ."kbarticles.kbarticleid) ORDER BY ". TABLE_PREFIX ."kbarticles.subject ASC;", 2);