Request: 3 new custom view filters (1 Viewer)

Inker

Retired Team Member
  • Premium Supporter
  • December 6, 2004
    2,055
    318
    Regarding the syntax, Inker the original author of the plugin quickly whipped the view system and syntax up (with regret I believe) :0
    .
    This man speaks the truth!
     

    Michael_M112

    Portal Member
    July 1, 2009
    11
    1
    Home Country
    Germany Germany
    It's getting spooky:

    <Episodes.myRating>!=0 returns all episodes I rated plus episodes that are missing (+ unrated)

    <Episodes.myRating>=0 returns no results

    So I somehow have episodes with myRating neither = 0 nor !=0. These are the ones I want to filter.

    I'm also still trying to filter missing episodes. Any suggestions on that?
     

    ltfearme

    Community Plugin Dev
  • Premium Supporter
  • June 10, 2007
    6,760
    7,224
    Sydney
    Home Country
    Australia Australia
    Had a quick look and looks like myRating is a string field so 0 will not work.
    I tried empty string but tvs fails to generate the sql correctly (you can see this in log file) so fails.

    Code:
    where online_episodes.myRating =

    should of generated this:

    Code:
    where online_episodes.myRating = ''

    I think a fix is needed to support empty strings/nulls, maybe a keyword like <empty>.
     

    Users who are viewing this thread

    Top Bottom