query=(db.project.created_by==auth.user) & (db.project.is_active==True)
is the query that check wheter the database table project is created by the current authenticate user *AND *the database table status is active i think if you want to show the database table project is created by the current authenticate user please use just db.project.created_by==auth.user so the code will be : query=db.project.created_by==auth.user grid=SQLFORM.grid(query, user_signature=False, onupdate=auth.archive) it's just copas from my exsisting code that i've ever used. hope this can help you to show the project which is own (created) by the current user -- --- 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/groups/opt_out.
