> I don't think there is a template at the moment that does this. The
>"Custom Artist Tags" is the closest one, it also sounds like that is
>the one you are using. I think it does the correct thing, but you'll
>have to remove the middle levels for customtag(ORIGARTIST) and album. I
>can add it to the wish list for a future release.
Okay, I got this working quite easily in the end by doing as you suggested;
creating a menu based on Custom Artist Tags, and then removing the middle two
menus. I had to tweak the where clause so that the bottom-level menu filtered
on the selected artist and not by album and custom tag value.
The sql text field puts blank lines between each line each time I re-edit the
custom sql, and the text field control is a little large, so navigating through
the sql is a bit awkward. In the end I copied it out to another editor,
removed blank lines, and pasted it back in to save it.
If it helps for when you look at producing a template, here is the final custom
menu configuration I came up with:
<?xml version="1.0" encoding="utf-8"?>
<custombrowse>
<menu>
<menugroup>Covers</menugroup>
<menuname>Songs By Covering Artist</menuname>
<menuorder>50</menuorder>
<menu>
<id>artist</id>
<menuname>Original Artist</menuname>
<itemtype>artist</itemtype>
<menutype>sql</menutype>
<menulinks>alpha</menulinks>
<menudata>
select
contributors.id,contributors.name,substr(contributors.namesort,1,1) from
contributors,tracks,contributor_track,customscan_track_attributes
where
tracks.audio=1 and
tracks.id=contributor_track.track and
contributor_track.contributor=contributors.id and
contributor_track.role in (1,4,5,6) and
tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='ORIGARTIST'
group by contributors.id
order by contributors.namesort asc
</menudata>
<menu>
<id>track</id>
<itemtype>track</itemtype>
<itemformat>track</itemformat>
<menutype>sql</menutype>
<menudata>
select tracks.id,tracks.title from
tracks,contributor_track,albums,customscan_track_attributes
where
tracks.audio=1 and
contributor_track.track=tracks.id and
contributor_track.role in
(1,4,5,6) and
tracks.id=customscan_track_attributes.track and
contributor_track.contributor={artist} and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='ORIGARTIST'
group by tracks.id
order by tracks.disc
asc,tracks.tracknum asc,tracks.titlesort asc
</menudata>
<menu>
<id>trackdetails</id>
<menutype>trackdetails</menutype>
<menudata>track|0</menudata>
</menu>
</menu>
</menu>
</menu>
</custombrowse>
Obviously making the menu from a proper template would be nicer, as I can then
re-tweak the artist roles and other details without having to work out the
required config format.
Thanks for your help, and a wonderful plugin!
Phil
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/lists/listinfo/plugins
