Sort order not working?

Any trouble you encounter with the Pedias, here's the place to ask for help.

Sort order not working?

Postby Rodney » Sun May 09, 2021 10:21 am

Not sure if this is a bug or an issue on my part. I use wishlist in DVDpedia for media I don't own. I sort by title, then by release date. The problem is that it doesn't stay in alphabetical order within the release dates as I expect them to. For example, here are the films that are coming out on May 25th and the strange order that DVDpedia is putting them in:

Athena
The Final Countdown (3-Disc Limited Edition/4K UHD + Blu-ray + CD)
The Groove Tube
The Tender Trap
City Slickers II: The Legend of Curly's Gold
Explorers
Lights of Old Broadway
My Fair Lady
The Night of the Following Day
Nightmare Alley

How can I correct this?
Rodney
Bruji Friend
Bruji Friend
 
Posts: 15
Joined: Mon Oct 05, 2015 2:08 pm
Location: Mansfield, TX

Re: Sort order not working?

Postby FineWine » Sun May 09, 2021 4:02 pm

Have a read of this Help article: Sorting a collection

Also within Preferences > General > Ignore foreign articles during title sort'

Which will not take into account foreign articles such as der, die, das, le, la, el, etc. when sorting entries by title. The program automatically ignores English articles (the, a, an) when sorting. For this setting to take effect you have to re-sort the title column after you've checked the preference so the titles can pick up the new sort method.

For total control over the sort feature, use the 'Sort Title' field. Whatever you enter into that field, that's what the program will take into account when sorting. So if you want "12 Monkeys" to be sorted under Monkey instead of 12, enter M into the Sort Title field of the movie.
User avatar
FineWine
Addicted to Bruji
Addicted to Bruji
 
Posts: 617
Joined: Wed May 28, 2008 2:41 am
Location: Tauranga, New Zealand

Re: Sort order not working?

Postby Rodney » Tue May 11, 2021 5:18 pm

Thanks, but I did read that article before I posted, and unless I am sadly mistaken, the english particles don't apply. Why would The Tender Trap be listed BEFORE City Slickers II or Explorers?
I don't have anything in the Sort Title Field.
Rodney
Bruji Friend
Bruji Friend
 
Posts: 15
Joined: Mon Oct 05, 2015 2:08 pm
Location: Mansfield, TX

Re: Sort order not working?

Postby FineWine » Tue May 11, 2021 6:54 pm

Sorting in the Wish List is working for me for DVDpedia 6.1.0 Beta190

You stated in your first post: "I sort by title, then by release date."

Just to re-emphasise; you need to sort in reverse order to the end result. So in your case you need to sort the "Release Date" column first then the "Title" column last.

HELP FILE ON SORTING:
You can also sort by multiple columns to a depth of 6 columns. When you change column, it sub-sorts by what was last sorted so you want to click on the columns in reverse order i.e. if you want to sort your collection by Director, Genre and My Rating, sort the My Rating column first, then Genre, then Director; the sorting will now be Director, and where those are equal Genre, and where those are equal My Rating.


In my own main DVD Library I sort by: Episode > Season > Series > Title
User avatar
FineWine
Addicted to Bruji
Addicted to Bruji
 
Posts: 617
Joined: Wed May 28, 2008 2:41 am
Location: Tauranga, New Zealand

Re: Sort order not working?

Postby Rodney » Fri May 14, 2021 8:20 am

Sorry if I am not making myself clear.

The objective is to have the items listed in Release Date order, but within the release dates I want the titles in alphabetical order.

If I follow your example I get the titles in alphabetical order but the release dates are scattered.It would appear to me I need to first put the titles into alphabetical order, and then to Release date, which should produce the results I want, but it is not. The sub-sort of alphabetical within the Release Date is not working as I expect it to.

I am also using DVDpedia 6.1.0 Beta190

-Rodney
Rodney
Bruji Friend
Bruji Friend
 
Posts: 15
Joined: Mon Oct 05, 2015 2:08 pm
Location: Mansfield, TX

Re: Sort order not working?

Postby FineWine » Fri May 14, 2021 3:21 pm

OK I now understand what you want to do.

Is your date format for Release Date: Jan 2021 or are they 02/01/2021

I have fired off a quick email to Conor whom due to the pandemic and family commitments is not as frequent in these forums at the moment.
User avatar
FineWine
Addicted to Bruji
Addicted to Bruji
 
Posts: 617
Joined: Wed May 28, 2008 2:41 am
Location: Tauranga, New Zealand

Re: Sort order not working?

Postby Rodney » Sat May 15, 2021 6:05 pm

The format for the release date is: MMM dd, yyyy
Rodney
Bruji Friend
Bruji Friend
 
Posts: 15
Joined: Mon Oct 05, 2015 2:08 pm
Location: Mansfield, TX

Re: Sort order not working?

Postby FineWine » Sat May 15, 2021 7:12 pm

Rodney wrote:The format for the release date is: MMM dd, yyyy

My own format for the Release Date is: MMM yyyy (Sept 2021)
All my other dates are: d/MM/yy (2/09/21)
NOTE: therefore this is a non-American date format

This can be changed in Preferences > General

Click on the :?: next to the field for more info.

In your own case of MMM dd, yyyy (Sept 09, 2021) would still be sorted; year, month, day

But this is all well and good but does not help in this instance as the pedia is not secondary sub-sorting the Title column alphabetically after and within the date sorting order. This appears to affect ALL date fields.

Thanks for pointing this out.
User avatar
FineWine
Addicted to Bruji
Addicted to Bruji
 
Posts: 617
Joined: Wed May 28, 2008 2:41 am
Location: Tauranga, New Zealand


Return to Support

cron