分表之后的报表查询问题

[aaa930811]

文档中写了没分表的情况，但是如果我想要获取最新的一张表的报表不知道该这么写，我尝试了一下报错

    List<DateTime> dts = GetTimeIntervals(startTime, endTime, intervalMinutes);
    var result = _dbClient.Reportable(dts)
                    .ToQueryable<DateTime>()
                    .SplitTable(t => t.Take(1))
                    .LeftJoin<AccessLogSplitEntity>((it, o) => o.CreateTime >= it.ColumnName && o.CreateTime <= it.ColumnName.AddMinutes(intervalMinutes))
                    .GroupBy(it => it.ColumnName)
                    .Select((it, o) => new
                    {
                        Time = it.ColumnName,
                        Count = SqlFunc.AggregateCount(o.Id)
                    }).ToList();

[aaa930811]

这个SplitTable(t => t.Take(1))该写在哪个地方？

[DotNetNext]

var queryable2=xxxxxSplitTable(t => t.Take(1)); Leftjoin(queryable2,xxxxx=yyyy)

[aaa930811]

     public List<AccessRealtimeCount> GetTodayMinuteAccessCount()
     {
         DateTime startTime = DateTime.Today;  // 今天的零点时间
         DateTime endTime = DateTime.Now;      // 当前时间
         int intervalMinutes = 5;

         List<DateTime> dts = GetTimeIntervals(startTime, endTime, intervalMinutes);

         var q2 = _dbClient.Queryable<AccessLogSplitEntity>().SplitTable(tb => tb.Take(1));
         var result = _dbClient.Reportable(dts).ToQueryable<DateTime>()
                         .LeftJoin<AccessLogSplitEntity>((it, q2) => q2.CreateTime >= it.ColumnName && q2.CreateTime <= it.ColumnName.AddMinutes(intervalMinutes))
                         .GroupBy(it => it.ColumnName)
                         .Select((it, q2) => new
                         {
                             Time = it.ColumnName,
                             Count = SqlFunc.AggregateCount(q2.Id)
                         }).ToList();

         return result.Select(x => new AccessRealtimeCount
         {
             Time = x.Time.ToString("yyyy-MM-dd HH:mm:ss"),
             Count = x.Count
         }).ToList();
     }

还是报错

[aaa930811]

谢谢，已解决