LMH need help! Help plz ... How select episodes in Online Rating sort order (2 Viewers)

ajs

Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,366
    Kyiv
    Home Country
    Ukraine Ukraine
    Help plz ... How select episodes in Online Rating sort order, asc or desc, i try:
    C#:
              SQLCondition conditions = new SQLCondition();
              conditions.Add(new DBOnlineEpisode(), DBOnlineEpisode.cSeriesID, 0, SQLConditionType.GreaterThan);
              conditions.Add(new DBOnlineEpisode(), DBOnlineEpisode.cHidden, 0, SQLConditionType.Equal);
              conditions.Add(new DBOnlineEpisode(), DBOnlineEpisode.cRating, 0, SQLConditionType.GreaterThan);
              conditions.AddOrderItem(DBOnlineEpisode.Q(DBOnlineEpisode.cRating), SQLCondition.orderType.Descending);
              logger.Debug("*** Rated: " + conditions.ToString());
    
              episodes = DBEpisode.Get(conditions, false);
              if (episodes == null || episodes.Count == 0)
              {
                logger.Debug("*** Rated Failed... Try another...");
                episodes = DBEpisode.Get(conditions);
              }
    But no result :(
     

    Edalex

    Community Plugin Dev
  • Premium Supporter
  • January 3, 2008
    2,955
    1,264
    Saratov
    Home Country
    Russian Federation Russian Federation
    I never understand that syntax...
    If it's ordinary list of episodes you could try LinQ methods:
    C#:
    use System.Linq;
    var newList = list.OrderBy(x => x[DBOnlineEpisode.cRating]).ToList();
    Dunno if string type for Rating suits for sorting. Maybe you should convert it to double first :cautious:
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,366
    Kyiv
    Home Country
    Ukraine Ukraine
    • Thread starter
    • Moderator
    • #3
    Dunno if string type for Rating suits for sorting. Maybe you should convert it to double first
    I need TVSeries local episodes for fill latests ...

    list.OrderBy(x => x[DBOnlineEpisode.cRating]).ToList()
    Это работает? Или получить все подряд, затем сортировать и анализировать?
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    15,492
    10,366
    Kyiv
    Home Country
    Ukraine Ukraine
    • Thread starter
    • Moderator
    • #10
    Code looks the same as ltfearme linked
    I need sort by Online Episode field:
    C#:
    conditions.AddOrderItem(DBOnlineEpisode.Q(DBOnlineEpisode.cRating), SQLCondition.orderType.Descending);
    ltfearme code only sort by Local_Episode field ...:
    C#:
    condition.AddOrderItem(DBEpisode.Q(DBEpisode.cFileDateCreated), SQLCondition.orderType.Descending);
    ...
    condition.AddOrderItem(DBEpisode.Q(cFileDateAdded), SQLCondition.orderType.Descending);
    ...
    condition.AddOrderItem(DBEpisode.Q(DBEpisode.cDateWatched), SQLCondition.orderType.Descending);
     

    Users who are viewing this thread

    Top Bottom