When you send the query as you defined to SQLForm, it creates the list.
When you click on add it takes to auth_user add, but it should take to
auth_group add.
On Tuesday, October 22, 2013 4:11:17 PM UTC+5:30, Cliff Kachinske wrote:
>
> This defines a set of Row objects.
> query = db((db.auth_group.id==db.auth_membership.group_id) & (
> db.auth_user.id==db.auth_membership.user_id) & (db.auth_user.id==
> auth.user.id)).select(db.auth_group.ALL)
>
> This is how you define a query object.
> query = ((db.auth_group.id==db.auth_membership.group_id) & (
> db.auth_user.id==db.auth_membership.user_id) & (db.auth_user.id==
> auth.user.id))
>
> On Tuesday, October 22, 2013 2:05:12 AM UTC-4, Jayakumar Bellie wrote:
>>
>> How does that matter the my query?
>> I have to give some where condition.
>> Can you elaborate.
>>
>>
>> On Friday, October 18, 2013 9:05:06 PM UTC+5:30, villas wrote:
>>>
>>> HI Jayakumar
>>>
>>> Try using a query rather than a rows object.
>>>
>>> For example, rather than:
>>> query = db().select(db.auth_user.ALL) ## gives a rows object,
>>> unusable by grid
>>>
>>> Use this:
>>> query = db.auth_user.id>0
>>>
>>> Hope you get the idea.
>>> Best regards, D
>>>
>>>
>>>
>>> On Friday, 18 October 2013 06:43:24 UTC+1, Jayakumar Bellie wrote:
>>>>
>>>> Hi,
>>>>
>>>> I want to fetch all the auth_group list of a user from auth_user
>>>> mapping auth_membership.
>>>>
>>>> ---------------------------------------------
>>>> query = db((db.auth_group.id==db.auth_membership.group_id) & (
>>>> db.auth_user.id==db.auth_membership.user_id) & (db.auth_user.id==
>>>> auth.user.id)).select(db.auth_group.ALL)
>>>> * # When I do the return over here, I am able to see the required
>>>> data. But when I send it to the SQLFORM.grip it through the execption
>>>> given
>>>> below*
>>>> * #return dict(table=where)
>>>>
>>>>
>>>> *
>>>> displayFields = [db.auth_group.role, db.auth_group.description]
>>>> displayHeaders = {'auth_group.role': T('Role'),
>>>> 'auth_group.description' : T('Description')}
>>>> table = SQLFORM.grid(query,
>>>> #left=left,
>>>>
>>>>
>>>>
>>>> fields=displayFields,
>>>> headers=displayHeaders,
>>>> deletable=False,
>>>> create=True,
>>>> editable=False,
>>>> details=False,
>>>> csv=False,
>>>> links=[lambda row: A("Edit",
>>>> _href=URL('manage_group', args=[row.id]))],
>>>>
>>>> paginate=10)
>>>> return dict(table=table)
>>>>
>>>> ---------------------------------------------
>>>>
>>>> Traceback (most recent call last):
>>>> File "/home/www-data/web2py/gluon/restricted.py", line 212, in restricted
>>>> exec ccode in environment
>>>> File
>>>> "/home/www-data/web2py/applications/Telematics/controllers/group.py"
>>>> <http://127.0.0.1:8000/admin/default/edit/Telematics/controllers/group.py>,
>>>> line 64, in <module>
>>>> File "/home/www-data/web2py/gluon/globals.py", line 194, in <lambda>
>>>> self._caller = lambda f: f()
>>>> File "/home/www-data/web2py/gluon/tools.py", line 3022, in f
>>>> return action(*a, **b)
>>>> File
>>>> "/home/www-data/web2py/applications/Telematics/controllers/group.py"
>>>> <http://127.0.0.1:8000/admin/default/edit/Telematics/controllers/group.py>,
>>>> line 22, in list_groups
>>>> paginate=10)
>>>> File "/home/www-data/web2py/gluon/sqlhtml.py", line 1861, in grid
>>>> db = query._db
>>>> AttributeError: 'Rows' object has no attribute '_db'
>>>>
>>>>
--
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/groups/opt_out.
