"as_trees" works great, but but how to remove the "Row<" verbiage from the result? You mentioned "serialize the result into json". Can you please show example? At the current stage, the data looks like this:
[<Row {'modified_by': 2L, 'name': 'Requirements', 'relationship_depth': 1L, 'title': 'Object Super Object', 'child_original_identity_fk': None, 'is_active': True, 'parent_row_id': None, 'id': 102L, 'ancestor_descendant_comments': None, 'created_on': datetime.datetime(2019, 3, 20, 10, 10, 39), 'parent_fk': None, 'child_role_fk': None, 'created_by': 2L, 'organization_fk': 1L, 'modified_on': datetime.datetime(2019, 3, 20, 10, 10, 39), 'children': [<Row {'modified_by': 2L, 'name': 'PDF Layered presentation', 'relationship_depth': 1L, 'title': 'Role Member', 'child_original_identity_fk': 457L, 'is_active': True, 'parent_row_id': 102L, 'id': 103L, 'ancestor_descendant_comments': None, 'created_on': datetime.datetime(2019, 3, 20, 10, 10, 39), 'parent_fk': 658L, 'child_role_fk': 537L, 'created_by': 2L, 'organization_fk': 1L, 'modified_on': datetime.datetime(2019, 3, 20, 10, 10, 39), 'children': []}>, <Row {'modified_by': 2L, 'name': 'Albert Einstein', 'relationship_depth': 1L, 'title': 'Role Member', 'child_original_identity_fk': 1244L, 'is_active': True, 'parent_row_id': 102L, 'id': 104L, 'ancestor_descendant_comments': None, 'created_on': datetime.datetime(2019, 3, 20, 10, 10, 39), 'parent_fk': 701L, 'child_role_fk': 1380L, 'created_by': 2L, 'organization_fk': 1L, 'modified_on': datetime.datetime(2019, 3, 20, 10, 10, 39), 'children': []}>, etc.... thanks, Alex Glaros -- 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.