Page 8 of 170
Posted: Tue Sep 04, 2007 3:43 pm
by ZvezdanD
nojac wrote:I had a MagicNode for incomplete albums (Originally from Teknojnky, I think):
Incomplete Albums|SQL filter: Songs.IDAlbum IN (SELECT IDAlbum FROM Songs GROUP BY IDAlbum HAVING Count(SongOrder) <> (Max(SongOrder+1)) AND Count(SongOrder) > 1)|show tracks:yes\<Album Artist>\<Album|statistic:count(all)>
It is not working any more in MM3 B1. ("no such column: SONGORDER(1)") Any suggestion for an alternative?
Hmm... It is working for me in beta 1. When I look database in SQLite Spy, there is SongOrder column as well as TrackNumber which mentioned Bex. Difference is in +1 value.
How did you got the database? Did you deleted previous one and created new from the ground, or did you just let program to convert old one during installation?
EDIT: I see now that also there are DiscNo and DiscNumber. Strange.
Posted: Tue Sep 04, 2007 3:51 pm
by Bex
I don't have any songorder field?
Posted: Tue Sep 04, 2007 3:54 pm
by ZvezdanD
How did you got the database?
Posted: Tue Sep 04, 2007 4:00 pm
by Bex
Renamed the old one so it's a new fresh one! I guess thats the bets way with all these alphas. Oh, and it's converted from MM2 but I don't think that matters.
Posted: Tue Sep 04, 2007 4:08 pm
by ZvezdanD
Well, I think it is a catch. In my case program converted old one (MM3A7) during installation.
Posted: Tue Sep 04, 2007 4:16 pm
by Bex
Actually, I remember now that SQLite can't delete columns. It can only add them to a table. So I guess that's why since you upgraded from a previous version.
Posted: Thu Sep 06, 2007 6:55 pm
by danhackley
Can't quite get this code right, maybe somebody can help :
Album Artist|child of:Artist\<album artist|statistic:count(all)>\<album|sort by:max(year)|sort order:asc|statistic:count(all)>
This code lists album artists alphabetically, with the number of tracks for each artist in brackets next to it. Expanding an artist lists the albums in increasing date (2001,2002, etc).
I want the number of albums rather than the number of tracks for each artist in brackets. Also, I would like artists to be grouped by letters (e.g. A-Z). Can anyone help ?
Posted: Thu Sep 06, 2007 7:08 pm
by ZvezdanD
danhackley wrote:I want the number of albums rather than the number of tracks for each artist in brackets.
Currently, this is not possible.
danhackley wrote:Also, I would like artists to be grouped by letters (e.g. A-Z).
Like this:
Code: Select all
Album Artist|child of:Artist\<album artist|trim:1>\<album artist|statistic:count(all)>\<album|sort by:max(year)|sort order:asc|statistic:count(all)>
Posted: Sat Sep 08, 2007 5:07 am
by danhackley
Thanks, I will try that.
However, just now my Mediamonkey is on hold, as last time I started up I got a "disk read error Press Ctrl + Alt + Del to restart" and I cannot boot my computer up.
As soon as/if I get it fixed, I will try your code, thanks.
Posted: Sun Sep 09, 2007 9:38 am
by danhackley
Can somebody help with code for the following - I can't seem to get it right !
I want a genre node to open into <genre> with <number of items>. when i open a genre, I want it to list all albums of that genre, in order of album artist.
Any help appreciated !!
Posted: Sun Sep 09, 2007 5:41 pm
by ZvezdanD
I am not sure that I understand what you want. You could try this:
Code: Select all
Genre by Album artist\<genre|statistic:count(all)>\<album and year>
Posted: Sun Sep 09, 2007 6:11 pm
by Guest
That is almost what I want, thanks !
I would like also the albums with the same album artist to be grouped together (so instead of listing e.g. pink floyd six times, I would like it to list pink floyd once, with the option of expanding that part of the tree by clicking on +).
e.g.
Genre
- Rock
- Pink Floyd (no. of tracks [or if possible, albums])
- Dark Side Of The Moon
- The Wall
- Wish You Were Here, etc
Posted: Sun Sep 09, 2007 6:18 pm
by danhackley
Sorry forgot to log in for above.
Ideally my tree structure for genre would be (e.g.):
Genre (no. of tracks/albums)
- Rock (no. of tracks/albums)
- Pink Floyd (no. of tracks [or if possible, albums])
- Dark Side Of The Moon
- The Wall
- Wish You Were Here, etc
Posted: Sun Sep 09, 2007 6:52 pm
by ZvezdanD
This is not possible. You could get only this:
Code: Select all
Root
+- Rock (no. of tracks)
+- Pink Floyd (no. of tracks)
+- Dark Side Of The Moon
+- The Wall
+- Wish You Were Here
With this:
Code: Select all
Genre, Album artist, Album\<genre|statistic:count(all)>\<album artist|statistic:count(all)>\<album>
Posted: Sun Sep 09, 2007 8:16 pm
by Big_Berny
Hi ZcezdanD,
a little question: It's possible to create a node where all songs must have a rating which is divideable by 10? So 10, 20, 30, 40 and so on?
Regards
Big_Berny