This is not supported because I am not sure all supported RDBS support count(distinct ...).
As a way around it you can do len(db().select(db.item.of_variant,distinct=True)) Massimo On Jan 28, 6:32 am, vortex <billyara...@gmail.com> wrote: > How to do a count distinct with DAL? > > like: > > db().count(db.item.of_variant, distinct=True)