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.
