Hello
When adding article tags are ordered by time. How to make it alphabetically?

Thanks in....

Tomasz

Suggest changing the com_k2/models/item.php file around line 690 for v2.2.

Add an Order By clause to the SQL in the getItemTags function...

$query="SELECT * FROM #__k2_tags as tags WHERE tags.published=1 AND tags.id IN (SELECT tagID FROM #__k2_tags_xref WHERE itemID={$itemID}) order by `name`";

Also...

John Wicks said:Suggest changing the com_k2/models/item.php file around line 690 for v2.2.Add an Order By clause to the SQL in the getItemTags function...$query="SELECT * FROM #__k2_tags as tags WHERE tags.published=1 AND tags.id IN (SELECT tagID FROM #__k2_tags_xref WHERE itemID={$itemID}) order by `name`";


In the models/index.php change the following code...
function getAvailableTags($itemID = NULL) {

$db = &JFactory::getDBO();
$query = "SELECT * FROM #__k2_tags as tags";
if (!is_null($itemID))
$query .= " WHERE tags.id NOT IN (SELECT tagID FROM #__k2_tags_xref WHERE itemID={$itemID})";
$query .= " ORDER BY `name`";
$db->setQuery($query);
$rows = $db->loadObjectList();
return $rows;
}

function getCurrentTags($itemID) {

$db = &JFactory::getDBO();
$query = "SELECT * FROM #__k2_tags as tags WHERE tags.id IN (SELECT tagID FROM #__k2_tags_xref WHERE itemID={$itemID}) ORDER BY `name`";
$db->setQuery($query);
$rows = $db->loadObjectList();
return $rows;
}

Jw

Thanks to all.

Tomasz