[Music] - Adding Composer to the Music DB | Page 5

Discussion in 'Improvement Suggestions' started by GoldenEye, February 18, 2007.

  1. hwahrmann
    • Team MediaPortal

    hwahrmann Development Group

    Joined:
    September 15, 2004
    Messages:
    4,501
    Likes Received:
    1,639
    Gender:
    Male
    Location:
    Vienna, Austria
    Ratings:
    +2,266 / 1
    Home Country:
    Austria Austria
    last 3 month is e.g. 30 * 3 = 90 in the restrictiion field

    Why shouldn't you be able to sort?
    You get a list of songs and you can sort them by artist, track, or whatever.


     
  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
    Think I am being stupid....
    In the sort options there is no recently added value but there is a date. Is this date the dateAdded field from the database or is it the release date or something? It is not clear (not at home to check...)

    If the Date sort option is the dateAdded database field then this should be the job and I am just being thick...
     
  4. hwahrmann
    • Team MediaPortal

    hwahrmann Development Group

    Joined:
    September 15, 2004
    Messages:
    4,501
    Likes Received:
    1,639
    Gender:
    Male
    Location:
    Vienna, Austria
    Ratings:
    +2,266 / 1
    Home Country:
    Austria Austria
    yes, this is th date added.
    look into the log, when you selct the "recently added" view

    Code (Text):
    1.  
    2. MusicDatabase: GetSongsByFilter - SQL: select * from tracks where dateAdded > '2009-05-05 12:00:00'  order by dateAdded desc, Filter: tracks
    3.  
    do you notice the "order by" clause?
    it has dateadded as the osrt field.
     
    • Like Like x 1
  5. 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
    Lol, I am a DBA so spend all day looking at SQL. Had I known the SQL was in the log...

    Thanks a lot. It was me being a bit thick then!!!

    Perhaps it might be a worthwhile change to rename date to Date Added in the order by drop down else it is a little confusing?
     
  6. Helios61
    • Premium Supporter

    Helios61 Retired Team Member

    Joined:
    January 30, 2008
    Messages:
    4,587
    Likes Received:
    584
    Gender:
    Male
    Location:
    NRW
    Ratings:
    +897 / 4
    Home Country:
    Germany Germany
    Show System Specs
    Hi Helmut!

    Is it possible to add the field composer (or songwriter from cuesheet) to the "MyMusicPlayingNow.xml"?

    Best regards

    Helios
     
  7. neme5i5

    neme5i5 Portal Member

    Joined:
    June 8, 2006
    Messages:
    13
    Likes Received:
    0
    Ratings:
    +0 / 0
    ping this is must have my WAF is going way down because of this.
     
  8. hwahrmann
    • Team MediaPortal

    hwahrmann Development Group

    Joined:
    September 15, 2004
    Messages:
    4,501
    Likes Received:
    1,639
    Gender:
    Male
    Location:
    Vienna, Austria
    Ratings:
    +2,266 / 1
    Home Country:
    Austria Austria
    sorry, haven't noticed this one before.
    It's too late. we're in feature freeze. not even changes to skins are done anymore, unless those are bug fixes
     
  9. neme5i5

    neme5i5 Portal Member

    Joined:
    June 8, 2006
    Messages:
    13
    Likes Received:
    0
    Ratings:
    +0 / 0
    it's in the latest Beta/SVN

    Thanks I can at least make a selection on Composer that's much better thanks. I'm really looking forward to MP II, the server based model is just what I need. I have three machines running off the same replicated database.
     
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!