Ordering by NAME in artist view

Mark
Mark
Offline
0
Hello Germi and fellow Music Collectionists!

The ordering in the artist view is currently set to FORMAT but I'm trying to change it to Album title. I've had a go but so far my efforts have been unsuccessful.

How is this done?

Many thanks for any instructions. :)
Responses (3)
  • Accepted Answer

    Tuesday, February 10 2015, 06:46 PM - #Permalink
    0
    hm.. which version are you using? the ordering isn't format since many time ago..! by default it is the date of the albums...
    The reply is currently minimized Show
  • Accepted Answer

    Mark
    Mark
    Offline
    Tuesday, February 10 2015, 09:17 PM - #Permalink
    0
    Sorry Germi, should of specified the version. Using Joomla 2.5!

    This is the code to refresh your memory..
    function getAlbumsData()
    {

    if (empty( $this->_albums_data )){
    $query = ' SELECT * FROM #__muscol_format '.
    ' WHERE display_group = 0'.
    ' ORDER BY order_num ';
    $this->_db->setQuery( $query );
    $this->_albums_data = $this->_db->loadObjectList();

    $types_array = $this->getTypesArray();

    for($i=0;$i < count($this->_albums_data); $i++){
    $format_id = $this->_albums_data[$i]->id;
    $query = ' SELECT f.*,al.*,ar.artist_name,ar.letter,ge.genre_name '.
    ' FROM #__muscol_albums as al '.
    ' LEFT JOIN #__muscol_artists as ar ON ar.id = al.artist_id '.
    ' LEFT JOIN #__muscol_format as f ON f.id = al.format_id '.
    ' LEFT JOIN #__muscol_genres as ge ON ge.id = al.genre_id '.
    ' WHERE artist_id = '.$this->_id.
    ' AND (format_id = '.$format_id.' OR display_group = '.$format_id.')'.
    ' AND (part_of_set = 0 OR ( part_of_set != 0 AND show_separately = "Y" ) ) ' .
    ' ORDER BY name ';
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, February 11 2015, 11:07 AM - #Permalink
    0
    No, i meant Music Collection version...
    in any case, what you did is already ok, but the albums are always grouped by FORMAT. notice there are two querys. to change that you would actually need to change this structure whole.
    The reply is currently minimized Show
Your Reply