Got error when I put 'fields' as an argument to SQLFORM.grid

[at]

Here is the code:

`fields=['id', 'name']`

`grid = SQLFORM.grid(db.engagement, fields=fields)`

Error:
`AttributeError('str' object has no attribute 'tablename')`

[Jim S]

Can you try with the field in the format:

db.tablename.fieldname

ex:

fields = [db.engagement.id, db.engagement.name]

-Jim

[Muhammad Atif Ayaz]

Thank you Jim, it works.

Do you think a way that can help dynamically making a list of all fields of a table and then we can remove specific fields from it.

Like the following which produces the required list but in the desired data-type:
fields = [fld for fld in db.engagement.fields if fld!='token']

grid = SQLFORM.grid(db.engagement, fields=fields)

--
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 a topic in the Google Groups "web2py-users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/web2py/Ym3zsLYNePg/unsubscribe.
To unsubscribe from this group and all its topics, send an email to web2py+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/e19daf19-95c7-4e46-88da-74882bd4e51an%40googlegroups.com.

[Jim Steil]

What is wrong with using the example you provided?

-Jim

To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/CAFpY7yFSRZMRPY02sHJtxGasp3T%3Dy7sRdqbq58KncYDdDpkXDg%40mail.gmail.com.

[Muhammad Atif Ayaz]

It gives error: `AttributeError('str' object has no attribute 'tablename')`

The reason is that the field names are in string format not in db.tablename.fieldname format

To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/CAERBpoCjJrCe_3W1Nq%3DZKh8wFc-e8stoHOpMzDwxMHfbFjexKA%40mail.gmail.com.

[valq...@gmail.com]

db.table['fieldname']

четверг, 28 января 2021 г. в 07:31:04 UTC+3, at:

[Muhammad Atif Ayaz]

Thank you very much!

To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/3b718aef-ec6a-45d3-9c6a-7ae039ae787an%40googlegroups.com.