How can I create a custom view by manipulating the database? (1 Viewer)

guytpetj

MP Donator
  • Premium Supporter
  • March 24, 2005
    424
    57
    60
    USA
    Home Country
    United States of America United States of America
    How can I create a custom view by manipulating the database?
    I want to have a combination of the"Latest" and "Unwatched" views, so it only shows the "Latest Unwatched" files
     

    guytpetj

    MP Donator
  • Premium Supporter
  • March 24, 2005
    424
    57
    60
    USA
    Home Country
    United States of America United States of America
    where am I going wrong?

    I added an entry to the database, see below, but I can't get it to work, all view modes are gone now in TVSeries when I activate this entry.

    episode<;><Episode.Watched>;=;0<;><;><nextStep>episode<;><;><Episode.FirstAired>;<=;<today><cond><Episode.FirstAired>;>=;<today-30><;><Episode.FirstAired>;desc<;>
     

    ltfearme

    Community Plugin Dev
  • Premium Supporter
  • June 10, 2007
    6,751
    7,196
    Sydney
    Home Country
    Australia Australia
    You dont need two <episode> view steps, there is only one. You need to add the condition to the existing episode step.

    Latest Added - UnWatched
    Code:
    episode<;><Episode.FirstAired>;<=;<today><cond><Episode.FirstAired>;>=;<today-30><cond><Episode.Watched>;=;0<;><Episode.FirstAired>;desc<;>

    Recently Added - UnWatched
    Code:
    episode<;><Episode.FileDateCreated>;>=;<today-7><cond><Episode.Watched>;=;0<;><Episode.FileDateCreated>;desc<;>
     

    guytpetj

    MP Donator
  • Premium Supporter
  • March 24, 2005
    424
    57
    60
    USA
    Home Country
    United States of America United States of America
    Itfearme,
    Thanks, WAF went from A+ to A++
    she wanted this option for a while.
     

    Users who are viewing this thread

    Similar threads

    I have all of my media on a NAS. I guess it might just be a network issue, then.
    I have all of my media on a NAS. I guess it might just be a network issue, then.
    Whenever I go into the back end for Moving Pictures, it almost immediately hangs on the Movie Importer tab. If I want to go into...
    Replies
    4
    Views
    498
    Yes, unfortunately, this would need a code change to support it. Next time I'm doing something on the plugin I'll try and remember to add support for this sort order.
    Yes, unfortunately, this would need a code change to support it. Next time I'm doing something on the plugin I'll try and...
    Hi, I was wondering if there is anyone who might be able to help me out. Is there a way to either use the sort feature and/or a...
    Replies
    6
    Views
    830
    I know I made some more advanced rules for my own setup, but without access to the SQLite db3 file that is difficult to remember from. As per: mptvseries/ViewTemplates.cs at master · damienhaynes/mptvseries I'm not seeing much in the other default templates either, but I do recall that both table values are available to use. It is...
    I know I made some more advanced rules for my own setup, but without access to the SQLite db3 file that is difficult to remember...
    Hi, I use mediaportal and MPTVseries for quite a long time, thank you for this plugin. Recently, due to lists becoming too long...
    Replies
    4
    Views
    1K
    Can anyone help with this?
    Can anyone help with this?
    Hi, How do I create a music view in the MP1 configuration tool music views section to list all my song tracks under a heading of...
    Replies
    1
    Views
    1K
    Hi, First off: there are some issues with the latest Mediaportal (32bits vs 64bits), so that is one of the issues you're stumbling with. If you take the previous version (1.31) it should work as expected. For IPTV there is also a different option (with different pros and cons): Onlinevideos. I'm using that sometimes for my IPTV as...
    Hi, First off: there are some issues with the latest Mediaportal (32bits vs 64bits), so that is one of the issues you're stumbling...
    Hi I am trying to play a m3u file from my IPTV provider, but when I try to install the TV part of Media Portal v1.3.2 I get an...
    Replies
    1
    Views
    673
    Top Bottom