SQLFORM.smartgrid and constraint

[vivek]

Hi ,

     I been using SQLFORM.smartgrid and constraint successfully in many places. But for some reason my constraint for this particular grid isnt working

def approval():
    response.title=" Quotes waiting approval "
    response.view = 'Final/quotes/qapproval.html'
    q_comm = db.quote.status == "Approval"
    constraints = {'db.quote':q_comm}
    form = SQLFORM.smartgrid(db.quote,constraints = constraints, linked_tables=['quoteitem'],deletable=dict(quote=False,quotelines=True), editable=dict(quote=True,quotelines=True), details=dict(quote=False,quotelines=False),create=dict(quote=False,quotelines=True),links = dict(quote=[lambda row: A(SPAN(_class='icol-accept'),_href=URL("quote","convert",args=[row.id]))]),csv=False)
    return dict(form=form)

I have a common filter in my model

if auth.is_logged_in():
    if not auth.has_membership('admin'):
        db.quote._common_filter = lambda query: (db.quote.accmanager ==  auth.user_id) | (auth.user_id == 10) | (auth.user_id == 5)

Thanking all

Vivek

[Jim S]

Try changing:

constraints = {'db.quote':q_comm}

to:

constraints = {'quote':q_comm}

Does that help?

-Jim

[vivek]

Nope that doesn't help.

[vivek]

No I am wrong it works! 

Thank you so much!

[Jim Steil]

Glad to hear.

--
 
 
 

[Sairam Kolla]

Hi

I have a table called posts which have title,id,body,auth.signature as their Fields.In a view called 'Posts' i want to display a grid of all the posts made by that particular user.So in the controller i have written like this

def view():
    constraints={'created_by':auth.user_id}
    grid=SQLFORM.smartgrid(db.posts,constraints=constraints)
    return locals()


But the grid contains all the posts and there are no filtered.Can anyone help me out please....

[黄祥]

e.g.
def view():
    constraints = db.posts.created_by == auth.user_id
    grid=SQLFORM.smartgrid(db.posts, constraints = constraints)
    return locals()
   
ref:
https://groups.google.com/forum/#!topic/web2py/mtbhY19aAEA

best regards,
stifan

[Sairam Kolla]

it works!. Thankyou.I have another question.What if there are multiple queries.What is the syntax?

eg: query1= db.posts.created_by==auth.user_id

query2=db.posts.gender=='male' (assume there is a field called gender)

--
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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/cNMqkf9hmKo/unsubscribe.
To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[黄祥]

please check the book
ref:
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Logical-operators

best regards,
stifan