*Web2py version:* 2.5.1-stable+timestamp.2013.06.06.15.39.19
query = ((db.auth_group.id>0) &
(db.auth_group.id==db.auth_membership.group_id) &
(db.auth_user.id==db.auth_membership.user_id) &
(auth.user.id==db.auth_user.id))
#return dict(table=query)
displayFields = [db.auth_group.id, db.auth_group.role,
db.auth_group.description]
displayHeaders = {'auth_group.role': T('Role'),
'auth_group.description' : T('Description')}
table = SQLFORM.grid(query,
fields=displayFields,
headers=displayHeaders,
deletable=False,
create=False,
editable=False,
details=False,
csv=False,
links=[lambda row: A("Edit",
_href=URL('manage_group', args=[row.auth_group.id]))],
paginate=10)
return dict(table=table)
*When I enable editable or create it will take to auth_user, but it should
take to auth_group*
--------------------------------------------------------------------------------------------
On Friday, October 25, 2013 2:45:58 AM UTC+5:30, Cliff Kachinske wrote:
>
> What version of Web2py?
>
> Can you post your code?
>
> I've been using Web2py since v 1.8 and I've never seen the behavior you
> describe.
>
> On Thursday, October 24, 2013 8:51:38 AM UTC-4, Jayakumar Bellie wrote:
>>
>> I have tried that, it did not work.
>>
>> On Thursday, October 24, 2013 12:01:05 PM UTC+5:30, Niphlod wrote:
>>>
>>> use the field_id argument to tell the grid what id should use to
>>> generate the links.
>>>
>>> On Thursday, October 24, 2013 7:39:02 AM UTC+2, Jayakumar Bellie wrote:
>>>>
>>>> That does not work.
>>>> Add button still takes to user add.
>>>>
>>>>
>>>> On Thursday, October 24, 2013 1:51:26 AM UTC+5:30, Cliff Kachinske
>>>> wrote:
>>>>>
>>>>> If you want grid to manage groups, use this query: db.auth_group.id>0.
>>>>>
>>>>> On Wednesday, October 23, 2013 4:41:46 AM UTC-4, Jayakumar Bellie
>>>>> wrote:
>>>>>>
>>>>>> 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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
