It is a bug. Please open a ticket about this (there may actually already be a ticket about this).
On Monday, 10 June 2013 05:25:26 UTC-5, Domagoj Kovač wrote: > > I found the solution to my problem but i still dont understand why this > doesnt workd like it should. > > Line: > rows = db().select(db.country.ALL, limitby=limit_by) > > Must be: > rows = db(db.country.id > 0).select(db.country.ALL, limitby=limit_by) > > And then request_teneant = 3 is added as a condition giving me what i want. > > SELECT country.id, country.name, country.alpha_2_code, country.alpha_3_code, > country.numeric_code, country.request_tenant FROM country WHERE ((country.id > > 0) AND (country.request_tenant = '3')) ORDER BY country.id LIMIT 30 OFFSET > 0; > > > Why multitenancy doesnt work without any extra conditions? > -- --- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.

