INTERACT FORUM

More => Old Versions => Media Center 12 (Development Ended) => Topic started by: Marty3d on April 12, 2007, 07:41:53 am

Title: Smartlist: Find empty date?
Post by: Marty3d on April 12, 2007, 07:41:53 am

I must have left my brain somewhere, this is ridiculously trivial!

Tried to add "Never played" to my search list pane, but I assume this applies to smartlists as well.
I use entries like [last played]=>10d to get files played in those time spans. But how do I get files never played?!
I tried [last played]=[], [last played]==[], [last played]= "" etc, but it doesn't fetch files with no dates set. Finally I used [number of plays]==0 instead, but sure you can find empty fields?

Help please! :)

Title: Re: Smartlist: Find empty date?
Post by: marko on April 12, 2007, 08:33:23 am

[number plays]=[] is all I've ever used for 'never played' tracks. (I assigned the field a keyword, meaning all I need to type is np=[])

[last played] doesn't really have dates. It's one of those fields that MC calculates internally using 'time ago' arithmetic, and then outputs the results for us to see in a friendly fashion.
For example: 38529.746446759258 = 26/06/2005 17:54

A search on the raw data: [=isempty([last played,0])]=1 will return never played files, but really, keying off the [number plays] field is a lot easier, and returns the same results.

-marko.

Title: Re: Smartlist: Find empty date?
Post by: Marty3d on April 12, 2007, 08:39:52 am

Thanks, I'll go with the number of plays-solution!

But how DO you find empty fields? Is it using the IsEmpty()? Seems more logical to be able to use sql-type of query, [fieldname]='' or something... You mention that numerical fields like [number of plays] understands [fieldname]=[]... Any other ways than the previous two?

Thanks!
/Martin

Title: Re: Smartlist: Find empty date?
Post by: marko on April 12, 2007, 10:04:19 am

[fieldname]=[] is generally the way I go.