aggregationPipeline.dart

gistfile1.txt

final aggSteps = [
  {
    "\$match": {
      "region.itemRefID": "6268a16f964b7b20e3d6beb2",
      "reportType.itemRefID": {"\$ne": "60fbda43f3b16318ac07c79c"},
      "reportStatus._id": "c2rmj8223akg00drt34g",
    },
  },
  {
    "\$sort": {
      "_createdDate": -1,
    },
  },
  {
    "\$project": {
      "_createdDate": 0,
      "_lastUpdatedDate": 0,
      "solved": 0,
      "solvedBy": 0,
      "comments": 0,
      "coordinates": 0,
    },
  },
  {
    "\$limit": 20,
  },
  {
    "\$skip": 5,
  },
];

BagelResponse response =
          await db.collection('reports').aggregationPipeline(aggSteps).get();

      print(json.encode(response.data));