Thanks that worked :)
On Friday, October 25, 2013 3:34:03 PM UTC+5:30, Cliff Kachinske wrote:
>
> Ah, now I understand what you are trying to do.
>
> This works for me in that the Add button takes me to auth_group. You will
> have to define an oncreate function to link the new group back to the user,
> by the way. RTFM for that.
>
> Stare at my query until you understand how it works.
>
> The controller is named auth_group.py.
>
> @auth.requires_login()
> def index():
> query = (
> (db.auth_group.id==db.auth_membership.group_id) &
> (db.auth_membership.user_id==auth.user.id)
> )
> form = SQLFORM.grid(query)
> return dict(form=form)
>
> On Friday, October 25, 2013 2:34:07 AM UTC-4, Jayakumar Bellie wrote:
>>
>> *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.
