framework icon indicating copy to clipboard operation
framework copied to clipboard

paginate doesn't count distinct

Open dotku opened this issue 3 years ago • 0 comments

eg here is the data

{
  "total": 4441,
  "per_page": 15,
  "current_page": 1,
  "last_page": 297,
  "data": [
    {
      "deviceID": 201,
      "useFromDate": "2021-07-22",
      "useToDate": "2021-08-09"
    },
    {
      "deviceID": 247,
      "useFromDate": "2021-08-12",
      "useToDate": "2021-08-17"
    },
    {
      "deviceID": 233,
      "useFromDate": "2021-09-20",
      "useToDate": "2021-12-12"
    }
  ]
}

There are only 3 row result by distinct, but actually with 4441 report. It seems distinct is ignored.

dotku avatar Feb 28 '22 08:02 dotku