Hi, I have a feeling this is quite easy to do but can't find an elegant way of doing it.
I'm building a book application for an client, the book has chapters and articels in it. Every book has an editor and every articel has a writer and cowriter. There will be maybe 20 books. Every editor and writer will be inserted into auth_user and will have permission to edit their own articels, so that the editor can edit all articels in his/hers book. Now I'd like to find all articels "belonging" to a person either via direct "ownership" of articels or via bookownership. I can find all books belonging to the person and then all articels that way. But finding all other articels will also contain all articels in bookownership. books = db(t.book.f_editor = auth.user['id']).select() articels = db(t.article.f_writer = auth.user['id']) & (t.articel.f_book == not in books).select() How is this written in DAL? Kenneth -- --- 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/groups/opt_out.
