count() as a field in sqlform.grid

[Vlad]

The following doesn't work: 

    fields = [db.cart.id, db.cart.id.count()]


    grid = SQLFORM.grid(db.cart,
                        fields=fields,
                        left = [db.cart_content.on(db.cart.id==db.cart_content.cart)],
                        groupby=db.cart.id)

what's the best way to accomplish this? 

I simply want to count how many items in each cart. 

logically db.car.id.count() should really work here, but it doesn't.

greatly appreciate any suggestions on how to do this properly. 

[AGRogers]

Can you add a virtual field to the Cart table to do the counting for you? 

On Tue, 14 Jul 2020, 4:34 pm Vlad, <westga...@gmail.com> wrote:

The following doesn't work: 

    fields = [db.cart.id, db.cart.id.count()]


    grid = SQLFORM.grid(db.cart,
                        fields=fields,
                        left = [db.cart_content.on(db.cart.id==db.cart_content.cart)],
                        groupby=db.cart.id)

what's the best way to accomplish this? 

I simply wan to count how many items in each cart. 

logically db.car.id.count() should really work here, but it doesn't.

greatly appreciate any suggestions on how to do this properly. 

--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups "web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to web2py+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/b49bb71f-2cfc-48eb-b1a4-84d8e828b1beo%40googlegroups.com.

[Vlad]

Perfect solution for me; somehow didn't think about it - 

Thank you! 

On Tuesday, July 14, 2020 at 2:51:59 AM UTC-4, AGRogers wrote:

Can you add a virtual field to the Cart table to do the counting for you? 

On Tue, 14 Jul 2020, 4:34 pm Vlad, <westga...@gmail.com> wrote:

The following doesn't work: 

    fields = [db.cart.id, db.cart.id.count()]


    grid = SQLFORM.grid(db.cart,
                        fields=fields,
                        left = [db.cart_content.on(db.cart.id==db.cart_content.cart)],
                        groupby=db.cart.id)

what's the best way to accomplish this? 

I simply wan to count how many items in each cart. 

logically db.car.id.count() should really work here, but it doesn't.

greatly appreciate any suggestions on how to do this properly. 

--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups "web2py-users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to web...@googlegroups.com.