Please show the full traceback.
On Tuesday, June 5, 2018 at 9:52:52 AM UTC-4, kakella wrote:
>
> Need some insights into the below issue. The functionality is working
> correctly in the SQLForm.grid but doesn't work when returning data as json
> under certain circumstances as mentioned below.
>
> When using the rows.render and passing multiple fields as argument there
> is an
> exception "web2py.app.projectmgmt - WARNING - 'NoneType' object has no
> attribute 'first_name'"
>
> the exception is happening on the db.environment.onboarding_resource. When
> the represent for the Field is removed in the model it works as expected by
> returning the username correctly. It is not working when trying to return
> the first and last names.
>
> def getenvironments():
> rows = list()
> try:
> rows = db(db.environment).select()
> #Below works
> print rows.render(0, fields=[db.environment.onboarding_resource])
> # Below throws an exception ( 'NoneType' object has no attribute
> 'first_name')
> print rows.render(0,
> fields=[db.environment.onboarding_resource,db.environment.request])
> except Exception as e:
> logger.warn(str(e))
> return response.json(rows)
>
> Model definition
> --------------------------------------------
>
> db.define_table('environment',
> Field('request', db.request,
> requires=IS_EMPTY_OR(IS_IN_DB(db, 'request.id','%(requested_item)s
> %(alt_CI_ID)s'))),
> Field('onboarding_resource', db.auth_user,
> represent = lambda id, row: '%s %s'
> %(db.auth_user(id).first_name,db.auth_user(id).last_name),
> requires=IS_EMPTY_OR(IS_IN_DB(db,
> 'auth_user.id','%(first_name)s
> %(last_name)s'))),
> Field('delivered_date', type='date'),
> Field('missed_reason', db.missed_reason,
> requires=IS_EMPTY_OR(IS_IN_DB(db,'missed_reason.id
> ','%(reason_code)s'))))
>
>
>
>
--
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/d/optout.
