So I have this tables:
if not "board" in db.tables:
db.define_table("board",
Field("title", label=T('Title')),
Field("description", 'text', label=T('Description')),
auth.signature,
format = "%(title)s"
)
if not "text_type" in db.tables:
db.define_table("text_type",
Field("title", label=T('Title')),
Field("body", 'text', label=T('Content')),
Field("board", 'reference board', label=T('Board')),
auth.signature,
format = "%(title)s"
)
if not "url_type" in db.tables:
db.define_table("url_type",
Field("url", label=T('URL')),
Field("board", 'reference board', label=T('Board')),
auth.signature,
format = "%(title)s"
)
if not "image_type" in db.tables:
db.define_table("image_type",
Field("upload_image", 'upload', label=T('Upload Image')),
Field("board", 'reference board', label=T('Board')),
auth.signature,
format = "%(title)s"
)
if not "video_type" in db.tables:
db.define_table("video_type",
Field("url_video", label=T('Video URL')),
Field("board", 'reference board', label=T('Board')),
auth.signature,
format = "%(title)s"
)
All the four last tables have a common field that references board. Now I
need to select all the records of this four tables that reference the same
board and sort them by the created_on field, like:
board_id = int(request.args(0))
topics = db((db.text_type.board == board_id)&(db.image_type.board ==
board_id)&(db.video_type.board ==
board_id)...).select(orderby=db.table.created_on)
But it doesn't work and I don't understand why.
--
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.
