In a network application I've got the following query:
rows = db((db.edg_edge.fromID==vertexID) &
(db.edg_edge.toID==db.vtx_vertex.id) &
(db.lct_address.label==PHYSICALADDRESSID)).select(db.edg_edge.ALL,
db.vtx_vertex.ALL, db.lct_address.ALL, db.wb_app.apptypeID,
left=(db.lct_address.on(db.vtx_vertex.id==db.lct_address.vertexID),
db.wb_app.on(db.vtx_vertex.id==db.wb_app.vertexID)),
orderby=db.vtx_vertex.name)
This query selects the vertices multiple times, in the view I only need
each vertex once. Is there
a way to solve this issue with a dictinct = True on db.vtx_vertex.id
Kind regards,
Annet
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
