INTERACT FORUM

More => Old Versions => Media Center 12 (Development Ended) => Topic started by: winterminute on December 26, 2007, 11:54:19 am

Title: 'Limit Number To' Doesn't Work When Sorting on [Date Imported]
Post by: winterminute on December 26, 2007, 11:54:19 am
I'm trying to create a playlist which has the last 200 tracks imported with a certain rating.  The rating part is easy and I found some posts which highlight the fact that [Date Imported] is really a datetime stamp and can't be used for sort purposes so I created a new calculated field with this formula:

     formatdate([date imported,0],yyyy//MM//dd)

If I create a playlist with just my rating criteria and use the newly column header to sort, then I see all the tracks I recently imported that I expect to be there.  For example, I see 105 tracks added since Dec 1st with a rating of 4 or higher.  However, as soon as I add a Limited Number To=200, then most new tracks disappear and I end up with older tracks from months ago.  In this case, I only see 9 tracks added since Dec 1st with a rating of 4 or higher.

So, it definitely seems to be the sorting logic, but I don't fully understand why.
Here are the modifiers:
   Sort By             = ~sort=[Import Date] -d
   Limit Number To  = 200

Any ideas?
Title: Re: 'Limit Number To' Doesn't Work When Sorting on [Date Imported]
Post by: marko on December 26, 2007, 12:17:48 pm
Check this first: ~sort=[Import Date] -d

There should not be a space between the field and the 'descending' instruction.

~sort=[Import Date]-d

If it's not as simple as that, shout back and we'll get it sorted.

-marko.