Hi Cliff, Sorry for my late reply and incomplete first answer:
Table node contains a computed field. See manual: Notice that the computed value is stored in the db and it is not computed on retrieval, as in the case of virtual fields, described later. A typical application of computed fields is: for searching, to compute normalized values for a field, to be used for searching. In the query I left join organization, person an connector with node and sort by db.node.computedName. In the view organization and person details are treated differently, therefore I use row.organization.name, row.person.first_name and row.person.last_name and row.connector.name. When a user updates organization, person or connector, the node computed field is updated by calling updateComptedName(form) on accept: form=crud.update(...,onaccept=lambda form:updateComputedName(form),...) Kind regards, Annet --
