Music Views - How to work with Operator (1 Viewer)

joEhSuper

MP Donator
  • Premium Supporter
  • June 2, 2011
    1,008
    580
    Home Country
    Austria Austria
    need log? :ROFLMAO:
    here it is ;)
     

    Attachments

    • MediaPortal.log
      740.6 KB

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,371
    Kyiv
    Home Country
    Ukraine Ukraine
    MP add '' and this not work ...
    Code:
    select * from tracks where  strAlbum like 'CASE LENGTH(TRIM(strAlbum)) WHEN 0 THEN ''---'' ELSE strAlbum END;' group by strAlbum, strAlbumArtist  order by strAlbum asc, Filter: album
    So it does not work that way, the only way is to leave the field blank, but if it does not work, then there are no options. Need change the logic in the MP itself. Or write in the tags album (like single) and filter it here.
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,371
    Kyiv
    Home Country
    Ukraine Ukraine
    @joEhSuper Have you tried selecting the <> operator and leaving the restrictions blank? Judging by the source code, it should work. If you can try and give me a log, I'll see what the problem is there.
     

    hwahrmann

    Development Group
  • Team MediaPortal
  • September 15, 2004
    4,633
    2,457
    Vienna, Austria
    Home Country
    Austria Austria
    Sorry guys, i was a few days away from PC and just noticed this now.
    it is years since i looked into that logic.
    Theroatically it should work, but i need to check it.

    i will not have time before 6.1.2021.
    remind me after that, if you haven't heard from me
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,371
    Kyiv
    Home Country
    Ukraine Ukraine
    Theroatically it should work, but i need to check it.
    Judging by the code no, an empty value is discarded in the analysis, and all SQL expressions are wrapped in single quotes. :)
    Happy New Year :)
     

    Users who are viewing this thread

    Top Bottom