i have a table that have list:reference type of field.
just wondering, is it possible to have search query list:reference multiple
true?
when i test it the form.vars value of list:reference is translate into
__1____2__
and the query result is not shown as expected because i assume the value of
form field is __1____2__ and passed it to the query to the database
e.g.
count_space_ship = db(db.space_ship.id > 0).count()
def vessel_form():
redirect_url = 'report_vessel'
form = SQLFORM.factory(
Field("space_ship", "list:reference space_ship",
label = T('Space Ship'),
requires = IS_IN_DB(db(), db.space_ship.id, db.space_ship._format,
multiple = (1, count_space_ship) ) ) )
if form.process(onvalidation =
trucking_report.onvalidation_form_report).accepted:
space_ship = form.vars.space_ship
response.new_window = URL(redirect_url, args = [space_ship] )
elif form.errors:
response.flash = T('Form has errors')
return dict(form = form)
def report_vessel():
space_ship = request.args(0)
if vessel != 'None' and space_ship != 'None':
query_delivery_order = ((db.delivery_order.space_ship.contains(space_ship)
) )
sum_delivery_order_net = db.delivery_order.net.sum()
delivery_order_net =
db(query_delivery_order).select(sum_delivery_order_net).first()[sum_delivery_order_net]
if not db(db.delivery_order).isempty() else 0
delivery_order_net_result = delivery_order_net if delivery_order_net else 0
return dict(from_datetime = from_datetime, to_datetime = to_datetime,
vessel = vessel, space_ship = space_ship,
query_delivery_order = query_delivery_order, delivery_order_net_result =
delivery_order_net_result)
any idea how to achieve it using web2py way?
best regards,
stifan
--
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.
