Movie Sets Collection Grouping for Video Database Library Custom Sort Order Filters?

This would be a pretty neat addition....I don't care that much about sequels that are separated anyway, but when they're already grouped right together but out of order (like the lord of the rings trilogy goes Fellowship, Return of the king, the two towers) it would be nice to be able to change that. It just feels wrong haha

I looked around and searched and didn't find anything like this suggested. I realize it's probably a lot of work, but something for a future version perhaps...

What I was thinking about is a movie grouping option for the video library. Right now it sorts alphabetically by movie title, and yes I could change the movie title to put the 'series' or 'group' name in front so it will sort, but it would rock if we could add them to a group.

Example...

I have the Die Hard series...

Die Hard
Die Harder
Die Hard: With A Vengeance
Live Free, Die Hard

The first three get put next to one another, and due to the naming even in the right order, the last one is nowhere near these due to starting with an L.

Examples of other such 'groups' or "series' (usually epic sagas that are followed by each other) are; Alien, Dirty Harry, Fast and Furious, Harry Potter, Indiana Jones, Grindhouse (Death Proof and Planet Terror), James Bond (007), Lord Of The Rings, Star Wars, Transporter, Rambo, Planet Of The Apes, Sällskapsresan, Jump London and Jump Britain.


If we could create movie 'groups' or 'series' and then attach the movies to these groups and order them in the correct order.

As far as sorting goes, if the movies are in a group, it should insert the group alphabetically with the rest of the movies, and then just order the movies based on the order they're set up inside the group or series.

That way it would show like so:

A Movie, B Movie, C Movie, Die Hard, Die Harder, Die Hard: With a Vengeance, Live Free Die Hard, E Movie, F Movie, G Movie, etc...


If people want them in true alphabetical order, they just leave them without a group, if they want to sort them like this, then they create a group for them, so it can be done either way.

Again, I appreciate all the work that Team-XBMC does, I realize this would take quite a bit of coding and additions to the databases and interfaces, but it would be a pretty cool feature.

I think there's a sortorder field in the db already - maybe only for tvshows, I'm not sure.

That would be the way I would do it at least, though it would require you the user to edit the database manually, or use a .nfo file for importing.

I would love this feature and have requested it before (along with others). I'll have to check the db when I get home. If there is no sortorder field in the db for movies would you be kind enough to add one?

@ jmarshall - I can't tell if there is a sortorder field or not. All the field labels have nondescript names like c00, c01, c02, etc. Some fields are completely empty so maybe one is the sort order, but I can't tell.

Is there any way you can tell if any of the empty fields is for sort order? If none are, could you please add it?

On another note... Why don't the field labels have descriptive names?

If there is a sort-order field, is it some kind of numeric only field? Or is it a text field that I can put in the title the way I want it sorted?

If it's a text field, that would work for me, I would have to go through my 400+ movies and put them in the right order, which I have no problem with...but like RockDawg, I need to know which field it is in the DB, and also if it's not available for movies, can it be added for them in a future release?

Thanks!

Is there anywhere that has a "map" of what the fields in the databases are? They're just labeled C1 C2, etc...and I can't find on the wiki anywhere of what they're supposed to be for.

Would Love the ability to move movies up and down the order.

Not sure what all the fields ar for in the db but some are blank as has been mentioned but there doesnt seem to be any numerical record field.
If there was it would be easy enough to move individual records up and down the db
________
Gilles Villeneuve

I'm still trying to figure out what each field is for, and if there isn't a sortorder try to add one...so far I haven't come up with much in the actual code. Anyone else with input?

I have tried entering an alternate movie name in every blank field in that table and I don't think any of them are some type of "sort order" since it never affected my sort order in XBMC.