Hi there,
I am very new to web2py, i posted 1 question here a week ago, but never got
reply (if anyone sees my post, please let me know if I missed anything), I
am trying luck with another question now.
I have a customer table, an invoice table and an item table. I simplified
them below:
db.define_table('customer', Field('company_name', requires=IS_NOT_EMPTY()),
auth.signature, format='%(company_name)s')
db.define_table('invoice', Field('customer', 'reference
customer'), Field('project_name', requires=IS_NOT_EMPTY()))
db.define_table('item', Field('invoice', 'reference invoice',
writable=False), Field('description'), Field('unit_price', 'double'))
When I used smartgrid without specifying the constraints below, the
linked_tables 'Items' worked correctly (i.e. i clicked Items link, it
showed me all the items belongs to that particular invoice), but obviously
i could not select a particular set of invoices based on a customer id.
when I added the constraints, i could select the particular invoices based
on the given customer id, but the linked_tables 'Items' broke with this
error message - Query Not Supported: invalid literal for long() with base
10: 'item'. The URL got redirected from
http://localhost:8000/connect28/accounting/view_invoices/invoice/item.invoice/10?_signature=0653b123ba6f4b43b82c48d49516af9c772b1496
to http://localhost:8000/connect28/accounting/view_invoices/item. Any help
and pointers is much appreciated.
def view_invoices():
customer_id = request.args(0)
if customer_id:
invoice_query=db.invoice.customer==customer_id
else:
invoice_query=db.invoice.customer!=None
constraints=dict(invoice=invoice_query)
db.item.invoice.writable=False #avoid invoice # from any particular row
in item table get overwritten
invoice_grid = SQLFORM.smartgrid(db.invoice, constraints=constraints)
return locals()
--
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.
