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.
