Music Views. Year + Album? (1 Viewer)

[NorthernJohn]

I'm trying to get a view in My Music but don't know how. I'm sure it's possible so hopefully somebody can help me.

Top Level - Artist
Second Level - Album + Year (sorted by year if poss)
Third Level - Track

It's almost the same as the Artist view that is there now, with the added element of Year in the Album level. As an educated guess, I've tried using concatenation of year + ' ' + album and year & ' ' & album in the Selection column but I guess the entries in the grid are parsed before hitting the database as I get nothing apart from the back icon when testing it.

Is what I'm trying to do achievable?

Thanks
John

 

[CHli]

I hope it is because atm I'm using the artist view but I always wanted to have the album's year included in the sort So let's wait for an answer

 

[hwahrmann]

Sorry guys. not supported atm.

i won't do much work in that, since after finishing some BASS related issues, i want to do a new DB design and put the music db on sqlserver 2005, like the new TV Engine does.
then we will have much more flexible ways for selection and sorting.
but it'll takle some time before the new db design will appear.

 

[zombiepig]

hey hwahrmann - if the music db is moving to sql server, is there plans for the db to be shared across a network?

 

[NorthernJohn]

Sorry guys. not supported atm.

i won't do much work in that, since after finishing some BASS related issues, i want to do a new DB design and put the music db on sqlserver 2005, like the new TV Engine does.
then we will have much more flexible ways for selection and sorting.
but it'll takle some time before the new db design will appear.

Thanks for the speedy response. I'll stop banging my head against the wall now and wait patiently for the new engine. Well... I'll wait, but maybe not patiently

 

[hwahrmann]

hey hwahrmann - if the music db is moving to sql server, is there plans for the db to be shared across a network?

Sure, if the underlying db server supports it, and SQLServer 2005 does.
You could have a db server and access it from various MP clients accross the network.

 

[ronilse]

Hi, NorthernJohn

You could do as me & make folders on hd after "Artist" (top folder) & "year + album" & use the "shares view". Then you have the view you want

Regards
Roy

 

[mzemina]

hwahrmann - Great news about your working on new db and multiclient access! The music will really rock!