konsta
07/21/2022, 8:02 AMconst { field } = params
const { priority, status } = query
const groups = await db.issue.groupBy({
where: {
priority: {
in: priority,
},
status: {
in: status,
},
},
by: [field],
_count: true,
orderBy: {
[field]: 'desc',
},
})
return groups
returns
[
{
"_count": 338,
"status": "open"
},
{
"_count": 312,
"status": "in review"
},
{
"_count": 359,
"status": "in progress"
},
{
"_count": 314,
"status": "done"
},
{
"_count": 366,
"status": "canceled"
},
{
"_count": 329,
"status": null
}
]
let's say to something generic like "status" -> "group"?Nurul
07/21/2022, 8:06 AMkonsta
07/21/2022, 8:11 AMLloyd Richards
07/21/2022, 9:28 AMreturn groups.map((d)=>({...d, group: d[field]}));
konsta
07/23/2022, 5:09 PM