Displaying Data in a Datagrid from complex query results

[hugetim]

I don’t think there is, generally, though one option is to convert to List/Dict and then inspect that. Searching around the forum, here’s one helpful post:

Working with Table and Row objects?

I often want to inspect Table and Row objects. Four things I’m trying to do and their gross workarounds: ‘Get’ from a row object if the column exists: if 'my_column' in dict(row_object): value = row_object['my_column'] else: value = None Find out if an object is a row object: hasattr(row_object, 'get_id') # type(row_object) gives anvil._server.LiveObjectProxy There must be a better way!! Any ideas? SOLVED: Credit to stucork: Figure out the Table a row is associated with: tables…

And here are a couple relevant Feature Requests:

More informative repr of LiveObjects

also, print repr(some_table_row) should return more than: <LiveObject: anvil.tables.Row> how about: what table? current key/value pairs?

Get app_table table object by table ID

I’ve noticed the same thing. As I understand it, however, this particular representation of row ids is subject to change without notice, so I’m reluctant to depend on it in any way. I’d like to suggest a slightly different idea, one that does not depend on the internal structure of a row id. E.g., app_tables.get_table_by_row_id(s) where s is any string containing a row id. In short, let Anvil pick it apart for you. That way, when the representation changes, it will be Anvil’s responsibili…

You might want to add a Feature Request (which I would support) for making SearchIterators more transparent, though there might be some cost to doing that beyond my understanding. (Here’s one aspect of SearchIterators I was not clear on, for instance.)