Set sort order event

[Flavio61]

I have created a button with an event "Set sort order" to sort my movies by purchaseDate. All works, but the movies are sorted from the first (older date) to the last (newer date), I want the opposite order.

Any help.

[Colby]

I think the trick is to use :-1 or :+1 to before or after the sort parameter to change how it lists it. Im not certain but you can confirm what it is if you get it working.

[Flavio61]

It's no the solution or I'm not good.

I try with title field in Sort Order, if I add :+1 the order is right A-Z, but if I add :-1 the order change but is not Z-A (as I hope) but P-M-O-N etc. etc.

[Colby]

How are your dates tagged? 12/30/2005 or 30/12/2005 or 2005/12/25 ?
Also you are saying that -1 = Z,X,Y,W...? That has to be a bug.

[Flavio61]

My date are in yyyy/mm/dd format.

Now I try with title order because is more simple to verify, but if I add :-1 the order is random M-P-E-W or S-O-W-B.

[jowaldo]

My date are in yyyy/mm/dd format.

Now I try with title order because is more simple to verify, but if I add :-1 the order is random M-P-E-W or S-O-W-B.

anyone figure this one out? I'm trying to get a numerical list in decending order...

[m_ski]

Can you tell us the exact strings you are trying to use. I have found that if the string is not quite correct then xlobby seems to display stuff in a pretty jumbled up order - that may be the problem you are having.

To use reverse order you should use something like this...

Code: Select all

-1:lastplayed:artist:albumname:tracknumber:trackfilename

The above sort string gives me my music collection with the most recently played stuff at the top and works perfectly. (lastplayed is a datestamp which I automatically add to an album when it gets played)

[lar282]

I use a button to VARIABLE SET the purchase date for today
category name: Movies2
purchasedate
%datetime>yyyy-MM-dd%

Then I sort them SET SORT ORDER
Category name
Sort Order: -1:purchasedate

This gives me dates like this
2006-05-11

This works me me.

//Lasse

[Flavio61]

Thank's to m_ski and lar282.

With -1: before the sortorder field all works fine.

[jowaldo]

The above sort string gives me my music collection with the most recently played stuff at the top and works perfectly. (lastplayed is a datestamp which I automatically add to an album when it gets played)

how exactly are you doing a datestamp?

[m_ski]

I use the datetime>u parameter which is now globally available and apply it to an album field I call 'lastplayed'.
I then have to re-sort the database (using xscript so I can use a variable as the sort parameter) so that the album you have just played then appears at the top of the list.

The play album event looks like this (in raw xml but I guess you'll work it out...)

Code: Select all

<event>
  <name>play album</name>
  <multithreaded>False</multithreaded>
  <commands>
   <command>
    <type>category</type>
    <execute>play</execute>
    <parameter>music</parameter>
   </command>
   <command>
    <type>category</type>
    <execute>variable set</execute>
    <parameter>music</parameter>
    <parameter>lastplayed</parameter>
    <parameter>%datetime&gt;u%</parameter>
   </command>
   <command>
    <type>plugin</type>
    <execute>command</execute>
    <parameter>XScript</parameter>
    <parameter>ExecScript</parameter>
    <parameter>SortByVariable.txt music %variable&gt;currentmusicsort%</parameter>
   </command>
  </commands>
 </event>
 <event>

It works really well for me as it allows me to display the recently played albums on the main menu really easily...