[Music] - Error in music views

Discussion in 'MediaPortal 1.1.0 BETA 1' started by jameson_uk, October 14, 2009.

  1. jameson_uk
    • Premium Supporter

    jameson_uk Retired Team Member

    Joined:
    January 27, 2005
    Messages:
    7,258
    Likes Received:
    2,228
    Gender:
    Male
    Occupation:
    Data Warehousing Consultant
    Location:
    Birmingham
    Ratings:
    +2,405 / 0
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    I am trying to setup a view which groups on composer (new tag in 1.1) and then displays album artist underneath.

    In log you get
    Code (Text):
    1. 2009-10-14 18:00:26.437500 [Debug][MPMain]: MusicDatabase: GetSongsByFilter - SQL: select distinct strAlbumArtist from tracks where  (strComposer like 'A%' or 'A%')  order by strAlbumArtist asc, Filter: albumartist
    But this can not work as the composer tag is stored like '| composer |' so the SQL does not return any data and the view does not work.

    Similarily if I create a view grouping by album artist (restricted to 1) then albums then tracks I get the same error
    Code (Text):
    1. 2009-10-14 18:25:18.859375 [Debug][MPMain]: MusicDatabase: GetSongsByFilter - SQL: select distinct * from tracks where  strAlbumArtist < 'A' group by strAlbum, strAlbumArtist   order by strAlbum desc, Filter: album
    If I take out the grouping I get
    Code (Text):
    1. 2009-10-14 18:27:45.921875 [Debug][MPMain]: MusicDatabase: GetSongsByFilter - SQL: select distinct * from tracks where strAlbumArtist like '%| Beck |%' group by strAlbum, strAlbumArtist   order by strAlbum desc, Filter: album
    and the view works as the "%| albumartist |%" filter is correct



    If you group on album artist and show album artist it is clever enough to the albumartist table and the tracks table
    Code (Text):
    1. 2009-10-14 18:12:35.187500 [Debug][MPMain]: MusicDatabase: GetSongsByFilter - SQL: select distinct strAlbumArtist from albumartist where  (strAlbumArtist like 'A%' or 'A%')  order by strAlbumArtist asc, Filter: albumartist
    So this works


    One of the main reasons for badgering hwahrmann to add the composer tag was so that I can create views that are filtered by composer but the details show album artist (eg. my collection has CDs by The Beatles stored with an album artist of "The Beatles" and a composer of "Beatles, The", CDs by Phil Collins have an album artist of "Phil Collins" and a composer of "Collins, Phil". The idea is that I can create a view grouping on composer (so The beatles appears under B and Phil Collins appears under C) and then have the actual album artist tag shown under this
     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. jameson_uk
    • Premium Supporter

    jameson_uk Retired Team Member

    Joined:
    January 27, 2005
    Messages:
    7,258
    Likes Received:
    2,228
    Gender:
    Male
    Occupation:
    Data Warehousing Consultant
    Location:
    Birmingham
    Ratings:
    +2,405 / 0
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    bump...
     
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!