INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Smartlist: Find empty date?  (Read 844 times)

Marty3d

  • Citizen of the Universe
  • *****
  • Posts: 1363
Smartlist: Find empty date?
« 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! :)
Logged


marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 8972
Re: Smartlist: Find empty date?
« Reply #1 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.

Marty3d

  • Citizen of the Universe
  • *****
  • Posts: 1363
Re: Smartlist: Find empty date?
« Reply #2 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
Logged


marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 8972
Re: Smartlist: Find empty date?
« Reply #3 on: April 12, 2007, 10:04:19 am »

[fieldname]=[] is generally the way I go.
Pages: [1]   Go Up