[Music] Adding Composer to the Music DB (1 Viewer)

hwahrmann

Development Group
  • Team MediaPortal
  • September 15, 2004
    4,633
    2,457
    Vienna, Austria
    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.
     

    jameson_uk

    Retired Team Member
  • Premium Supporter
  • January 27, 2005
    7,258
    2,528
    Birmingham
    Home Country
    United Kingdom United Kingdom
    Why shouldn't you be able to sort?
    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...
     

    hwahrmann

    Development Group
  • Team MediaPortal
  • September 15, 2004
    4,633
    2,457
    Vienna, Austria
    Home Country
    Austria Austria
    yes, this is th date added.
    look into the log, when you selct the "recently added" view

    Code:
    MusicDatabase: GetSongsByFilter - SQL: select * from tracks where dateAdded > '2009-05-05 12:00:00'  order by dateAdded desc, Filter: tracks

    do you notice the "order by" clause?
    it has dateadded as the osrt field.
     

    jameson_uk

    Retired Team Member
  • Premium Supporter
  • January 27, 2005
    7,258
    2,528
    Birmingham
    Home Country
    United Kingdom United Kingdom
    yes, this is th date added.
    look into the log, when you selct the "recently added" view

    Code:
    MusicDatabase: GetSongsByFilter - SQL: select * from tracks where dateAdded > '2009-05-05 12:00:00'  order by dateAdded desc, Filter: tracks

    do you notice the "order by" clause?
    it has dateadded as the osrt field.

    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?
     

    Helios61

    Retired Team Member
  • Premium Supporter
  • January 30, 2008
    4,587
    873
    62
    NRW
    Home Country
    Germany Germany
    Hi Helmut!

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

    Best regards

    Helios
     

    hwahrmann

    Development Group
  • Team MediaPortal
  • September 15, 2004
    4,633
    2,457
    Vienna, Austria
    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
     

    neme5i5

    Portal Member
    June 8, 2006
    13
    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.
     

    Users who are viewing this thread

    Top Bottom