Hi again erland,
I think I've found the code block used by Custom Browse to sort albums
by artist...
Code:
--------------------
<option>
<id>byartist</id>
<name>Sort by artist</name>
<itemformat>albumconcat</itemformat>
<menulinks>number</menulinks>
<menudata>
select albums.id,if(albums.compilation,' ',concat('(',
group_concat(distinct contributors.name) ,')')) from
albums,contributor_album,contributors
where
albums.id=contributor_album.album and
contributor_album.contributor=contributors.id and
contributor_album.role in (1,5)
group by albums.id
order by contributors.namesort asc,albums.year
desc,albums.titlesort asc,albums.disc asc
</menudata>
</option>
--------------------
If I wanted to swap around the order text output is displayed in the
WebUI:
From: Album (Artist)
To: Artist (Album)
Would that be an easy thing to do? If so - how? :)
Thanks
Bob
------------------------------------------------------------------------
bobertuk's Profile: http://forums.slimdevices.com/member.php?userid=30376
View this thread: http://forums.slimdevices.com/showthread.php?t=94975
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/discuss