INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: stevenf on May 28, 2006, 04:15:36 am

Title: Sorting Number Plays
Post by: stevenf on May 28, 2006, 04:15:36 am

I created a new field simply called "played" and added in the calculated field this expression

FormatDate ([Last Played, 0], dd//MM//yyyy). However, the field does not sort in order, what i get is this...

01/02/2004
01/02/2005
01/02/2005
01/03/2005
01/03/2005
01/03/2005
01/04/2006
01/04/2003

And so on, the day is sorted first, then the month and then the year.

Is there anyway i can sort the field the way that is supposed to.

19/02/2003
19/02/2003
27/02/2003
27/02/2003
28/02/2003
01/03/2003

And so on

Any help would be greatly appreciated.

Stevef

Title: Re: Sorting Number Plays
Post by: marko on May 28, 2006, 04:48:14 am

change the template to year/month/day

formatdate([last played,0],yyyy//MM//dd)

Title: Re: Sorting Number Plays
Post by: stevenf on May 28, 2006, 11:42:58 pm

Did that, the only problem is that it now shows this,

2006/03/27 amd what it want is 27/03/2006 in order

thanks

Title: Re: Sorting Number Plays
Post by: Marty3d on May 29, 2006, 05:05:09 am

Sorry to say, the above way is the only way. MC has no option to sort dates properly, just by "string". I encountered this when I wanted to sort Last Played dates formatted "3 days ago", "3 years ago". <- Guess what came first in that list :(

/Martin

Title: Re: Sorting Number Plays
Post by: PollyQ on May 29, 2006, 10:44:56 am

Use two date fields, one for sorting (yyyy/mm/dd) and one for display (mm/dd/yyyy or whatever).

Title: Re: Sorting Number Plays
Post by: marko on May 29, 2006, 01:24:19 pm

Polly, sorting in the filelist is not a problem. In the file list, you would simply apply a [last played] sort rule and the dates would be in order.

There's no way to control sorting in the panes.

Title: Re: Sorting Number Plays
Post by: stevenf on May 30, 2006, 09:55:27 pm

Marko, how that be done, coding of any sort is not my strong point

Stevenf

Title: Re: Sorting Number Plays
Post by: marko on May 31, 2006, 01:50:59 am

Stevenf,

If you right click in the file list, then choose 'customise current view' you will be presented with these options:

(http://www.theganghut.co.uk/pics/ia/ccview.jpg)

The section in the lower-right deals with sorting. Click the 'Add' button, decide whether you want descending or ascending sorting, then pick Last Played from the list.
once it's added, click on it, and move it to the top, then click the OK button.

Hopefully that will give you the result you're after, but, again, I'll draw your attention to the fact that the subject is number plays, but here, we're discussing Last Played ....

Title: Re: Sorting Number Plays
Post by: stevenf on May 31, 2006, 09:38:18 am

Unfortunatly that's not really what i'm after. As you can see from the image, it's the pane view where i want last played to sort in descending order. In the picture, it's the first song played, and i want the lastest songs at the top.

(http://img191.imageshack.us/img191/3901/panes1tg.jpg)

I appreciate any help i can get. Thanks

Stevenf

Title: Re: Sorting Number Plays
Post by: marko on May 31, 2006, 02:18:24 pm

Quote from: marko on May 29, 2006, 01:24:19 pm

Polly, sorting in the filelist is not a problem. In the file list, you would simply apply a [last played] sort rule and the dates would be in order.

There's no way to control sorting in the panes.

 ::)