public void GetUsernameHighscore() { ResetList(); Highscore score = GetScore(); string filterPredicate = string.Format("username eq '{0}'", score.username); var orderBy = new OrderBy("score", SortDirection.desc); TableQuery query = TableQuery.CreateWithOrderBy(orderBy); query.Filter = filterPredicate; Query(query); }
public void GetTopHighscores() { ResetList(); DateTime today = DateTime.Today; string day = today.ToString("s"); string filterPredicate = string.Format("createdAt gt '{0}Z'", day); Debug.Log("filter:" + filterPredicate); var orderBy = new OrderBy("score", SortDirection.desc); //TableQuery query = new TableQuery (filterPredicate, 10, 0, null, TableSystemProperty.nil, false, orderBy); TableQuery query = TableQuery.CreateWithOrderBy(orderBy); query.Top = 10; query.Filter = filterPredicate; Query(query); }