Thanks for your support erland. This is the xml(generated from the template "custom tag" with just the tagname inserted):
Code:
--------------------
<?xml version="1.0" encoding="utf-8"?>
<custombrowse>
<menu>
<menuname>MyArtists</menuname>
<menuorder>50</menuorder>
<menu>
<id>customtag</id>
<menuname>Artists</menuname>
<pathtype>sql</pathtype>
<pathtypedata>
select distinct
customscan_track_attributes.value,customscan_track_attributes.value from
customscan_track_attributes
where
module='customtag' and
attr='ARTISTSORT' and
value='{context.itemid}'
</pathtypedata>
<customitemtype>customtagARTISTSORT</customitemtype>
<menutype>sql</menutype>
<menulinks>alpha</menulinks>
<menudata>
select
customscan_track_attributes.value,customscan_track_attributes.value,
substr(ifnull(customscan_track_attributes.valuesort,customscan_track_attributes.value),1,1)
from customscan_track_attributes
where
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='ARTISTSORT'
group by customscan_track_attributes.value
order by
ifnull(customscan_track_attributes.valuesort,customscan_track_attributes.value)
asc
</menudata>
<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>
<option>
<id>byyear</id>
<name>Sort by year</name>
<keyword name="orderby"
value="albums.year desc,albums.titlesort asc,albums.disc asc"/>
<menulinks>number</menulinks>
</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 albums,tracks,customscan_track_attributes
where
albums.compilation = 1
and
tracks.album=albums.id
and
tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='ARTISTSORT' and
customscan_track_attributes.value='{customtag}'
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,customscan_track_attributes
where
tracks.audio=1
and
tracks.album={album} and
tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='ARTISTSORT' and
customscan_track_attributes.value='{customtag}'
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(contributors.namesort,1,1) from
contributors,tracks,contributor_track,customscan_track_attributes,albums
where
tracks.audio=1 and
tracks.id=contributor_track.track and
contributor_track.contributor=contributors.id and
contributor_track.role in (1,5)
and
tracks.album=albums.id and
(
albums.compilation is
null or
albums.compilation=0 or
{property:server:variousArtistAutoIdentification}=0
) and
tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='ARTISTSORT' and
customscan_track_attributes.value='{customtag}'
group by contributors.id
order by contributors.namesort asc
</menudata>
<menu>
<id>album</id>
<menuname>Songs</menuname>
<itemtype>album</itemtype>
<itemformat>album</itemformat>
<menutype>sql</menutype>
<option>
<id>byyear</id>
<name>Sort by year</name>
<menulinks>number</menulinks>
<keyword name="orderby"
value="albums.year desc,albums.titlesort asc,albums.disc asc"/>
</option>
<option>
<id>bytitle</id>
<name>Sort by title</name>
<menulinks>alpha</menulinks>
<keyword name="orderby"
value="albums.titlesort asc,albums.disc asc"/>
</option>
<jivepattern>^(.*)\s\((.*)\)$</jivepattern>
<menudata>
select
albums.id,albums.title,substr(albums.titlesort,1,1) from
tracks,contributor_track,albums,customscan_track_attributes
where
tracks.audio=1 and
albums.id=tracks.album
and
tracks.id=contributor_track.track and
contributor_track.role
in (1,5) and
contributor_track.contributor={artist} and
tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='ARTISTSORT' and
customscan_track_attributes.value='{customtag}'
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,albums,customscan_track_attributes
where
tracks.audio=1
and
contributor_track.track=tracks.id and
tracks.album={album} and
contributor_track.role in (1,5) and
contributor_track.contributor={artist} and
tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='ARTISTSORT' and
customscan_track_attributes.value='{customtag}'
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>
</menu>
</menu>
</custombrowse>
--------------------
If there is a way to get my artists from tag "ARTISTSORT" in the form
"Cocker, Joe" without using custom browse/scan i would be happy to go
without ;-) Using the custom tag template seemed pretty easy but
somehow doesn't work for me as expected. Could this problem be related
to both engines(standard,custom scan) scanning the tag ARTISTSORT?
Regards,
Frank
--
frank_harmann
------------------------------------------------------------------------
frank_harmann's Profile: http://forums.slimdevices.com/member.php?userid=38507
View this thread: http://forums.slimdevices.com/showthread.php?t=94005
_______________________________________________
plugins mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/plugins
