Hey,
to browse my classical music, i use CustomBrowse (CB) with the menu at
the end of this mailing. It works fine, but I want to sort the list of
composers by their lastname. E.g., Ludwig van Beethoven should appear
under "B", but displayed as written before. My Music files have a) a
field named COMPOSER (e.g. Ludwig van Beethoven) and b) a field named
COMPOSERSORT (e.g. Beethoven, Ludwig van).
What should be modified in the menu below to sort the composers by
lastname?
Thanks for all tipps!
------- Menu ------
<?xml version="1.0" encoding="utf-8"?>
<custombrowse>
<menu>
<menuname>Klassik nach Komponist</menuname>
<menu>
<id>variousartist</id>
<menuname>Various Artists</menuname>
<menutype>sql</menutype>
<menudata>
select contributors.id,contributors.name from contributors
where
contributors.name='Various Artists' and
{property:server:variousArtistAutoIdentification}= 1
group by contributors.id
</menudata>
<menu>
<id>album</id>
<menuname>Songs</menuname>
<itemtype>album</itemtype>
<itemformat>album</itemformat>
<menutype>sql</menutype><defaultoption>bytitle</defaultoption>
<option>
<id>byyear</id>
<name>Sort by year</name>
<menulinks>number</menulinks>
<itemformat>albumconcat</itemformat>
<menudata>
select albums.id,if(albums.year=0,' ',concat('(',albums.year,')')) from
tracks,albums,genre_track,genres
where
tracks.audio=1 and
tracks.album=albums.id and
albums.compilation = 1
and tracks.id=genre_track.track and
genre_track.genre=genres.id and
genres.name in ('Choral','Chorus','Classical','Classique','Klassi
k','Klassisch','Opera','Orchestral','Organ','Symph onic')
group by albums.id
order by albums.year desc,albums.titlesort asc,albums.disc asc
</menudata>
</option>
<option>
<id>bytitle</id>
<name>Sort by title</name>
<menulinks>alpha</menulinks>
<keyword name="orderby" value="albums.titlesort asc,albums.disc asc"/>
</option>
<menudata>
select albums.id,albums.title from tracks,albums,genre_track,genres
where
tracks.audio=1 and
tracks.album=albums.id and
albums.compilation = 1
and tracks.id=genre_track.track and
genre_track.genre=genres.id and
genres.name in ('Choral','Chorus','Classical','Classique','Klassi
k','Klassisch','Opera','Orchestral','Organ','Symph onic')
group by albums.id
order by {orderby}
</menudata>
<menu>
<id>track</id>
<itemtype>track</itemtype>
<itemformat>track</itemformat>
<playtype>all</playtype>
<menutype>sql</menutype>
<menudata>
select tracks.id,tracks.title from tracks,albums,genre_track,genres
where
tracks.audio=1 and
tracks.album={album}
and tracks.id=genre_track.track and
genre_track.genre=genres.id and
genres.name in ('Choral','Chorus','Classical','Classique','Klassi
k','Klassisch','Opera','Orchestral','Organ','Symph onic')
group by tracks.id
order by tracks.disc,tracks.tracknum asc,tracks.titlesort asc
</menudata>
<menu>
<id>trackdetails</id>
<menutype>trackdetails</menutype>
<menudata>track|0</menudata>
</menu>
</menu>
</menu>
</menu>
<menu>
<id>artist</id>
<menuname>Albums</menuname>
<itemtype>artist</itemtype>
<menutype>sql</menutype>
<menulinks>alpha</menulinks>
<menudata>
select contributors.id,contributors.name,substr(contribut
ors.namesort,1,1) from
tracks,contributor_track,contributors,albums,genre _track,genres
where
tracks.id=contributor_track.track and
contributor_track.contributor=contributors.id and
contributor_track.role in (2)
and tracks.album=albums.id and
(
albums.compilation is null or
albums.compilation=0 or
{property:server:variousArtistAutoIdentification}= 0
)
and tracks.id=genre_track.track and
genre_track.genre=genres.id and
genres.name in ('Choral','Chorus','Classical','Classique','Klassi
k','Klassisch','Opera','Orchestral','Organ','Symph onic')
group by contributors.id
order by contributors.namesort
</menudata>
<menu>
<id>album</id>
<menuname>Songs</menuname>
<itemtype>album</itemtype>
<itemformat>album</itemformat>
<menutype>sql</menutype><defaultoption>bytitle</defaultoption>
<option>
<id>byyear</id>
<name>Sort by year</name>
<itemformat>albumconcat</itemformat>
<menulinks>number</menulinks>
<menudata>
select albums.id,if(albums.year=0,'
',concat('(',albums.year,')')),substr(albums.title sort,1,1) from
tracks,albums,contributor_track,genre_track,genres
where
tracks.id=contributor_track.track and
contributor_track.role in (2) and
contributor_track.contributor={artist}
and tracks.id=genre_track.track and
genre_track.genre=genres.id and
genres.name in ('Choral','Chorus','Classical','Classique','Klassi
k','Klassisch','Opera','Orchestral','Organ','Symph onic')
and albums.id=tracks.album
group by albums.id
order by albums.year desc,albums.titlesort asc
</menudata>
</option>
<option>
<id>bytitle</id>
<name>Sort by title</name>
<menulinks>alpha</menulinks>
<keyword name="orderby" value="albums.titlesort asc"/>
</option>
<jivepattern>^(.*)\s\((.*)\)$</jivepattern>
<menudata>
select albums.id,albums.title,substr(albums.titlesort,1,1 ) from
tracks,albums,contributor_track,genre_track,genres
where
tracks.id=contributor_track.track and
contributor_track.role in (2) and
contributor_track.contributor={artist}
and tracks.id=genre_track.track and
genre_track.genre=genres.id and
genres.name in ('Choral','Chorus','Classical','Classique','Klassi
k','Klassisch','Opera','Orchestral','Organ','Symph onic')
and albums.id=tracks.album
group by albums.id
order by {orderby}
</menudata>
<menu>
<id>track</id>
<itemtype>track</itemtype>
<itemformat>track</itemformat>
<playtype>all</playtype>
<menutype>sql</menutype>
<menudata>
select tracks.id,tracks.title from
tracks,contributor_track,genre_track,genres
where
tracks.id=contributor_track.track and
contributor_track.role in (2) and
contributor_track.contributor={artist}
and tracks.id=genre_track.track and
genre_track.genre=genres.id and
genres.name in ('Choral','Chorus','Classical','Classique','Klassi
k','Klassisch','Opera','Orchestral','Organ','Symph onic')
and tracks.album={album}
group by tracks.id
order by tracks.disc,tracks.tracknum asc, tracks.titlesort asc
</menudata>
<menu>
<id>trackdetails</id>
<menutype>trackdetails</menutype>
<menudata>track|0</menudata>
</menu>
</menu>
</menu>
</menu>
</menu>
</custombrowse>
--
McKinley
Synology DS209+ (DSM 2.3-1157 & Squeezebox Server Package 7.5), Duet
------------------------------------------------------------------------
McKinley's Profile: http://forums.slimdevices.com/member.php?userid=36970
View this thread: http://forums.slimdevices.com/showthread.php?t=81915
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
