appsync_date_filter.dart

var start = DateTime.now()

var db = await appSync.getCacheDatabase();

var pages = appSync.paginate(
  ..., 
  priority: CachePriority.cache, // Try cache first, then network
  cache: db,
);

// get records between this range
var dateRange = [
  DateTime.now().subtract(Duration(days: 7)),
  DateTime.now().subtract(Duration(days: 3)),
];

// convert to timestamps
var dateRangeMs = dateRange.map((x) => x.millisecondsSinceEpoch).toList();

var results = pages
  // Dart's version of FlatMap. (Combines records from pages into a single list)
  .expand((x) {
    return x['listLessons']['items'];
  })
  // filter by 'updatedAt'
  .where((x) {
    return x['updatedAt'] != null &&
        dateRangeMs[0] < x['updatedAt'] &&
        x['updatedAt'] < dateRangeMs[1];
  })
  .toList();

var end = DateTime.now()
print('Time taken: ${end.difference(now)});