[rcrh]

I'm trying to build a smart playlist to select a ramdom bunch of previously watched sitcoms. But I can't get the playcount to work.
If I select playcount is 0 I get all of the unwatched items but I try anything else I get an empty list. I've tried
playcount isnot 0
playcount is 1
playcount greaterthan 0

All of these return an empty list.

Here is my complete smartlist

<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<smartplaylist type="episodes">
<name>sitcoms</name>
<match>all</match>
<rule field="genre" operator="is">
<value>COMEDY</value>
</rule>
<rule field="playcount" operator="greaterthan">
<value>0</value>
</rule>
<order direction="ascending">random</order>
</smartplaylist>

BTW, I first tested the genre selector by leaving out the playcount and it worked. It only fails when I can the playcount.

Anyone have a suggestion?

Thanks in advance.

[Samu-rai]

Are you using the built in smart playlist creator to build this?

[rcrh]

Are you using the built in smart playlist creator to build this?

yup. Built through the interface.

[jmarshall]

The Debug Log will give you the SQL query being used which might be useful.

[rcrh]

The Debug Log will give you the SQL query being used which might be useful.

I'll check that in the morning. Thanks.

[rcrh]

The Debug Log will give you the SQL query being used which might be useful.

And another useful thing would be to turn off "Hide watched items" in my skin! IDIOT!!!

Thanks everyone for trying to help the helpless.

[jmarshall]

No worries - glad you got it working