New Advanced filter option for TV Shows (Most recently watched episodes)

Feature Suggestions
,
1

Request:
Add new Filter option for TV Show Episodes to allow me to add the ‘n’ most recently watched episodes. This could either be a new filter category or (my preference) a new option under the ‘Episode Last Played’ filter

Further Details:
I currently have a number of Smart Playlists set up to manage my syncing to remote devices. With the new advanced filtering this has become a lot easier however adding the above filtering option would be great.
What I am looking to achieve is a filter condition which lets me find all unwatched episodes of a show plus the 2 most recently watched episodes. An example of the filters I currently use is below.

image
image868×414 73.7 KB

What I am suggesting is that an additional option is added to the dropdown currently set to ‘Days’ called something like ‘Episodes’ so I can make the filter read

[Episode Last Played] [is in the last] 2 [Episodes]

At the moment if I have watched a few episodes of a certain show (especially some of my shorter TV Shows where I could easily watch 10-15 on my commute) they can fill up the smart playlist and leave me with nothing (or not enough) to watch.

2

So basically you’re looking packing 2 individual filters in a single filter rule?

  1. episodes sorted by date viewed, limited to 2
  2. unwatched episodes sorted by air date, limited to 3

Otherwise… which unplayed episodes would you pick for your use case?

3

That would be one way of looking at it but in reality I want them all sorted by air date but to include the ‘n’ most recently watched episodes.
I don’t have much experience with SQLite in particular but if I was building the query string I would be using the RANK Function to determine the watched order of episodes and filter for when the result of this function is less than or equal to ‘n’. This shouldn’t then affect the sort order of the filter results but will bring in the n most recently watched episodes to the results