Try this:
Code: Select all
Classical Composer|filter:left(genre,9)='Classical'\<composer>\<artist>\<album>
Code: Select all
Classical Composer|filter:left(genre,9)='Classical'\<composer>\<artist>\<album>
Code: Select all
Test|SQL filter:Songs.SongTitle LIKE '%03 %'|SQL filter:DateDiff('d',Songs.DateAdded,Now)>14\<album>
Code: Select all
Test|SQL filter:Songs.SongTitle LIKE '%03 %' AND DateDiff('d',Songs.DateAdded,Now)>14\<album>
Code: Select all
Test|SQL filter:Songs.SongTitle LIKE '%03 %'
Both your codes works for me and returns correct result! What error do you get?tarasis wrote:I was wondering if its possible to chain SQL filters together. Basically I want to find any track that contains 03 and is older that a particular number of days.
I've tried the following but nothing has worked
Code: Select all
Test|SQL filter:Songs.SongTitle LIKE '%03 %'|SQL filter:DateDiff('d',Songs.DateAdded,Now)>14\<album>
Is there anything else I can try?Code: Select all
Test|SQL filter:Songs.SongTitle LIKE '%03 %' AND DateDiff('d',Songs.DateAdded,Now)>14\<album>
A magic node must end with \<X> where X is a valid field.Also does anyone know why the following fails to work
It needs to explicitly have <album> at the end. Is the value in <> an input to the filter?Code: Select all
Test|SQL filter:Songs.SongTitle LIKE '%03 %'
Anonymous wrote:Bex: Ett stort tack ska du ha! Thank you so much. I only wish this stuff were better documented.
Code: Select all
AddedLastWeek|SQL filter:DateDiff('d',Songs.DateAdded,Now)<7\<date added|sort order:desc>\<folder>
Same here this doesn't work for me with MN 1.3 and MM 2.5.2 beta2MagGyver wrote:Bex, thanks for reply, how do I use the code? I tried pasting exactly as you wrote into a new Magic Node but it said it wasn't a valid mask. Then I tried appending it as so:
Added Last Week\<date added>AddedLastWeek|SQL filter:DateDiff('d',Songs.DateAdded,Now)<7\<date added|sort order:desc>\<folder>
but of course that didn't work. I know I'm probably just missing one character or something. Ideas?
Oops! I've tweaked My Magic Node Script so it contains "folders". Try this instead:MagGyver wrote:Bex, thanks for reply, how do I use the code? I tried pasting exactly as you wrote into a new Magic Node but it said it wasn't a valid mask. Then I tried appending it as so:
Added Last Week\<date added>AddedLastWeek|SQL filter:DateDiff('d',Songs.DateAdded,Now)<7\<date added|sort order:desc>\<folder>
but of course that didn't work. I know I'm probably just missing one character or something. Ideas?
Code: Select all
Added Last Week\<date added>AddedLastWeek|SQL filter:DateDiff('d',Songs.DateAdded,Now)<7\<date added|sort order:desc>