Alternate Sorting Method of Recent Episodes (with possible Solution)

Zarquon · 2011-07-21 02:27

Currently the Recent Episodes is sorted by when they are added to the Library. This works in many cases but then downloading an entire series this will often add many episodes at once making the recent episodes feature useless for a while.

What I would like to see is changing the Recent Episodes list to be sorted by Air Date.

I believe this would be easy to implement by changing the retrieval SQL statement. Currently the ORDER BY clause is:

Code:

order by idEpisode desc

Change it to:

Code:

order by CASE WHEN c05="" THEN (SELECT MAX(c05) FROM episode WHERE episode.idepisode<episodeview.idepisode) ELSE c05 END desc, idEpisode desc

Additional thoughts would be to make this an option via the settings or skin.

Sranshaft · 2011-07-21 03:09

+1 for this idea. This is the number one reason I dread having to add complete seasons to the library. Until a more elegant solution is available, I've resorted to adding a custom smart list called 'Recently aired' to my video menu.

isamu.dragon · 2011-07-21 04:44

+1 as well, I keep 6 ongoing series at a time, but I usually get all seasons of a series about a month before the new season begins.

**jmarshall** · 2011-07-21 04:48

This changes the definition from "recently added" to "recently aired", no?

Zarquon · 2011-07-21 04:52

jmarshall Wrote:This changes the definition from "recently added" to "recently aired", no?

In effect yes but personally I think this is what would be desired.

Mindzai · 2011-07-21 10:09

Rather than changing the current functionality it might be a better idea to add this as an alternative. Many skins use this functionality and as jmarshall mentioned, changing the result would mean all of these skins having to be updated to reflect the change. As well as this I expect many users actually do want a list of recently added episodes.

Sranshaft · 2011-07-21 10:29

@Jmarshall: What are your thoughts on extending the default playlists available to the TV / movie sections similar to what is available in the music section ala 'Recently played' with 'Recently aired' falling under the TV submenu and a possible 'Recently watched' for both movies and TV shows?

isamu.dragon · 2011-07-21 21:07

Mindzai Wrote:Rather than changing the current functionality it might be a better idea to add this as an alternative. Many skins use this functionality and as jmarshall mentioned, changing the result would mean all of these skins having to be updated to reflect the change. As well as this I expect many users actually do want a list of recently added episodes.

That sounds like a great idea. Kind of like how they handle Random.

Sranshaft Posting Freak Posts: 1,335 Joined: Dec 2008 Reputation: 19 Location: Melbourne, Australia	2011-07-21 03:09 Post: #2 +1 for this idea. This is the number one reason I dread having to add complete seasons to the library. Until a more elegant solution is available, I've resorted to adding a custom smart list called 'Recently aired' to my video menu.
	find quote

isamu.dragon Posting Freak Posts: 949 Joined: Feb 2009 Reputation: 4 Location: T.A.R.D.I.S.	2011-07-21 04:44 Post: #3 +1 as well, I keep 6 ongoing series at a time, but I usually get all seasons of a series about a month before the new season begins. XBMC Server/Client: Database Type: MySQL OS: WIN7 64-Bit/XBMCuntu CPU: i7/Intel Atom (Dual Core) GPU: Nvidia GeForce GTS450/Nvidia Ion RAM: 12GB/2GB (512MB GPU) XBMC Version: Frodo 12.2/XBMCbuntu Frodo 12.2Skin: Aeon Nox
	find quote

jmarshall Team-XBMC Developer Posts: 24,523 Joined: Oct 2003 Reputation: 138	2011-07-21 04:48 Post: #4 This changes the definition from "recently added" to "recently aired", no? Always read the XBMC online-manual, FAQ and search the forum before posting. Do not e-mail XBMC-Team members directly asking for support. Read/follow the forum rules. For troubleshooting and bug reporting please make sure you read this first.
	find quote

Zarquon Member Posts: 56 Joined: Dec 2009 Reputation: 0	2011-07-21 04:52 Post: #5 jmarshall Wrote:This changes the definition from "recently added" to "recently aired", no? In effect yes but personally I think this is what would be desired.
	find quote

Mindzai Fan Posts: 333 Joined: Aug 2010 Reputation: 0	2011-07-21 10:09 Post: #6 Rather than changing the current functionality it might be a better idea to add this as an alternative. Many skins use this functionality and as jmarshall mentioned, changing the result would mean all of these skins having to be updated to reflect the change. As well as this I expect many users actually do want a list of recently added episodes.
	find quote

Sranshaft Posting Freak Posts: 1,335 Joined: Dec 2008 Reputation: 19 Location: Melbourne, Australia	2011-07-21 10:29 Post: #7 @Jmarshall: What are your thoughts on extending the default playlists available to the TV / movie sections similar to what is available in the music section ala 'Recently played' with 'Recently aired' falling under the TV submenu and a possible 'Recently watched' for both movies and TV shows? (This post was last modified: 2011-07-21 10:54 by Sranshaft.)
	find quote