[t029248]

i’m still “playing”, struggling with the smart playlists, i’m still getting errors and no “advanced” smart playlists at all.
i gave the xbox a cold start and tried this combination
i have a xps like:
<smartplaylist>
<name>populair 1900s</name>
<match>one</match>
<rule field="playlist" operator="in">pop</rule>
<rule field="playlist" operator="in">rock</rule>
<rule field="year" operator="greaterthan">1979</rule>
<rule field="year" operator="lessthan">2000</rule>
</smartplaylist>

calling
(they work individual)
<smartplaylist>
<name>rock</name>
<match>all</match>
<rule field="genre" operator="contains">rock</rule>
</smartplaylist>

<smartplaylist>
<name>pop</name>
<match>all</match>
<rule field="genre" operator="contains">pop</rule>
</smartplaylist>

27-03-2006 17:50:09 warning cutil::getmatchingshare... no matching bookmark found for [q:\albums\playlists\music]
27-03-2006 17:50:17 warning cutil::getmatchingshare... no matching bookmark found for [q:\albums\playlists\music\populair 1900s.xsp]
27-03-2006 17:50:21 error sqlite: some kind of disk i/o error occurred
query: select * from songview where (stralbum like 'pop') or (stralbum like '(null)oftpop') or (stralbum like 'rock') or (iyear > '1979') or (iyear < '2000') order by random()
27-03-2006 17:50:21 error cmusicdatabase::getsongsbywhere(where (stralbum like '%pop%') or (stralbum like '%softpop%') or (stralbum like '%rock%') or (iyear > '1979') or (iyear < '2000') order by random()) failed
27-03-2006 17:50:21 error cguimediawindow::getdirectory(q:\albums\playlists\music\populair 1900s.xsp) failed
27-03-2006 17:50:21 warning cutil::getmatchingshare... no matching bookmark found for [q:\albums\playlists\music]
27-03-2006 17:50:27 warning cutil::getmatchingshare... no matching bookmark found for [q:\albums\playlists\music\pop.xsp]
27-03-2006 17:50:31 warning cutil::getmatchingshare... no matching bookmark found for [q:\albums\playlists\music]
27-03-2006 17:50:35 warning cutil::getmatchingshare... no matching bookmark found for [q:\albums\playlists\music\rock.xsp]

it’s strange but nothing happends, i tried to keep them as simple as possible. i also don’t get why the query does (stralbum like '%softpop%') and order by random()) since those parameters are not in none of the lists? could they be cached somewhere.

by the way what happened if i twice lets say (or a part)
<rule field="playcount" operator="lessthan">4</rule>
<order>random</order>
<limit>250</limit>

once in a “parent list populair 1900s and in the xps list it’s calling…??

perhaps somebody could provide me with some examples of smart playlists, or place them in the xbmc manual
http://manual.xboxmediacenter.de/wakka.p...ists&v=tep

[kraqh3d]

27-03-2006 17:50:21 error sqlite: some kind of disk i/o error occurred
query: select * from songview where (stralbum like 'pop') or (stralbum like '(null)oftpop') or (stralbum like 'rock') or (iyear > '1979') or (iyear < '2000') order by random()
27-03-2006 17:50:21 error cmusicdatabase::getsongsbywhere(where (stralbum like '%pop%') or (stralbum like '%softpop%') or (stralbum like '%rock%') or (iyear > '1979') or (iyear < '2000') order by random()) failed

it looks like the %'s are getting munged.

[jmarshall]

t029248:

the field="playlist" is not implemented. if it's not in the online manual, you can't do it. it was merely a suggestion of how to get around the issue for the future.

as to why it chooses album, that's the default field.

for more complex queries you are just gonna have to wait until i or someone else (you perhaps?) has some time to implement them.

cheers,
jonathan

[t029248]

t029248:

the field="playlist" is not implemented. if it's not in the online manual, you can't do it. it was merely a suggestion of how to get around the issue for the future.

as to why it chooses album, that's the default field.

for more complex queries you are just gonna have to wait until i or someone else (you perhaps?) has some time to implement them.

