通常在传统数据库中,我会执行以下操作来获得按客户Id分组的订单数(顶部最高(。这在伊萨尔有可能吗?
SELECT TOP (200) Id, COUNT(*) AS Total
FROM Orders
GROUP BY Id
ORDER BY Total DESC
final query = _isarService.isar.orders
.filter()
.customerIdEqualTo(customerId);
不确定我下一步会做什么?
您可以使用queryBuilder
像这样的东西可能会帮助你
final donors = await isar.donorModels
.buildQuery<DonorModel>(
limit: limit,
filter: const FilterCondition.equalTo(
property: r'customerId',
value: customerId,
),
)
.findAll();