erland;659459 Wrote:
> It's the group_concat function that doesn't exist in SQLite.
>
> I'm guessing this is a menu where you have customized the SQL yourself
> ?
You must have helped me with the SQL. The main advantage with that menu
is that it shows the albums in the order they were originally added to
SBS. The standard CB New Albums menu and the SBS New Music menu show
albums added a long time ago but which contain one or more tracks with
new or changed tags.
Also this menu is broken:
Code:
--------------------
<?xml version="1.0" encoding="utf-8"?>
<custombrowse>
<menu>
<menuname>Låtens år</menuname>
<menuorder>45</menuorder>
<menu>
<id>customtag</id>
<menuname>Albums</menuname>
<pathtype>sql</pathtype>
<pathtypedata>
select distinct
customscan_track_attributes.value,customscan_track_attributes.value from
customscan_track_attributes
where
module='customtag' and
attr='TRACKYEAR' and
value='{context.itemid}'
</pathtypedata>
<customitemtype>customtagTRACKYEAR</customitemtype>
<menutype>sql</menutype>
<menulinks>number</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='TRACKYEAR'
group by customscan_track_attributes.value
order by
ifnull(customscan_track_attributes.valuesort,customscan_track_attributes.value)
asc
</menudata>
<menu>
<id>album</id>
<menuname>Songs</menuname>
<itemtype>album</itemtype>
<itemformat>albumconcat</itemformat>
<menutype>sql</menutype>
<option>
<id>bytitle</id>
<name>Sort by title</name>
<menulinks>alpha</menulinks>
<keyword name="orderby"
value="albums.titlesort asc,albums.disc asc"/>
</option>
<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>
<jivepattern>^(.*)\s\((.*)\)$</jivepattern>
<menudata>
select albums.id,concat('(',
group_concat(distinct contributors.name separator ',')
,')'),substr(albums.titlesort,1,1) from
tracks,albums,contributor_track,contributors,customscan_track_attributes
where
tracks.audio=1 and
albums.id=tracks.album and
tracks.id=contributor_track.track and
contributor_track.contributor=contributors.id and
contributor_track.role in (1,5)
and
tracks.id=customscan_track_attributes.track and
customscan_track_attributes.module='customtag' and
customscan_track_attributes.attr='TRACKYEAR' 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,albums,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='TRACKYEAR' 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>
</custombrowse>
--------------------
You helped me with that one as well and it also uses group_concat.
Maybe your fix can be applied to that menu as well?
Thank you for your assistance.
--
vagskal
2 x SB3 (wired), Receiver (wired), Boom (wireless), Controller, iPeng on
iPhone 4 & iPad, muso on remote computer running Win 7 64-bit | 7.6.2
(r33496) on Win XP
------------------------------------------------------------------------
vagskal's Profile: http://forums.slimdevices.com/member.php?userid=20778
View this thread: http://forums.slimdevices.com/showthread.php?t=49483
_______________________________________________
plugins mailing list
plugins@lists.slimdevices.com
http://lists.slimdevices.com/mailman/listinfo/plugins