cheers,
jonathan

i didn’t know it was not there yet. i wish i could implement it myself, but i can’t. when it’s there i could update the manual / wiki adding some nice examples of smart playlists.

[jmarshall]

and now notinthelast should be functioning as you expect it to.

enjoy.

[kraqh3d]

t029248:

i'm just curious what you were intending with this smart playlist.

<smartplaylist>
<name>populair 1900s</name>
<match>one</match>
<rule field="playlist" operator="in">pop</rule>
<rule field="playlist" operator="in">rock</rule>
<rule field="year" operator="greaterthan">1979</rule>
<rule field="year" operator="lessthan">2000</rule>
</smartplaylist>

since its "match one", if it worked, it would've gotten all songs from the pop playlist, all songs from the rock playlist, all songs after 1979, and all songs before 2000. is that what you wanted?

[t029248]

t029248:

i'm just curious what you were intending with this smart playlist.  

<smartplaylist>
  <name>populair 1900s</name>
  <match>one</match>
  <rule field="playlist" operator="in">pop</rule>
  <rule field="playlist" operator="in">rock</rule>
  <rule field="year" operator="greaterthan">1979</rule>
  <rule field="year" operator="lessthan">2000</rule>
</smartplaylist>

since its "match one", if it worked, it would've gotten all songs from the pop playlist, all songs from the rock playlist, all songs after 1979, and all songs before 2000.  is that what you wanted?

i wanted it to be <match>all</match> but since it was not working i tried to make the possible result for the query bigger.

so i wanted pop and rock from the period 1979 -- 2000

[kraqh3d]

oh ok. gotcha... you were really just trying to test nested queries.

[jmarshall]

just a quick update:

playlists now list using their <name> tag.

please let me know:

1. how fast it is with lots of playlists (100 or so)

2. whether you like this, or whether it's better to just use filename.

cheers,
jonathan

[incognegro]

<smartplaylist>
<name>top 20 rock songs</name>
<match>all</match>
<rule field="playcount" operator="greaterthan">0</rule>
<rule field="genre" operator="is">rock</rule>
<rule field="genre" operator="is">metal</rule>
<rule field="genre" operator="is">alternative</rule>
<rule field="genre" operator="is">alt. rock</rule>
<order direction="descending">playcount</order>
<limit>25</limit>
</smartplaylist>

so thats my playlist but i need some help trying to get it to look for songs that match the playcount and any one of those genres. i dont even think its possible but maybe im wrong...... :help:

[jmarshall]

well, for that one, why bother with the playcount > 0.

the only time that would be used is if you have less than 20 rock songs that have been played before.

remove that line, then change to match one.

the combining of playlists just hasn't been implemented yet, so you cannot combine or with and as yet.

if and when it is implemented, it'll be posted here. until then, you'll just have to make do.

cheers,
jonathan

[jmarshall]

you'll be happy to know that field="playlist" is now working in my local cvs sources.

once cvs is back up and running i'll get it added.

cheers,
jonathan

[t029248]

you'll be happy to know that field="playlist" is now working in my local cvs sources.

once cvs is back up and running i'll get it added.

cheers,
jonathan

that's great, i'm already compiling and i'm going to try this when i get home.

one stupid question does the order of the rules matter, does something like below work....??

<smartplaylist>
    <limit>25</limit>
<name>top 20 rock songs</name>
 
  <rule field="playcount" operator="greaterthan">0</rule>
  <order direction="descending">playcount</order>
  <rule field="genre" operator="is">rock</rule>
  <rule field="genre" operator="is">metal</rule>
  <match>all</match>
  <rule field="genre" operator="is">alternative</rule>
  <rule field="genre" operator="is">alt. rock</rule>
</smartplaylist>

[jmarshall]

it's not in cvs yet.

when it is i'll let you know.

and no, order does not matter.

cheers,
jonathan

[incognegro]

thanx j for pointing that out, cant believe i never noticed that before. it works out fine for me now. also thanx to t029248.

i dont understand the playlist thing u mentioned. how would you use that? sorry if im a bit slow......