It appears that placing the 'common_filter' in the table definition together with the speical field 'request_tenant' is problematic. However, doing
db.bank.common_filter = lambda query: db.bank.company_id == get_default_company_id() seem to also work with no issues. On Saturday, 23 January 2016 06:12:06 UTC, Seraaj Muneer wrote: > > I think I figured it out. Using the table property 'common_filter' AND the > special field 'request_filter' on the same table is what was causing it. > Removing one of those fixed the issue for me. > > It appears the two multi-tenant helpers are mutually exclusive > > On Saturday, 23 January 2016 06:07:02 UTC, Seraaj Muneer wrote: >> >> Web2py 2.13.4. Essentially the code in the original post here is all >> there is in the app. Initially, it was working just fine, then it suddenly >> stopped with that error. >> >> On Saturday, 23 January 2016 04:14:47 UTC, Anthony wrote: >>> >>> What version of web2py? Can you attach a minimal app that reproduces the >>> problem? >>> >>> On Friday, January 22, 2016 at 6:26:18 PM UTC-5, Seraaj Muneer wrote: >>>> >>>> That was just a typing error when I was writing the message here. It's >>>> actually correctly defined in my code. >>>> On 22 Jan 2016 23:08, "Derek" <[email protected]> wrote: >>>> >>>>> company_field_id and company_id_field are not the same. Look closely. >>>>> >>>>> On Friday, January 22, 2016 at 3:29:47 PM UTC-7, Seraaj Muneer wrote: >>>>>> >>>>>> Hello everyone again, still taking web2py for a spin but encountering >>>>>> some really strange errors. >>>>>> >>>>>> Here is my data definition >>>>>> >>>>>> company_field_id = 'company_id' >>>>>> >>>>>> >>>>>> db.define_table('bank', Field('bank_name', 'string', length=25, >>>>>> represent=lambda bank_name, row: bank_name.upper(), >>>>>> required=True, >>>>>> unique=True, notnull=True, >>>>>> ), >>>>>> Field('default_branch', 'string', default='', length=25, >>>>>> requires=[IS_EMPTY_OR(IS_MATCH('^[a-zA-Z][a-zA-Z ]*$'))]), >>>>>> Field(company_id_field, 'reference company', notnull=True, ondelete= >>>>>> on_delete_cascade, >>>>>> writable=False, readable=False), Field('request_tenant', default= >>>>>> auth.user_id, writable=False), >>>>>> auth.signature, common_filter=lambda query: db.bank.company_id == >>>>>> get_default_company_id(), >>>>>> format=lambda r: r.bank_name or 'No bank name!') >>>>>> db.bank.bank_name.requires = [IS_NOT_EMPTY(error_message='You must >>>>>> enter a bank name'), >>>>>> IS_MATCH('^[a-zA-Z][a-zA-Z ]*$', >>>>>> error_message='Bank name can only contain alphabets (A-Z)'), >>>>>> IS_NOT_IN_DB(db, db.bank.bank_name, error_message='Bank name must >>>>>> be unique.')] >>>>>> >>>>>> db.bank._before_insert.append( >>>>>> lambda f: f.update( >>>>>> company_id=get_default_company_id())) >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> and here is my controller >>>>>> >>>>>> >>>>>> @auth.requires_login() >>>>>> def show(): >>>>>> db(db.company.id > 0).count() or redirect(URL('company', 'create')) >>>>>> form = SQLFORM.smartgrid(db.bank) >>>>>> return dict(form=form) >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> and here is my view >>>>>> >>>>>> >>>>>> {{extend 'layout.html'}} >>>>>> {{=form}} >>>>>> >>>>>> >>>>>> >>>>>> Nothing I do gets this to work. Web2py always returns the error as per >>>>>> the screenshot attached. I've done a great deal of googling to no avail. >>>>>> Whats wrong? >>>>>> >>>>>> -- >>>>> 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 a topic in the >>>>> Google Groups "web2py-users" group. >>>>> To unsubscribe from this topic, visit >>>>> https://groups.google.com/d/topic/web2py/fOfE_wct24Q/unsubscribe. >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> [email protected]. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
