%<tag>% and Playlist Tree

2007-02-12 02:08:43

I have a large classical collection and have a lot of tracks with multiple artists.  I have set up a query in the Playlist Tree panel using the %<artist>% format so each artist shows up separate.  That works fine but I would like to have an intermediate node that has the first letter of the artist so all of the A artists are in a folder, the B artists in another and so on.  Now I know that the %<tag>% format doesn't play well with sting manipulation functions but I was wondering if any one has any work arounds or tips and tricks.  Even if I had to write a different query for each letter of the alphabet!  Just can figure out how to do it.  Any help would be appreciated.

Thanks,
John

%<tag>% and Playlist Tree

Reply #1 – 2007-02-12 03:23:49

I use this in foo_browser to get the the first letter of the artist tag: $upper($left(%artist%,1))

Hopefully, it will work with Playlist Tree.

%<tag>% and Playlist Tree

Reply #2 – 2007-02-21 02:14:50

That works fine in Playlist tree - grouping all items under the initial letter. Obviously, a letter will not appear unless you have some item(s) starting with it.


In Playlist tree:

Source:
@database

Query:
1

Format:
$upper($left(%artist%,1))|%artist%|%album%|[$num(%tracknumber%,2)]%title%