- Moderator
- #1
Help plz ... How select episodes in Online Rating sort order, asc or desc, i try:
But no result
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);
}