Magic Nodes 4.2 w/ 380 masks & real GUI (2011-07-01)[MM2+]

[nynaevelan]

The easiest way would be to create a filter that filters out compilation albums, at least that is the way that I do it.

[rrfpacker]

Do you mean a filter in the MN mask or a MM filter? I'd rather not use an MM filter. I tried to create a filter in MN but the filter section doesn't let me do anything.

I created the modified mask by copy/pasting another one into the mask field at the bottom and changing one character. Is this the problem? Do I need to create the mask from scratch for the filter section to work?

[nynaevelan]

Yeah I was talking about a MM filter, which you can use in the MN mask.

[phuzz]

Hello all..

I apologize ahead of time if that has already been answered elsewhere in this thread.

What I would like to know is if it is possible to generate masks using playcount information for a specific period of time...

for examples if I wanted to query all tracks that have had 5 or more plays in the last 30 days

Any guidance would be greatly appreciated!

[Vyper]

Hello all..

I apologize ahead of time if that has already been answered elsewhere in this thread.

What I would like to know is if it is possible to generate masks using playcount information for a specific period of time...

for examples if I wanted to query all tracks that have had 5 or more plays in the last 30 days

Any guidance would be greatly appreciated!

Wouldn't an autoplaylist do what you want? For example, I created a test playlist with the following parameters and it seems to do exactly what you want:





I may be misunderstanding what 'timestamp' does, though.

[phuzz]

Yeah I don't think that's giving me quite what I am trying to achieve, although I had not thought of using autoplaylists (that certainly would be an option).

It appears what the example you gave above generates a list of tracks with more than 5 plays AND timestamped in the last 30 days. The timestamp value however appears to be a value generated when the file is modified and as such isn't useful for what I am trying to achieve.

To clarify I would like to query tracks played 5 times IN the last 30 days, so a track that was played 20 times but all over a month ago would not be part of the results.

[Weatherman]

Sticking with the autoplaylist format, instead of selecting "Timestamp", select "Last Played" and give it a value of less than 6 days. You should receive a list of songs which have been played more than 5 times within the last 5 days
Jim

[Guest]

Sticking with the autoplaylist format, instead of selecting "Timestamp", select "Last Played" and give it a value of less than 6 days. You should receive a list of songs which have been played more than 5 times within the last 5 days
Jim

I don't think so. With the autoplaylist you could receive a list of songs which have been played more than 5 times anytime, but only the last song played within the last 5 days. For example, you would get a track played 1000 times, but played only once within the last 5 days.

You could try this instead:

Code: Select all

Played at least 5 times within last 30 days|Filter:Songs.ID IN (SELECT Songs.ID FROM Songs LEFT JOIN Played ON Songs.ID = Played.IDSong WHERE CAST(julianday(date('now', 'localtime')) - julianday(date(Played.PlayDate + julianday('1899-12-30'))) AS integer) <= 30 GROUP BY Songs.ID HAVING Count(*) >= 5)\<Title>

[Weatherman]

I think you're right. Sorry for raising hopes...I'm crap at creating these things too....it is really great there are so many pre-made nodes and Reg Exp - thanks to all you people who actually know this stuff.
Jim

[phuzz]

Yes this is exactly what I was looking for. I figured it had to be possible I just wasn't up on my sql queries. Thanks all for you assistance!

[declan]

Hi

I asked this some time ago, but didn't get an answer...

Is there a way to display an artist by "span"? ie the difference between the oldest and newest recording.

The best I can do is -

Code: Select all

Most Years|Show tracks:yes|icon: top level|Child of:Year|Filter:<Year> Between 1870 And 2070\<album artist|Sort by:Count(Year) Desc|Show rank:Yes|Top:100|Show sort key:0|Statistic:Min(Year), Max(Year), Count(Year)>\<Year>

Which shows the artists that I have music from that was recorded in the greatest number of years. But I want to be able to list someone whose career spanned 50 years (even if there are only tracks in 1959 and 2009 and nothing in between) ahead of artists who've I got tracks by from every year between 1960 and 2009.

I reckon there might be a SQL expression that'll do the job, but I'm damned if I can figure it out.

Cheers.

[Guest]

Is there a way to display an artist by "span"?

Not exactly, but you could try:

Code: Select all

Artists with 50 or more years between oldest and newest song|Filter:Songs.Artist IN (SELECT Artist FROM Songs WHERE Year > 19000000 GROUP BY Artist HAVING Max(Year) - Min(Year) >= 500000)\<Artist|Statistic:Min(Year), Max(Year)>\<Year>

Code: Select all

Artists with 40 to 50 years between oldest and newest song|Filter:Songs.Artist IN (SELECT Artist FROM Songs WHERE Year > 19000000 GROUP BY Artist HAVING Max(Year) - Min(Year) Between 400000 And 499999)\<Artist|Statistic:Min(Year), Max(Year)>\<Year>

and so on.

[declan]

Thank you Guest that (or a series of nodes based on that) does the job.

[declan]

Although how do I amend the Sql bit to work on the Album Artist field instead?

[Stasis096]

I just downloaded MagicNodes script and am trying to create my own customized node. I want to create a "AlbumArtist does not equal Composer" node (it would be similar to the "Artist does not equal AlbumArtist" node). Any help would be appreciated.

Thanks