Hi Jim, I had this issue some time ago and I solved it by the workaround of using len(db(query).select()). The count()-method is a little more performant, but in my case it didn't matter. If you need the rows object of the select for further processing anyway, you can have the len() on the rows object.
It's not perfect, but it works :-) Best regards Clemens On Thursday, August 20, 2020 at 8:52:15 PM UTC+2 Jim S wrote: > Hi > > I'm trying to get the count of records to be returned in a query using: > > db(query).count() > > Adding complexity to the situation is that query may sometimes be over > multiple tables with need a left clause added. When selecting records you > do this by passing the left= parameter inside the .select(). > > But, you can't pass anything into the .count() method. > > Has anyone found an efficient way to get a .count() when a left join is in > use? > > -Jim > > (cross-posting to py4web as well) > > -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/b1340a93-6f05-4c0d-b7c5-59d18423eed1n%40googlegroups.com.
