Latest Unwatched View? (2 Viewers)

[mrbenn]

Is it possible to create a view that combines the "latest" view with the "Unwatched" one, as at the min it is showing lots of eps I have already seen in the Latest view and this is not that useful imho.
I have played around with the view settings in config but they do not seem to do much

 

[spuck]

Yeah you can..

- Open: \Team MediaPortal\MediaPortal\Docs\SQLite Database Browser.exe
- Open your database: \Team MediaPortal\MediaPortal\Database\TVSeriesDatabase4.db3
- Click TAB "Browse Data".
- Choose TABLE "Views".

- Click "New Record".
Now you get an empty new line which will contain the new view.

You double click the field to change its value.

Enter Values: (Don't leave anything empty)
- All "ID" and "sort" have to be unique.

ID: [B]6[/B]
Enabled: [B]1[/B]
Sort: [B]7[/B]
TransToken: [B]Latest2[/B] (Or whatever name you want)
PrettyName: [B]Latest2[/B] (Or whatever name you want)
viewConfig: [B]episode<;><Episode.Watched>;=;0<;><Episode.FirstAired>;desc<;>25[/B]

 

[mrbenn]

that works perfect, thank you


How about a view that shows latest unwatched episodes of Favorite Shows? (I have ZERO clue about the expressions language in SQL)

 

[spuck]

No idea how to do 2 conditions in that weird syntax but here's how you do latest favorite shows:

episode<;><Series.isFavourite>;=;1<;><Episode.FirstAired>;desc<;>25

 

[Inker]

viewConfig: episode<;><Episode.Watched>;=;0<cond><Series.isFavourite>;=;1<;><Episode.FirstAired>;desc<;>25

Untested, but should work.

If only someone wrote a gui config for it, huh?

I'm working on something else, sorry.

Inker

 

[mrbenn]

tried that config Inker, just getting "No Items!" in the view when i check it. Any suggestions?

 

[Inker]

Works for me, I have a wrong space above, below is the correct one without spaces:

viewConfig:

episode<;><Episode.Watched>;=;0<cond><Series.isFavourite>;=;1<;><Episode.FirstAired>;desc<;>25

 

[mrbenn]

Perfect! thank you so much. Looking forward to any more development on this fantastic plugin (THE main reason i use MP)

 

[Mavoc]

i like to leave the option to show all episodes whether i have them or not ON.

is there a line i could used to tweak my DB so that in my latest listing it shows the latest episodes which are <= the current date?

 

[Inker]

i like to leave the option to show all episodes whether i have them or not ON.

is there a line i could used to tweak my DB so that in my latest listing it shows the latest episodes which are <= the current date?

No, unfortunatly only static values and values stored in DB (and there only ep/season/series) can be used for conditions right now.