Sorting filter results in reverse order?

Help each other out

Sorting filter results in reverse order?

Postby pvrnorth on Thu Aug 06, 2009 12:15 pm

I'd like to be able to sort the results of a 'set filter' command in reverse order.

In my case I have:
a database, moviedb.xml, that I set through the category item to a movieall category which is hidden on the screen.
I have an event that does a
'set filter'
category: movieall, filter: rating, results category: moviefilterbrowser

Now this lists the ratings in the moviefilterbrowser category from lowest to highest, but I would like the highest rated movies to show up first. (ie moviefilterbrowser has a 'Details Cat' of movie_select which shows the cover art of the movies in this rating.

I've tried adding a 'set sort order' command, with category name: moviefilterbrowser, and sort order: -1:year, but this doesn't seem to have any affect. (I've tried this before and after the 'set filter' command)

I'd also like to do this with the year, but this should be the same as the above example once I get it figured out.

Any help would be much appreciated!

Thanks!
pvrnorth
 
Posts: 11
Joined: Sat Mar 31, 2007 2:10 pm

Re: Sorting filter results in reverse order?

Postby slaman on Wed Sep 30, 2009 4:29 am

pvrnorth wrote:I'd like to be able to sort the results of a 'set filter' command in reverse order.

In my case I have:
a database, moviedb.xml, that I set through the category item to a movieall category which is hidden on the screen.
I have an event that does a
'set filter'
category: movieall, filter: rating, results category: moviefilterbrowser

Now this lists the ratings in the moviefilterbrowser category from lowest to highest, but I would like the highest rated movies to show up first. (ie moviefilterbrowser has a 'Details Cat' of movie_select which shows the cover art of the movies in this rating.

I've tried adding a 'set sort order' command, with category name: moviefilterbrowser, and sort order: -1:year, but this doesn't seem to have any affect. (I've tried this before and after the 'set filter' command)

I'd also like to do this with the year, but this should be the same as the above example once I get it figured out.

Any help would be much appreciated!

Thanks!


Had to do this today as well (I'm using a dateadded custom field to identify recently added entries to my database) and I used the "set sort order" event using "-1:datadded" as the filter and it worked.
slaman
 
Posts: 145
Joined: Sat Oct 14, 2006 10:30 pm