Request: new view filter, "Unwatched Recently Added Episodes" (2 Viewers)

[2BitSculptor]

Sometimes the list becomes long after many episodes being added... and most watched. Then you notice somewhere on page 5 or 6 that you missed watching one or more episodes. The wife looks first at the Recently Added view (I add episodes overnight as she sleeps) but time doesn't always allow for watching all the recently added as they appear. It would be nice if you could filter for unwatched episodes in the recently added view, so that she can see what she has missed (at a glance) without re-scrolling through the whole list.

Thanks for considering this request.

Chuck

 

[2BitSculptor]

An "Unwatched Recently Aired Episodes" filter would also be nice, as the list is usually much longer.

Chuck

 

[guytpetj]

Two views I use

Database: TVSeriesDatabase4.db3
Table: Views

Latest Unwatched:
episode<;><Episode.Title>;<=;<desc><cond><Episode.FirstAired>;>=;<today-30><cond><Episode.Watched>;=;0<;><Episode.FirstAired>;desc<;>

Latest Unwatched Alpha Sorted:
episode<;><Episode.Title>;<=;<desc><cond><Episode.FirstAired>;>=;<today-30><cond><Episode.Watched>;=;0<;><Episode.EpisodeFilename>;asc<;>

 

[2BitSculptor]

but .....

I do this how?

Sorry... I'm not as savvy as I pretend to be.

Chuck

 

[guytpetj]

1. You need "SQLite Database Browser 2.0 b1.exe" to open the TVSeriesDatabase4.db3 file
2. Select the "Browse Data" tab
3. Select table "Views"
4. Add the views as per picture below

 

[2BitSculptor]

thnx ... tried it on my work PC. Took some searching to find the dnld link. then took more time getting used to the DB Browser (doesn't quite operate as expected and not responsive to all mouse clicks the first few tries ... weird). but I think it worked... gonna try it now on the HTPC.

 

[2BitSculptor]

It worked!

Thanks much for the help. I was totally clueless... but now I am mostly clueless.

Chuck

 

[guytpetj]

Great.
We use these filters 90% of the time, realy increased the WAF when I added these filters.

 

[2BitSculptor]

I used your alpha sorted version. It just makes more sense to have them grouped by series in episode order. Don't really care which network or date they were added/broadcast. I did this as much for me as for the wife.

I think the filter should be part of the default.

Thanks again.

Chuck